老鼠夹编程

① 镐庝箞銮峰彇exec(@sql)镄勬墽琛岀粨鏋

exec(@sql)镓ц屽悗锛岀粨鏋滃氨浼氭樉绀哄湪缁撴灉镙忛噷銆

涓句緥锛

浠ｇ爜濡备笅

declare@tablenamevarchar(20)
declare@sqlvarchar(2000)
set@tablename='test'
set@sql='select*from'+@tablename+''
exec(@sql)

镓ц岀粨鏋滐细