Bloco nomeado DO $$ <<first_block>> DECLARE film_count integer := 0; BEGIN — get the number of films SELECT COUNT(*) INTO film_count FROM “Lancamento”; — display a message RAISE NOTICE ‘The number of films is %’,…
Read More
Código Formato 0 Oct 9 2020 2:20PM 1 10/09/20 2 20.10.09 3 09/10/20 4 09.10.20 5 09-10-20 6 09 Oct 20 7 Oct 09, 20 8 14:20:02 9 Oct 9 2020 2:20:02:400PM 10 10-09-20 11…
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 +…
USE [master]; DECLARE @kill varchar(MAX) = ”; SELECT @kill = @kill + ‘kill ‘ + CONVERT(varchar(5), session_id) + ‘;’ FROM sys.dm_exec_sessions WHERE database_id = db_id(‘BANCO_DE_DADOS’) EXEC(@kill);
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…
npx create-react-app alga-stock –template typescript