Building / Executing a Select statement

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 1

This is part of a script that has the set statement and then the execute statement.

set @sqlstring = ('dbcc checkident '+@tab_name+')')

exec (@sqlstring)

Let me know if you need more detail than that or, post some code we can look at.

David

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

funkcommander SSCommitted Points: 1599 More actions · Answer 2

I think that will do it. I should have guessed it would be something simple. Thanks for your help.