MSSQL Return Identity after Insert





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

2
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.