today, I had a few hours of frustration, getting all databases in our project use the same collation. What I wanted to achieve is that we would use the default collation of Latin1_General_CI_AS but not script that in our SQL scripts. To start, for some reason the DBPro team decided not to use the names...
SQL server 2008 has a new feature called table-valued parameters. A great feature I tell you, because it allows developers to supply a table of values to a stored procedure for processing. One practical scenario for this is having an insert procedure that allows multiple inserts to be submitted at once...