Counting Bits II

How to use @@ROWCOUNT in SQL Server

I would like to know the number of rows affected by my SQL Server query. I know this is displayed as a message in SQL Server Management Studio, but I have to check the number of rows in an IF statement to verify if everything went alright. How can I do this in SQL Server?

CHOOSing an Alias

Dates and Languages

Add and Subtract Dates using DATEADD in SQL Server

Date manipulation is a common scenario when retrieving or storing data in a Microsoft SQL Server database. There are several date functions (DATENAME, DATEPART, DATEADD, DATEDIFF, etc.) that are available and in this tutorial, we look at how to use the DATEADD function in SQL queries, stored procedures, T-SQL scripts, etc. for OLTP databases as well as data warehouse and data science projects.

Counting Bits

Sparse Column Defaults

Escaping Like I

The Lesser Used Functions

There have been a number of changes to the T-SQL language that are very specialized. Steve asks if you use any in your code?

SQL Server OPTION RECOMPILE for Simple Queries

Learn about SQL Server OPTION RECOMPILE and if used on simple, frequently executed queries if it causes excessive CPU usage.