Earlier today I was experiencing issues with my PC and the GUI for SQL Agent jobs wasn't appearing on screen. I really needed to stop a job that had become stuck over the weekend, so I turned to T-SQL and...
Read More
Earlier today I was experiencing issues with my PC and the GUI for SQL Agent jobs wasn't appearing on screen. I really needed to stop a job that had become stuck over the weekend, so I turned to T-SQL and...
Read More
UNION and UNION ALL are used for joining two or more datasets together. The datasets need to return the same number of columns. The columns names of all datasets can be different, however, the final results will have their columns...
Read More
FORMAT is a function that is used return a NVARCHAR data type from a date/time or number. You can still use CAST or CONVERT for these and all other conversions. FORMAT is just another option that was introduced in SQL...
Read More
The SOME, ANY and ALL are logical operators that compare against a scalar value. This article is a simple overview of how they work.
[crayon-662b1bc24536a498416125/]
Within SQL Server, SEQUENCE is a numeric order that has been defined by it's creator. The SEQUENCE can be generated in either an ascending or descending order, it can have intervals (gaps) within it's numbers and it can restart itself...
Read More