outubro 2020


No Image

Formatos de Data no SQL Server

DECLARE @Formatos TABLE( Codigo INT, Formato VARCHAR(255) ) DECLARE @Count INT = 0 WHILE @Count < 200 BEGIN BEGIN TRY INSERT INTO @Formatos VALUES(@Count,convert(varchar(50),getdate(),@Count)) END TRY BEGIN CATCH END CATCH SET @Count = @Count +…



No Image

Armazenar retorno do sp_who2 em tabela temporária

CREATE TABLE #sp_who2 ( SPID INT,Status VARCHAR(255), Login VARCHAR(255),HostName VARCHAR(255), BlkBy VARCHAR(255),DBName VARCHAR(255), Command VARCHAR(255),CPUTime INT, DiskIO INT,LastBatch VARCHAR(255), ProgramName VARCHAR(255),SPID2 INT, REQUESTID INT ) INSERT INTO #sp_who2 EXEC sp_who2 SELECT * FROM #sp_who2 WHERE…