ranking Sort Sort   |   date Sort Sort   |   member Sort Sort
Syndication

3
Date Submitted Wed. Feb. 28th, 2007 1:11 PM
Revision 1
Helper Idlemind
Tags MSSQL | mysql
Comments 0 comments
When you need to perform an action on a single row of data, many people turn to cursors. Cursors come with a lot of overhead in the database engine and can be confusing. Here's a way to get the same results without the overhead in a much simplier way.
5
Date Submitted Mon. Oct. 9th, 2006 2:23 AM
Revision 1
Beginner hunter
Tags MSSQL
Comments 0 comments
Shrink databases' log files to minimal size. Runs on every database on server, using undocumented procedure.
2
Date Submitted Thu. Oct. 5th, 2006 8:48 PM
Revision 1
Helper Thomas
Tags MSSQL
Comments 0 comments
Often when inserting information in a database we need to know the value of the autonumber/identity field so that we can insert related data in another table. MSSQL Server provides a SCOPE_IDENTITY() function for just such a purpose (PHP/MySQL users have the mysql_insert_id() function -- lucky).

*This is in the generic section because there is no MSSQL Server or Database section.