SP_RENAME

What is SP_RENAME? If you have objects in your database that you […]

AT TIME ZONE

What is AT TIME ZONE? Who doesn’t know it? You’re in Seeheim […]

STRING_ESCAPE

What is STRING_ESCAPE? You have already learned about some functions for manipulating […]

STRING_SPLIT

What does STRING_SPLIT do? Over the weeks you’ve gotten to know some […]

TRANSLATE

What is TRANSLATE (not)? Unfortunately, ‘TRANSLATE’ is not the T-SQL syntax as […]

CONCAT and CONCAT_WS

What do CONCAT and CONCAT_WS do? The CONCAT function is a function from the […]

STRING_AGG

What is STRING_AGG? Last week you saw how to use STUFF and SELECT FOR XML to […]

STUFF

What’s STUFF? STUFF is a function for manipulating strings. The function “stuffs” one […]

PERCENTILE_CONT

What does PERCENTILE_CONT do? The last time you worked in the Dojo […]