Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
mobasha
Starting Member
45 Posts |
Posted - 2007-08-14 : 07:20:54
|
hi all.can i pass a tabel variable for a procedure as an input ?. am trying to do this but its not working , can u please help me outMobashA |
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-14 : 08:31:34
|
data_typeIs the parameter data type. All data types, except the table data type, can be used as a parameter for a stored procedure. However, the cursor data type can be used only on OUTPUT parameters. When you specify a data type of cursor, the VARYING and OUTPUT keywords must also be specified. For more information about SQL Server - supplied data types and their syntax, see Data Types. Ashley Rhodes |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-14 : 12:09:06
|
quote: Originally posted by mobasha hi all.can i pass a tabel variable for a procedure as an input ?. am trying to do this but its not working , can u please help me outMobashA
If you are using Katmai, then perhaps. Where are you passing the table variable from? Another proc? If its all in the same transaction, you can insert the data into a temp table and query the temp table from the other proc.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|