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 |
|
BlackViking13
Starting Member
1 Post |
 Posted - 2013-06-01 : 01:10:57
|
| how can i define table type argument as OUTPUT in PROC and don't READONLY?if it's not possible, is there another way to do same this?thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-01 : 05:25:07
|
| Its not possible. table type has to be read onlyWhy not make it a table valued udf then?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-01 : 09:28:48
|
| There are a few different ways to share data between stored procedures (or between stored procedures and a client application). Sommarskog's blog here is a good reference. |
|
|
|
|
|
|
table type argument as OUTPUT in PROC