sqlserveråå¨è¿ç¨çåºæ¬æä½ï¼
ä¸ãå建åå¨è¿ç¨
1ãè¯æ³æ ¼å¼ï¼
create proc | procedure pro_name以ä¸æ¯æåºæ¬è¯æ³ï¼ä¸¾ä¸ªç®åçä¾åï¼
CREATE proc p_teståå¨è¿ç¨è¿åä¸ä¸ªç»æéï¼1
2ãæ§è¡åå¨è¿ç¨
EXECUTE Procedure_name '' --åå¨è¿ç¨å¦ææåæ°ï¼åé¢å åæ°æ ¼å¼ä¸ºï¼@åæ°å=valueï¼ä¹å¯ç´æ¥ä¸ºåæ°å¼valueä¾åè°ç¨ç»æï¼
3ãå é¤åå¨è¿ç¨
drop procedure procedure_name --å¨åå¨è¿ç¨ä¸è½è°ç¨å¦å¤ä¸ä¸ªåå¨è¿ç¨ï¼èä¸è½å é¤å¦å¤ä¸ä¸ªåå¨è¿ç¨