瀛︿範
SQL
搴旂煡閬撶殑鍔ㄦ�?/p>
SQL
璇彞鍩烘湰璇硶
1
銆佹櫘閫?/p>
SQL
璇彞鍙互鐢?/p>
Exec
鎵ц
eg:
Select
*
from
tableName
Exec('select
*
from
tableName')
Exec
sp_executesql
N'select
*
from
tableName'
--
璇锋敞鎰忓瓧绗︿覆鍓嶄竴瀹氳鍔?/p>
N
2
銆佸瓧娈靛悕锛岃〃鍚嶏紝鏁版嵁搴撳悕涔嬬被浣滀负鍙橀噺鏃讹紝蹇呴』鐢ㄥ姩鎬?/p>
SQL
eg:
declare
@fname
varchar(20)
set
@fname
=
'FiledName'
Select
@fname
from
tableName
--
閿欒
,
涓嶄細鎻愮ず閿欒锛屼絾缁撴灉涓哄浐瀹氬�?/p>
FiledName,
骞?/p>
闈炴墍瑕併�?/p>
Exec('select
'
+
@fname
+
'
from
tableName')
--
璇锋敞鎰?/p>
鍔犲彿鍓嶅悗鐨?/p>
鍗曞紩鍙风殑杈逛笂鍔?/p>
绌烘牸
褰撶劧灏嗗瓧绗︿覆鏀规垚鍙橀噺鐨勫舰寮忎篃鍙?/p>
declare
@fname
varchar(20)
set
@fname
=
'FiledName'
--
璁剧疆瀛楁鍚?/p>
declare
@s
varchar(1000)
set
@s
=
'select
'
+
@fname
+
'
from
tableName'
Exec(@s)
--
鎴愬姛
exec
sp_executesql
@s
--
姝ゅ彞浼氭姤閿?/p>
declare
@s
Nvarchar(1000)
--
娉ㄦ剰姝ゅ鏀逛负
nvarchar(1000)
set
@s
=
'select
'
+
@fname
+
'
from
tableName'
Exec(@s)
--
鎴愬姛
exec
sp_executesql
@s
--
姝ゅ彞姝ｇ‘
3
銆佽緭鍑哄弬鏁?/p>
declare
@num
int,
@sqls
nvarchar(4000)
set
@sqls='select
count(*)
from
tableName'
exec(@sqls)
--
濡備綍灏?/p>
exec
鎵ц缁撴灉鏀惧叆鍙橀噺涓紵
declare
@num
int,
@sqls
nvarchar(4000)
set
@sqls='select
@a=count(*)
from
tableName
'