daynamic sql

[yazan_zahi]

what do we mene by daynamic sql in sql server 2000 and how can iuse them

[Amit Kumar G]

Dynamic SQL are those SQL which gets the value at runtime. I am sharing one simple example and i hope this will help you. Declare @table Varchar(25), @Sql Varchar(25) BEGIN SELECT @table='TB_Emp' Select @Sql= 'SELECT Count(*) FROM' + @table exec (@sql) END For more details refer google or SQL Online Help. Amit