SQL | SQL Studies

Skip to navigation
Skip to main content
Skip to secondary content
Skip to footer

Tag Archives: SQL

Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.
3
July 14, 2025 by Kenneth Fisher

I recently had to copy an Azure SQL database (SQL db) from one subscription to an Azure SQL Server instance …
Continue reading

Category: Cloud, Microsoft SQL Server, Powershell, SQL Database, SQLServerPedia Syndication, T-SQL | Tags: Azure, Azure SQL Database, Cloud, Microsoft, Powershell, SQL, T-SQL
SELECT FORMAT(COUNT(1),’N’) FROM TableName WITH (NOLOCK);
9
December 26, 2023 by Kenneth Fisher

Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, Microsoft SQL Server, query, SQL, SQL Server, T-SQL
GO
6
May 6, 2013 by Kenneth Fisher

Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in …
Continue reading

Category: Keywords, Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: microsoft sql server, SQL, sql statements, T-SQL

Join 3,978 other subscribers