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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-28 : 18:35:31
|
| RaS! writes "OS: Windows 2000 Service Pack 2SQL Server 7 with SP3-------------------------------I don't know if I can do this. I want to compose my query using asp and assign it as a value of a parameter for a stored procedure. In my stored procedure I declare that parameter, but I don't know how run my main query. Example:CREATE query(@myParam as VarChar(255))AS??? (how run it?!)PS: @MyParam contains "SELECT * FROM table"I can do this?" |
|
|
|
|
|
Put a part of a select in a parameter for a Stored Procedure and use it