Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [table-variable]

The tag has no usage guidance.

0
votes
2answers
688 views

improving performance - how to pass a table as parameter in sql server 2005?

I have been monitoring the execution of my stored procedures in my webservers in order to tune them for best performance. I will call the procedure that has most executions per day as myprocedure and ...
19
votes
2answers
7k views

Why must TVPs be READONLY, and why can't parameters of other types be READONLY

According to this blog parameters to a function or a stored procedure are essentially pass-by-value if they aren't OUTPUT parameters, and essentially treated as a safer version of pass-by-reference if ...