how to pass the dynamic value in sql server2005

[sanbala]

hi everybody
how to pass the dynamic input value to the sql select query.

[ck9663]

hi everybody
how to pass the dynamic input value to the sql select query.

are you asking for:

select * from mytable where myfield = @myvar ???

or

@sqlstring = 'select * from mytable where myfield = ' + @myvar

exec (@sqlstring)

[sanbala]

are you asking for:

select * from mytable where myfield = @myvar ???

or

@sqlstring = 'select * from mytable where myfield = ' + @myvar

exec (@sqlstring)

hi.
am asking how to pass table name as dynamic input value


by
sankar

[ck9663]

hi.
am asking how to pass table name as dynamic input value


by
sankar

like this?

@sqlstring = 'select * from ' + @MyVariableThat HoldsTableName

exec (@sqlstring)