SQL Server - Server Roles from Quackit.com
Subscribe to:
Posts (Atom)
Check if column exists or not in the SQL server
--method 1 IF EXISTS(SELECT 1 FROM sys.columns with (nolock) WHERE Name = N'LoginName' AND Object_ID = Objec...
-
-- Check the major product version to see if it is SQL Server 2016 CTP 2 or greater IF NOT EXISTS (SELECT * WHERE CONVERT(varchar(128), S...
-
SET NOCOUNT ON GO SELECT SPID, BLOCKED, REPLACE (REPLACE (T.TEXT, CHAR(10), ' '), CHAR (13), ' ' ) AS BATCH INTO #T FRO...
-
alwayson_ddl_executed - This event collects data when a data definition language statement is executed, including CREATE, ALTE...