With this script you can supply an money value such as $12525.83 and it will return the word value "Twelve Thousand Five Hundred And Twenty-Five Dollars And Eighty-Three Cents".It is comprised of a table for Number to Name and a procedure to parse into it's piecesNOTE: This only goes to billions at this point, but […]
2002-04-11
441 reads
This script demonstrates a simple way to query a files create, modified or last accessed date without using a scripting and is availble in TSQL using xp_cmdshell.
2002-04-11
424 reads
2002-04-11
365 reads
This script will output the Orignal DB Name, Destination DB Name and Last Restore date for the databases. You get a specific database just add a where clause against the appropriate field. It makes use of the restorehistory and backupset tables in the MSDB database.
2002-04-11
2,586 reads
This store procedure outputs the tables' usage figures in a usable (I hope) format. If you create in the master database it will show the information for the database that it runs against.
2002-04-11
396 reads
This procedure takes the results of sp_helprotect and converts it into a crosstab -- all permissions for a user/table combination are listed in a single row
2002-04-11
460 reads
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,074 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,075 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
854 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
994 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers