Table Valued Function to return a range of prime numbers
A fast table valued function to generate a list of prime numbers within the range specified by the parameters.
2017-04-12 (first published: 2017-03-30)
415 reads
A fast table valued function to generate a list of prime numbers within the range specified by the parameters.
2017-04-12 (first published: 2017-03-30)
415 reads
Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.
2016-03-10 (first published: 2015-07-23)
5,462 reads
This function counts the number of 1's in the binary representation of an integer.
2015-07-28 (first published: 2014-02-24)
971 reads
This function converts an integer to its binary representation. e.g. 15 is converted to '00001111'
2015-04-29 (first published: 2014-02-24)
768 reads
This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.
2012-02-17 (first published: 2010-05-20)
32,676 reads
How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.
2010-06-21
11,258 reads
This shows a method for generating scripts for SQL Server stored procedures and functions so they can be added to a version control management system (VCMS).
2010-05-06
20,790 reads
By gbargsley
Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful,...
DBAs should never run SSMS under their everyday Windows account If you open SSMS under...
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
Import-Module ImportExcel # Path to your .sql file $sqlFile = "C:\Data\MyQueries.sql" $excelPath = "C:\Data\SqlExtract_$(Get-Date...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer @customername varchar(200) AS BEGIN DECLARE @added VARCHAR(100) SELECT @added = xxx IF @customername IS NOT NULL INSERT dbo.Customer ( CustomerName, AddedBy ) VALUES (@customername, @added) ENDSee possible answers