| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 A SQL datatypes comparison incl. syntax for SQL Server, Oracle, MySQL, PostgreSQL, and Access! | SQL Server 2000, SQL Server 7.0, Informix
, Oracle, Other | Intermediate /
Norbert Geek | 23671 since
8/13/2003 11:21:27 AM |
By 5 Users
2 Excellent Ratings
|
| |
Compares and lists all commonly used data types of various databases such as SQL Server, Oracle, MySQL, PostgreSQL, and Access. (download the zip file which includes a *.gif image) VERY USEFUL for DBA's and Programmers!
 (ScreenShot) |
| |
| |
| |
|
 Affecting all the tables in one shot | SQL Server 2000 | Intermediate /
Kapil Srivastava | 13430 since
12/14/2003 10:12:39 PM |
By 3 Users
2 Excellent Ratings
|
| |
Executes any command on for every user table in the database |
| |
| |
| |
|
 Base 64 in Transact SQL Function | SQL Server 2000 | Advanced /
Philip Leitch | 13360 since
4/26/2005 2:38:42 AM | Unrated
|
| |
Converts standard text into Base64 and from Base64 into standard text. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Basic: Views | Oracle | Beginner /
Mike J Anderson | 13868 since
1/9/2002 8:18:04 PM |
By 2 Users
|
| |
A view is a copy of a table that is viewable only to other users (Example: One can not add or delete records from it). They are easy to create and come in handy, example below. |
| |
| |
| |
 |
Bits To Integer | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Sajid Ali Anjum | 7022 since
6/20/2006 10:57:36 AM | Unrated
|
| |
Converts the bit stream into integer value.(ScreenShot) |
| |
| |
| |
|
Capitalize First Character in SQL SERVER | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
Sachin Pendgaonkar | 12087 since
10/29/2002 3:20:08 AM |
By 2 Users
2 Excellent Ratings
|
| |
Here is a procedure for SQL Server which can be created in a module and called from a query using InitCap([fieldname])....thanks to Paul |
| |
| |
| |
|
Change collate Database And columns of tables of the Database | Other | Advanced /
Jose Vicente Rocamora Ballestero | 5145 since
3/30/2009 9:14:14 AM | Unrated
|
| |
----------------------------------------------
-- this cursor is for change the collate of the
-- columns of the database.
-- do you like it ??
-- 27.03.2009 jvrocamora@gmail.com
-- FOR SQL 2005
-- only for your eyes !!!!!!
------------------------------ ...(description truncated) |
| |
| |
| |
|
Changing object owner to dbo | SQL Server 2000, SQL Server 7.0 | Beginner /
Mike J Anderson | 20557 since
11/9/2003 2:24:43 PM |
By 1 Users
|
| |
Use this one liner to change object owner to dbo (rights). |
| |
| |
| |
|
Column From Delimited String | SQL Server 2000, SQL Server 7.0 | Intermediate /
Sean P. O. MacCath-Moran | 12876 since
1/7/2003 9:20:02 AM |
By 1 Users
|
| |
This function returns a column as a string from the provided delimited string, taking in to account the specified field delimiter and text qualifiers. In my own use if this, I perform a BULK INSERT operation into a table and then build a new table based o ...(description truncated) |
| |
| |
| |
|
Comma Seperated String To Table Type Variant | SQL Server 2000 | Intermediate /
John Bridle | 10625 since
7/24/2003 6:17:21 AM | Unrated
|
| |
This code takes a comma seperated string of values and turns them through the use of this function into a fully queryable no temporary objects required table. Can be used like:
Select * From fn_StringToTable('Value1,Value2,Value3') |
| |
(ScreenShot)
(ScreenShot)
