Tag-arkiv: sql server
How to retrieve the active queries from An SQL Server
If you are wondering what the SQL server is doing, try to fire this statement, it shows the following. – SPID – The system process ID. – Status – The status of the process (e.g., RUNNABLE, RUNNING, SLEEPING). – Login … Læs resten
Udgivet i SQL Server - scripts
Tagget Active queries, Execution plan, Fetch API cursor, SP_execute, sql server
Kommentarer lukket til How to retrieve the active queries from An SQL Server
How to extract files from SQL Server blob fields into files.
— Write all database files (pdf) to file. ——— ——— ——— ——— ——— ——— ——— DECLARE CURSOR_Id CURSOR FOR (SELECT [RecId] FROM [dbo].[SYSOUTGOINGEMAILDATA]) DECLARE @RecId BIGINT; OPEN CURSOR_Id FETCH NEXT FROM CURSOR_Id INTO @RecId WHILE (@@FETCH_STATUS -1) BEGIN DECLARE @Data … Læs resten
Udgivet i SQL Server - scripts
Tagget blob fields, extract files, files., sql server
Kommentarer lukket til How to extract files from SQL Server blob fields into files.
How to create a temporary table in SQL Server
When you are creating SQL scripts you will sometimes need to create a temporary file. This can be done in 2 different ways in SQL Server. — The scope of this temporary table is only the SPID that created the … Læs resten
Udgivet i SQL Server - scripts
Tagget create temporary table, sql server
Kommentarer lukket til How to create a temporary table in SQL Server