SQL语句中的输出字段用.doc

《SQL语句中的输出字段用.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、namevarchar(10),valueint)ÄãµÄsqlÓ¦¸ÃÕâôд(Óô洢¹ý³Ì):createprocp_ins_alm_msgmsg_countintoutasmsg_countifrowcount=0return-1000insertintotable1(field0)values(msg_count)return0goÔÚsqlserverÖÐÈçºÎʹÓÃsqlÓï¾äÐ޸ıíÖеÄ×Ö¶ÎÃû³Æ?a.ÖØÃüÃû±íÏÂÀý½«±ícustomersÖØÃüÃûΪcusts¡£execsp_renamecustomers,custsb.ÖØÃ

2、üÃûÁÐÏÂÀý½«±ícustomersÖеÄÁÐcontacttitleÖØÃüÃûΪtitle¡£execsp_renamecustomers.[contacttitle],title,columnÔõôÄÇô²»Ï²»¶²é¿´Áª»ú°ïÖúÄØÔõôÓÃsqlÓï¾äÔÚsql2008ÖеıíÖÐÌí¼ÓÊý¾Ý×ֶζøÇÒ²»ÊÇ¿Õ×Ö¶ÎÌí¼Ó×ֶΣºalerttablenameadd×Ö¶ÎÃûÊôÐÔÌí¼Ó´øĬÈÏÖµµÄ×Ö¶Îalerttablenameadd×Ö¶ÎÃûÊôÐÔdefaultÖµÀýÈ磺alertmytablea

3、ddnamevarchar(20)defaultwangminƪ¶þ£ºÓÃsqlÓï¾ä±íÓë×ֶεĻù±¾²Ù×÷¡¢Êý¾Ý¿â±¸·ÝµÈÓÃsqlÓï¾äÌí¼Óɾ³ýÐÞ¸Ä×Ö¶Î1.Ôö¼Ó×Ö¶Îaltertabledocdspadddspcodechar(200)2.ɾ³ý×Ö¶Îaltertabletable_namedropcolumncolumn_name3.ÐÞ¸Ä×Ö¶ÎÀàÐÍaltertabletable_namealtercolumncolumn_namenew_data_type4.sp_rename¸ÄÃû¸ü¸Äµ±Ç°Êý¾Ý¿âÖÐ

4、Óû§´´½¨¶ÔÏó£¨Èç±í¡¢ÁлòÓû§¶¨ÒåÊý¾ÝÀàÐÍ£©µÄÃû³Æ¡£Óï·¨sp_rename[objname=]object_name,[newname=]new_name[,[objtype=]object_type]È磺execsp_renamenewname,partstock5.sp_helpÏÔʾ±íµÄһЩ»ù±¾Çé¿ösp_helpobject_nameÈ磺execsp_helppartstock6.ÅжÏijһ±ípartstockÖÐ×Ö¶ÎpartvelocityÊÇ·ñ´æÔÚifexists(select*from

5、syscolumnswhereid=object_id(partstock)andname=partvelocity)printpartvelocityexistselseprintpartvelocitynotexistsÁí·¨£ºÅжϱíµÄ´æÔÚÐÔ£ºselectcount(*)fromsysobjectswheretype=uandname=ÄãµÄ±íÃûÅжÏ×ֶεĴæÔÚÐÔ£ºselectcount(*)fromsyscolumnswhereid=(selectidfromsysobjectswheretype=uandname=ÄãµÄ±íÃû)andna

6、me=ÄãÒªÅжϵÄ×Ö¶ÎÃûÒ»¸öСÀý×Ó--¼ÙÉèÒª´¦ÀíµÄ±íÃûΪ:tb--ÅжÏÒªÌí¼ÓÁеıíÖÐÊÇ·ñÓÐÖ÷¼üifexists(select1fromsysobjectswhereparent_obj=object_id(tb)andxtype=pk)beginprint±íÖÐÒѾÓÐÖ÷¼ü,ÁÐÖ»ÄÜ×öΪÆÕͨÁÐÌí¼Ó--Ìí¼ÓintÀàÐ͵ÄÁÐ,ĬÈÏֵΪ0altertabletbaddÁÐÃûintdefault0endelsebeginprint±íÖÐÎÞÖ÷¼ü,Ìí¼ÓÖ÷¼üÁÐ--Ìí¼Ói

7、ntÀàÐ͵ÄÁÐ,ĬÈÏֵΪ0altertabletbaddÁÐÃûintprimarykeydefault0end1.Ëæ»ú¶ÁÈ¡Èô¸ÉÌõ¼Ç¼accessÓï·¨£ºselecttop10*from±íÃûorderbyrnd(id)sqlserver:selecttopn*from±íÃûorderbynewid()mysqlselect*from±íÃûorderbyrand()l