SELECT @cpu_time_start = cpu_time, @elapsed_time_start = total_elapsed_time FROM sys.dm_exec_sessions WHERE session_id = @@SPID IF OBJECT_ID ('tempdb.dbo.#tmp_requests') IS NOT NULL DROP TABLE ...
pre-commit is a nice development tool to automatize the binding of pre-commit hooks. After installation and configuration pre-commit will run your hooks before you commit any change. CREATE OR REPLACE ...
I have a column of data with values resembling this: HL7_Result_for_Message_ID_123Q324343.hl7 I need to grab that ID number (in bold), the challenge being that it can be any and all lengths. I have ...
Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Birgitta Böckeler, Distinguished Engineer at ...
What organizes people into sustained political factions like left vs. right? Supposedly our opposing answers to some fundamental question, but what is that question? Gender is a natural distinction, ...
In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...
If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results