Gets most important information of database structure. This includes all user tables, their fields, datatypes, defaults (including default constraint names), etc, primary keys and their fields, unique constraints and their fields, check constraints (including their conditions), foreign key constraints and their fields aswell as any other indexes and their fields. Should be quite useful for […]
2002-04-08
3,048 reads
A Modified Version of dateDiff. DateDiff Fucntion checks the "datepart" only of the dates. This modified function returns how many "date part" is exactly passed.
2002-04-08
1,058 reads
This procedure will get all tables with column information where column exist.There is an option to search for exact or "like" name. By default it's exact name
2002-04-08
839 reads
This procedure will get week information ( number,day start-day finish) for requested date. By default output dates are in 'mm/dd/yyyy' format.Format of the output dates could be changed (see 'style' info in the SQL HelpFile for 'Convert' function)
2002-04-08
976 reads
Script that will show a method of replacing a cursor with a temporary table. This script will loop through all the databases on a server and run sp_spaceused on all user tables.
2002-04-08
634 reads
To find the day of week, regardless of-SET DATEFIRST -SET DATEFORMAT -SET LANGUAGEThe first one is based on Zellers Congruence.The second one is a SQL server proprietary.
2002-04-05
474 reads
Grant access to Public for all user objects (tables, views, stored procedures).
2002-04-05
219 reads
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
353 reads
How to get current day with the timeportion = 00:00:00.000.Works regardless of locale.
2002-04-05
440 reads
This script derives the first day of the month and the last day of the previous month...
2002-04-04
443 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Experts, I am hoping to get some help and feedback. I have a server...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers