‘Code Snippet’ Articles
How To Select Rows From Table Based On Time Value in DateTime Column
T-SQL code snippet for selecting rows from a database table based on time values in the datetime field.
T- Sql To Concatenate A Table Column’s Values Into A Csv String
1 line T-Sql code snippet to concatenate a table column’s values into A csv string
Get the Number of CPUs on a ‘SQL Server’ Machine
Script to get the number of physical and logical CPUs (processors) on a ‘SQL Server’ Server Machine.
Get Row Counts, Column Counts, Data Sizes For All Tables
T-SQL Script to get the row counts, column counts and data sizes for all the tables in a database.
Truncate All Tables In Database Using sp_MSforeachtable
1 line script to truncate all tables in a database
Get The Number Of Days In The Current Month
T-SQL (SQL Server) code snippet to get the number of days in the current month.
-
-
Subscribe
Search
