摘要：usedbnameifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[changename]')andOBJECTPROPERTY(id,N'IsProcedure')=1)dropprocedure[dbo].[changename]GOSETQUOTED_IDENTIFIEROFFGOSETANSI_NULLSOFFGOCreatePROCEDUREdbo.changename@OldOwnerasNVARCHAR(128),--参数原所有者@NewOwnerasNVARCHAR(128) 阅读全文