How to Prevent Selects from being returned ...
Database
2
Posts
2
Posters
0
Views
1
Watching
-
How Can we prevent SELECT statements from being returned in the dataset , because we may need to execute some SELECT just for other purposes than reporting.
Best regards Hossein Yahoo ID :hosseinnick
-
How Can we prevent SELECT statements from being returned in the dataset , because we may need to execute some SELECT just for other purposes than reporting.
Best regards Hossein Yahoo ID :hosseinnick
Just collect the columns being included in the select list in come variables. See below: - DECLARE @v1 int,@v2 int SELECT @v1=number1,@v2=number2 FROM tblA