2008-08-27 (first published: 2008-07-03)
2,190 reads
Scripts
sp_import_errorlog
To import the SQL Server error log into a table, so that it can be queried
Written by: Anand Mahendra Tested on: SQL Server 2000
2008-08-21 (first published: 2008-06-30)
785 reads
2008-08-20 (first published: 2008-06-19)
1,133 reads
2008-08-18 (first published: 2008-06-25)
1,745 reads
Case Cleanup Function
Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify).
2008-08-14
337 reads
ChangeDateTpFirstOfNextMonth
Nothing fancy; just allows you to change a date the the first of the following month. Friend needed this so I thought I would post it here for other newbies.
2008-08-14 (first published: 2008-06-20)
554 reads
2008-08-13 (first published: 2008-06-17)
1,094 reads
How to get list of Stored Procedure
You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.
2008-08-11
1,076 reads
2008-08-11 (first published: 2008-06-17)
889 reads
Find the port no Get Port SQL Server 2000
This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL
2008-08-09
1,064 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BCA KCU TEBING TINGGI TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Jend. Sudirman No. 225-227-229-231, Badak Bejuang, Kec. Tebing Tinggi Kota,...
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08217555651
TLP/CS 08217555651 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera Utara...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers