发表于 2009-1-5 19:48
| 
SQL Server鑱旀満涓涗功锛氭煡鐪嬪瓨鍌ㄨ繃绋
鍙戝竷: 2008-6-30 23:24 | 浣滆: admin | 鏌ョ湅: 1娆
SQL Server鑱旀満涓涗功锛氭煡鐪嬪瓨鍌ㄨ繃绋
鐑 鑽
銆愬瓧浣擄細灏 澶с
SQL Server鑱旀満涓涗功锛氭煡鐪嬪瓨鍌ㄨ繃绋
浣滆咃細- 鏂囩珷鏉ユ簮锛- 鐐瑰嚮鏁帮細1090 鏇存柊鏃堕棿锛2006-4-20 
鍑犱釜绯荤粺瀛樺偍杩囩▼鐢ㄧ郴缁熻〃鎻愪緵鏈夊叧瀛樺偍杩囩▼鐨勪俊鎭備娇鐢ㄨ繖浜涘瓨鍌ㄨ繃绋嬪彲浠ワ細
鏌ョ湅鐢ㄤ簬鍒涘缓瀛樺偍杩囩▼鐨 Transact-SQL 璇彞銆傝繖瀵逛簬娌℃湁鐢ㄤ簬鍒涘缓瀛樺偍杩囩▼鐨 Transact-SQL 鑴氭湰鏂囦欢鐨勭敤鎴锋槸寰堟湁鐢ㄧ殑銆
鑾峰緱鏈夊叧瀛樺偍杩囩▼鐨勪俊鎭紙濡傚瓨鍌ㄨ繃绋嬬殑鎵鏈夎呫佸垱寤烘椂闂村強鍏跺弬鏁帮級銆
鍒楀嚭鎸囧畾瀛樺偍杩囩▼鎵浣跨敤鐨勫璞″強浣跨敤鎸囧畾瀛樺偍杩囩▼鐨勮繃绋嬨傛淇℃伅鍙敤鏉ヨ瘑鍒偅浜涘彈鏁版嵁搴撲腑鏌愪釜瀵硅薄鐨勬洿鏀规垨鍒犻櫎褰卞搷鐨勮繃绋嬨
鏌ョ湅瀛樺偍杩囩▼鐨勫畾涔
sp_helptext
鏄剧ず瑙勫垯銆侀粯璁ゅ笺佹湭鍔犲瘑鐨勫瓨鍌ㄨ繃绋嬨佺敤鎴峰畾涔夊嚱鏁般佽Е鍙戝櫒鎴栬鍥剧殑鏂囨湰銆
璇硶
sp_helptext [ @objname = ] 'name'
鍙傛暟
[@objname =] 'name'
瀵硅薄鐨勫悕绉帮紝灏嗘樉绀鸿瀵硅薄鐨勫畾涔変俊鎭傚璞″繀椤诲湪褰撳墠鏁版嵁搴撲腑銆俷ame 鐨勬暟鎹被鍨嬩负 nvarchar(776)锛屾病鏈夐粯璁ゅ笺
杩斿洖浠ｇ爜鍊
0锛堟垚鍔燂級鎴 1锛堝け璐ワ級
缁撴灉闆
鍒楀悕
鏁版嵁绫诲瀷
鎻忚堪
Text
nvarchar(255)
瀵硅薄瀹氫箟鏂囨湰
娉ㄩ噴
sp_helptext 鍦ㄥ涓涓樉绀虹敤鏉ュ垱寤哄璞＄殑鏂囨湰锛屽叾涓瘡琛屾湁 Transact-SQL 瀹氫箟鐨 255 涓瓧绗︺傝繖浜涘畾涔夊彧椹荤暀鍦ㄥ綋鍓嶆暟鎹簱鐨 syscomments 琛ㄧ殑鏂囨湰涓
鏉冮檺
鎵ц鏉冮檺榛樿鎺堜簣 public 瑙掕壊銆
绀轰緥
涓嬮潰鐨勭ず渚嬫樉绀 employee_insupd 瑙﹀彂鍣ㄧ殑鏂囨湰锛岃瑙﹀彂鍣ㄥ湪鏁版嵁搴 pubs 涓
USE pubs
EXEC sp_helptext 'employee_insupd'
鏌ョ湅鏈夊叧瀛樺偍杩囩▼鐨勪俊鎭 sp_help
鎶ュ憡鏈夊叧鏁版嵁搴撳璞★紙sysobjects 琛ㄤ腑鍒楀嚭鐨勪换浣曞璞★級銆佺敤鎴峰畾涔夋暟鎹被鍨嬫垨 Microsoft
