In Query use variable like Dynamic SQL

Question

Hi All I have 1 query in sql server. DECLARE @sqlWhere VARCHAR(MAX) SET @sqlWhere = 'flg_active = 1 order by CreatedDate' Select * from TableName1 where @sqlWhere Is it possible with out dynamic SQL. Thanks Jitendra Patel

Pravin More · Answer

HI Jittendra i dont think writing query in string and then exec will make delay compare to normal query.performance will be same.

Jitendra Patel · Answer

hi if there are not any other option then I will continue with exec (dynamic sql) Thanks for co-operate.

Jignesh Trivedi · Answer

hi that is correct you will retrive 6500000 rows. but i think when you use exec it will not effect ur performance.

Jitendra Patel · Answer

HI I am using sql server 2008. I have 6500000 records and when I am useing dynamic sql then it's performance is very slow.

Jignesh Trivedi · Answer

hi is there any restriction not use dynamic sql. are u using which technology> i.e. pure SQL or ADO.net?

Jitendra Patel · Answer

yes it's a correct answer but I don't use dynamic Sql

Pravin More · Answer

hi Jitendra you need to give it like............. DECLARE @sqlWhere VARCHAR(MAX) DECLARE @qry VARCHAR(MAX) SET @sqlWhere = 'flg_active = 1 order by CreatedDate' set @qry='Select * from TableName1 where'+ @sqlWhere exec(@qry) Thanks Pravin.