rahultripathi

 Profile Answers by rahultripathi 

• Sep 22nd, 2005

 

In dynamic SQL method 4 in  queries(select ) there are variable number of column and bind variable . Other word we can say that until run time we don't how many bind varible there.

  Exemple :-

   select :select_list Column from tablename where :wherecluase

If any query don't hesitate write on rahultripath@myway.com

Genie_Cool

• Jun 1st, 2007

 

If we are speaking about SQL Server and Dynamic SQL, then the following is the answer.
Some queries in SQL Server might be given during run-time as we may not know the table that we might use in the procedure or batch. And so we do a dynamic SQL Statement.

CREATE PROC Some_sp
(
@tblname varchar(80)            ----Input is table name
)

as
begin
DECLARE @Qry Varchar(32)

SET @Qry = 'Select * from ' + @tblname
EXEC (@Qry)
End

Compile and run the above stored procedure and then run the following execute statement.

EXEC Some_sp 'Employees'

This is a very simple dynamic SQL. You can make it more complex and they have few restrictions that you need to keep intact.