Programs: 36 | Umachandar Jayachandran homepage
 |
This MS-SQL stored procedure shows how to create case sensitive ordered results
|
08 October 2010, 03:59 GMT
Downloads: 165 |
|
This is an SQL procedure to transpose columns as rows
|
06 October 2010, 13:59 GMT
Downloads: 220 |
|
This is an MS-SQL stored procedure to rank items within groups of data
|
11 September 2010, 09:55 GMT
Downloads: 139 |
|
This MS-SQL procedure shows how to perform a case-sensitive search on strings hosted on a case-insensitive server
|
10 September 2010, 04:10 GMT
Downloads: 175 |
|
This is an MS-SQL procedure to search and replace certain characters in a string
|
26 August 2010, 23:52 GMT
Downloads: 145 |
|
This MS-SQL procedure will generate a sequence numbers within a group of values
|
25 August 2010, 03:38 GMT
Downloads: 139 |
|
This simple MS-SQL snippet can find the minimum value in 3 columns
|
04 August 2010, 14:35 GMT
Downloads: 190 |
|
This is a MS-SQL script to format decimal numbers with a comma instead of a point
|
30 July 2010, 18:43 GMT
Downloads: 185 |
|
This SQL script can determine the product of values in a table column
|
28 July 2010, 21:36 GMT
Downloads: 178 |
|
This stored procedure for MS-SQL can be used to list the I/O buffer of a specific SPID
|
24 July 2010, 13:43 GMT
Downloads: 172 |
|
This MS-SQL stored procedure can be used to search for a string in the last input command sent to a SQL Server from a user connection
|
24 July 2010, 12:29 GMT
Downloads: 162 |
|
This MS-SQL script forcefully disconnects users from a DB
|
22 July 2010, 23:37 GMT
Downloads: 204 |
|
This is an MS-SQL script to determine the size taken by the auto-statistics function in a database
|
21 July 2010, 01:03 GMT
Downloads: 185 |
|
This is an SQL script to generate IDs for each row
|
12 July 2010, 07:18 GMT
Downloads: 231 |
|
This is an MS-SQL stored procedure to retrieve file details
|
27 June 2010, 12:31 GMT
Downloads: 241 |
|
This is an Ms-SQL script to find the number of days in a month
|
22 June 2010, 01:46 GMT
Downloads: 236 |
|
This is an MS-SQL function to encrypt data inside a table using XOR
|
13 June 2010, 03:04 GMT
Downloads: 265 |
|
This is an MS-SQL function to count the number of lines in an external system file
|
08 June 2010, 01:07 GMT
Downloads: 239 |
|
This is a script to show how to the autostart an SQL Server setting using SQL-DMO
|
05 June 2010, 21:47 GMT
Downloads: 308 |
|
This is an Ms-SQL procedure to strip money values from a specifically formatted string
|
01 June 2010, 11:34 GMT
Downloads: 239 |
|
This SQL Server script retrieves the login configuration and other trusted logins
|
28 May 2010, 13:03 GMT
Downloads: 233 |
|
This is an MS-SQL script to generate a report on the number of rows, size of a table in a database
|
08 May 2010, 13:58 GMT
Downloads: 266 |
|
This MS-SQL script enumerate directories and files using NT DIR commands
|
06 May 2010, 19:57 GMT
Downloads: 237 |
|
This MS-SQL stored procedure can be used to drop a login from all databases
|
30 April 2010, 22:23 GMT
Downloads: 283 |
|
This is a MS-SQL script to drop all database tables and all associated files
|
27 April 2010, 18:18 GMT
Downloads: 274 |
|
This MS-SQL stored procedure can be used to drop a database and device files by a SQL Executive job process
|
27 April 2010, 17:14 GMT
Downloads: 213 |
|
This SQL function counts occurrences of a string in all stored procedures in a database
|
24 April 2010, 08:21 GMT
Downloads: 243 |
|
This is a script to compare two different databases and obtain a list of differences
|
24 April 2010, 07:39 GMT
Downloads: 295 |
|
This is a SQL script to automate the transfer of standard logins from one server to another along with the passwords
|
19 April 2010, 00:04 GMT
Downloads: 270 |
|
This SQL procedure generates INSERT, UPDATE and DELETE statements for table templates
|
18 April 2010, 23:08 GMT
Downloads: 250 |
|
This SQL stored procedure defines a column with a custom time format
|
13 April 2010, 20:47 GMT
Downloads: 256 |
|
This SQL script will convert TIMESTAMP values to numeric values
|
28 March 2010, 01:51 GMT
Downloads: 282 |
|
This SQL script strips a text field into several varchar fields
|
19 March 2010, 11:41 GMT
Downloads: 226 |
|
This SQL function can add zero padding to a string
|
13 March 2010, 05:59 GMT
Downloads: 386 |
|
This is an SQL script to convert stored string data from hex base to integer
|
09 March 2010, 11:58 GMT
Downloads: 305 |
|
This SQL procedure can copy text values from one table to another
|
01 March 2010, 10:33 GMT
Downloads: 214 |
|
Find us on Google+
