This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It’s very useful when you have to ship or package a database application. This procedure… Read moreProcedure to script your data (to generate INSERT statements from the existing data)

I came across a great article by Narayana Vyas Kondreddi that describes the difference between the SET and SELECT .The article is well worth the read, but here are the main points: SET is the ANSI standard for variable assignment,… Read moreDifference between using SET and SELECT when assigning variables in T-SQL