MSSQL Query

MSSQL and TSQL Programming and TSQL Examples

MSSQL Query Blog

SQL Server

Comma-Separating Table Columns into Lists in SQL Server

Hello everyone, In this article, I will try to give information about separating table columns with commas and making them a list in SQL Server. In SQL Server, in some cases, the number of columns in your table may be high. Instead of typing the column names one by one...

SQL Server

MSSQL Support End Dates in SQL Server

Hello everyone, In this article, I will try to give information about the MSSQL support termination dates in SQL Server. Below are Microsoft’s end of support dates for SQL Server versions. ↓SQL Server 2019 15.0.2000.5 Version: 15.0 Mainstream support end: Jan 14, 2025 Extended support end: Jan 8, 2030 ↓SQL...

SQL Server

Seeing Table Sizes in SQL Server

Hello everyone, In this article, I will try to give information about seeing table sizes in SQL Server. In SQL Server you may want to see table sizes in some cases. You can easily do this using the code below. SELECT t.name AS TableName, s.name AS SchemaName, p.rows AS RowCounts,...

SQL Server

Updating Statistics with Cursor in SQL Server

Hello everyone, In this article, I will try to give information about updating Statistics with Cursor in SQL Server. Although Statistics are updated automatically in SQL Server, sometimes they need to be updated manually. You can easily do this using the code below. DECLARE @sql NVARCHAR(500); DECLARE @tableName NVARCHAR(200); DECLARE...

SQL Server

Viewing Job History in SQL Server

Hello everyone, In this article, I will try to give information about viewing Job history in SQL Server. In SQL Server, in some cases, you may want to learn the working status of Jobs, that is, their history. You can easily do this using the code below. SELECT [job].[job_id] AS...

Don`t copy text!