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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 I want a sample code showing how to populate a table data type thru SP_EXECUTESQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-14 : 13:06:22
Joydeep writes "SQL-Server 2000
Windows 2000

I am building a dynamic select list like say

@dynamic = @static + @clause

Now I want this select to populate a table type variable with the return of the select clause

like
@tabVar EXEC sp_executesql @dynamic

Can anyone provide me a sample code. I am basically an database guy but new to SQL Server"
   

- Advertisement -