Sql updating table from temp table

I assume that this stuff is mostly standard, but I that is just a guess.

I know my SQL had a lot of "annoying" features in earlier versions that have been cleaned up in the latest release (or so I have been told) so hopefully this should work in the newest version.

You can’t, for example, change the table definition after the initial DECLARE statement.Table variables require less locking resources as they are ‘private’ to the process that created them.Transaction rollbacks do not affect them because variables have limited scope and are not part of the persistent database, so they are handy for creating or storing data that ought to survive roll backs such as log entries.They’re easy, and SQL Server does the work for you.They also tend to cause fewer problems to a hard-working OLTP system.

Leave a Reply