Dynamic table name in SQL cursor

Question

@Table_R nvarchar(50)

FETCH NEXT FROM M_cursor INTO @M_col    

PRINT 'Mandatory Feilds ' + @M_col 

Select count(*) from @Table_R where @M_col is null'    


FETCH NEXT FROM M_cursor INTO @M_col

I will send the table name as parameter ' @Table_R' , But in the cursor it throws an error.

How to use dynamic table in the Sql Cursor.

thanks

possible duplicate of Sql - tablename as variable

GSerg
– GSerg

2013-04-09 13:35:57 +00:00
Commented Apr 9, 2013 at 13:35 — GSerg
– GSerg, Commented Apr 9, 2013 at 13:35

Alex · Accepted Answer · 2013-04-09 13:41:03Z

2

You should use dynamic sql command sp_executesql (http://msdn.microsoft.com/en-us/library/ms188001.aspx). See example:

DECLARE @A numeric
EXEC SP_EXECUTESQL N'Select @a=count(*) from '+ @Table_R+ ' where ' + @M_col + ' is null',
      N'@A numeric OUTPUT', 
      @A OUTPUT;

edited Apr 9, 2013 at 13:41

answered Apr 9, 2013 at 13:31

Alex

8,9473 gold badges44 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Azmi Kamis · Accepted Answer · 2013-04-09 13:37:10Z

0

Replace

Select count(*) from @Table_R where @M_col is null

with

EXEC('Select count(*) from '+@Table_R+' where '+@M_col+' is null')

answered Apr 9, 2013 at 13:37

Azmi Kamis

9015 silver badges20 bronze badges

Collectives™ on Stack Overflow

Dynamic table name in SQL cursor

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related