|
|
Stories recently tagged with 'sqlserver2008'
|
|
submitted by
misbaharefin
2 months, 14 days ago dotnethitman.spaces.live.com — One of the cool new data types added in SQL Server 2008 is Table-Value Parameters. You can use table value parameters to send multiple rows of data to a Transact-SQL statement, or to a routine such as a stored procedure or function. This can be done without creating a temporary table or many parameters. Table-value parameters are like parameter arrays in Object Linking and Embedding Database (OLE DB) and Open Database Connectivity (ODBC), but offer better flexibility and closer integration with Transact-SQL. Table-value parameters can participate in set-based operations.
read more...
add a comment
|
category:  Other | Views: 8
| 
|
tags:
TableValueParameters, sqlserver2008 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 4 months, 21 days ago, submitted by
 powerrush
4 months, 22 days ago simple-talk.com — Among the large number of new features in SQL Server 2008 there are two, almost insignificant features, that I use almost constantly. These are variable initialization and the values clause of insert statements that now accept multiple rows.
read more...
add a comment
|
category:  Database | Views: 4
| 
|
tags:
SQL, 2008, sqlserver2008, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|