I had the challenge of putting together a T-SQL statement that's going to be used in a few stored procedures. The stored procedures will build data based on what todays date is, if today is greater than second Tuesday of...
Read More
I had the challenge of putting together a T-SQL statement that's going to be used in a few stored procedures. The stored procedures will build data based on what todays date is, if today is greater than second Tuesday of...
Read More
We've decided that SQL Repository are going to start recording some SQL development videos for YouTube. I am preparing the PC for these videos and wanted to install SQL Server Reporting Services (SSRS) 2012. However, once the installation had completed...
Read More
INTERSECT and EXCEPT are operators within SQL Server that takes data from two queries and compares the results.
INTERSECT returns the distinct values from both the left query and right query.
EXCEPT is different as it returns...
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 MoreSQL Server use role based security, which allows Database Administrators to assign particular permissions to users and groups. SQL server has a set of fixed roles at both the server and database levels and user-defined roles can also be created...
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-662c3e693cb9b351823325/]
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