SQL 2/2

SQL multiple update

UPDATE [dbo].[TBL_IVR_CUSTOMERS] SET [TXT_SPECIAL_TRANSFER_MODUL_NUM] = 'B100.1.1-B310400,B100.2.4.3-B310400,B120.2.1.3-B315028,BD120.2.1...

SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APPLY...

create procedure Camp_Sales as begin update [dbo].[TBL_Campaign_Records] set call_status=1,Call_Result_Last_Status=99 where...

SELECT sc.name +'.'+ ta.name TableName ,SUM(pa.rows) RowCnt FROM sys.tables ta INNER JOIN sys.partitions pa ON pa.OBJECT_ID =...

declare @table sysname, @SQL nvarchar(max) set @table = 'TBL_APP_DID_BILLING_LINK' set @SQL = '' select @SQL = @SQL + '; IF EXISTS...

select job.name, case job.enabled when 1 then 'Enabled' else 'Disabled' end [Enabled], stp.step_name, stp.subsystem, stp.database_name,...

select * from sys.databases

SELECT [DialerVDN], Record_Count=Count(*) FROM [IVR-CONFIG-DB].[dbo].[tblDialer_Record] GROUP BY [DialerVDN]