Table Value Constructor is a new feature within SQL Server 2008, and also can be part of existing features like INSERT or MERGE, which allows for new syntax only available within T-SQL (maybe that's another reason I decided to write about TVC after having studied Oracle SQL, which doesn't have this feature). So Table Value Constructor is nothing else than a T-SQL syntax that allows multiple rows of data to be specified in a single DML statement. TVC can be used only within the following DML statements:
- INSERT statement
- USING clause of MERGE statement
- inline view or derived table in FROM clause
[Table Value Constructor within INSERT statement]
[Table Value Constructor as DERIVED TABLE]
As far as table value constructor within MERGE statement, I'll demonstrate that in the next post , which will be dedicated entirely to MERGE statement as it is also a brand new feature in SQL Server 2008 and it is a little different than the one in Oracle. So it is really important to revisit it before the test.
1 comments:
Nice post. I study one thing more challenging on
totally different blogs everyday. It'll at all times be stimulating to learn content material from other
writers and practice a little
something from their store. I’d want to use some with the
content material on my blog whether or not you don’t mind. Natually I’ll offer you a link in your internet blog. Thanks for sharing.
Stop by my homepage airport transfers alicante to calpe
my page - 4 non blondes spaceman guitar tabs