发表于 2009-1-5 19:48
| 
SQL Server鑱旀満涓涗功锛氭墽琛屽瓨鍌ㄨ繃绋
鍙戝竷: 2008-6-30 23:24 | 浣滆: admin | 鏌ョ湅: 3娆
SQL Server鑱旀満涓涗功锛氭墽琛屽瓨鍌ㄨ繃绋
鐑 鑽
銆愬瓧浣擄細灏 澶с
SQL Server鑱旀満涓涗功锛氭墽琛屽瓨鍌ㄨ繃绋
浣滆咃細- 鏂囩珷鏉ユ簮锛- 鐐瑰嚮鏁帮細1064 鏇存柊鏃堕棿锛2006-4-20 
EXECUTE
鎵ц鏍囬噺鍊肩殑鐢ㄦ埛瀹氫箟鍑芥暟銆佺郴缁熻繃绋嬨佺敤鎴峰畾涔夊瓨鍌ㄨ繃绋嬫垨鎵╁睍瀛樺偍杩囩▼銆傚悓鏃舵敮鎸 Transact-SQL 鎵瑰鐞嗗唴鐨勫瓧绗︿覆鐨勬墽琛
鑻ヨ鍞ら啋璋冪敤鍑芥暟锛岃浣跨敤 EXECUTE stored_procedure 涓弿杩扮殑璇硶銆
璇硶
鎵ц瀛樺偍杩囩▼锛
[ [ EXEC [ UTE ] ]
{
[ @return_status = ]
{ procedure_name [ ;number ] | @procedure_name_var
}
[ [ @parameter = ] { value | @variable [ OUTPUT ] | [ DEFAULT ] ]
[ ,...n ]
[ WITH RECOMPILE ]
鎵ц瀛楃涓诧細
EXEC [ UTE ] ( { @string_variable | [ N ] 'tsql_string' } [ + ...n ] )
鍙傛暟
@return_status
鏄竴涓彲閫夌殑鏁村瀷鍙橀噺锛屼繚瀛樺瓨鍌ㄨ繃绋嬬殑杩斿洖鐘舵併傝繖涓彉閲忓湪鐢ㄤ簬 EXECUTE 璇彞鍓嶏紝蹇呴』鍦ㄦ壒澶勭悊銆佸瓨鍌ㄨ繃绋嬫垨鍑芥暟涓０鏄庤繃銆
鍦ㄧ敤浜庡敜閱掕皟鐢ㄦ爣閲忓肩敤鎴峰畾涔夊嚱鏁版椂锛孈return_status 鍙橀噺鍙互鏄换浣曟爣閲忔暟鎹被鍨嬨
procedure_name
鏄嫙璋冪敤鐨勫瓨鍌ㄨ繃绋嬬殑瀹屽叏鍚堟硶鎴栬呬笉瀹屽叏鍚堟硶鐨勫悕绉般傝繃绋嬪悕绉板繀椤荤鍚堟爣璇嗙瑙勫垯銆傛湁鍏虫洿澶氫俊鎭紝璇峰弬瑙佷娇鐢ㄦ爣璇嗙銆傛棤璁烘湇鍔″櫒鐨勪唬鐮侀〉鎴栨帓搴忔柟寮忓浣曪紝鎵╁睍瀛樺偍杩囩▼鐨勫悕绉版绘槸鍖哄垎澶у皬鍐欍
鐢ㄦ埛鍙互鎵ц鍦ㄥ彟涓鏁版嵁搴撲腑鍒涘缓鐨勮繃绋嬶紝鍙璇ョ敤鎴锋嫢鏈夋杩囩▼鎴栨湁鍦ㄨ鏁版嵁搴撲腑鎵ц瀹冪殑閫傚綋鐨勬潈闄愩傜敤鎴峰彲浠ュ湪鍙︿竴鍙拌繍琛 Microsoft
