SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Passing table variables to dynamic sql
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Rangi
Starting Member

United Kingdom
18 Posts

Posted - 12/06/2002 :  12:05:33  Show Profile  Visit Rangi's Homepage  Reply with Quote
I am right in thinking it's not possible to pass a table variable as a parameter in a sp_executesql statement in the way an int can be passed as a parameter?

Rangi

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 12/06/2002 :  12:17:32  Show Profile  Visit robvolk's Homepage  Reply with Quote
No, you can't pass a table variable. But you can create a temp table in one procedure, populate it with data, and call a second procedure that can reference that temp table and do more work on it.

Go to Top of Page

Rangi
Starting Member

United Kingdom
18 Posts

Posted - 12/06/2002 :  13:00:35  Show Profile  Visit Rangi's Homepage  Reply with Quote
Ok thanks, I'll do that.

Rangi

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000