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,080 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,080 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
855 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
997 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
651 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
492 reads
Grant access to Public for all user objects (tables, views, stored procedures).
2002-04-05
228 reads
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
369 reads
How to get current day with the timeportion = 00:00:00.000.Works regardless of locale.
2002-04-05
458 reads
This script derives the first day of the month and the last day of the previous month...
2002-04-04
456 reads
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers