老鼠夾編程

① 鎬庝箞鑾峰彇exec(@sql)鐨勬墽琛岀粨鏋

exec(@sql)鎵ц屽悗錛岀粨鏋滃氨浼氭樉紺哄湪緇撴灉鏍忛噷銆

涓句緥錛

浠ｇ爜濡備笅

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

鎵ц岀粨鏋滐細