摘要:
drop procedure if exists UP_SYS_GetBillId;/* 创建:Jaxk 2017-03-31 功能:get bill id */ create procedure UP_SYS_GetBillId ( ProgramID INT, out BillID varcha 阅读全文
摘要:
UDF:用户定义函数 CTE:通用 表 表达式set nocount on;use zhubenxigoif object_id('dbo.Parts') is not nulldrop table dbo.Parts;if OBJECT_ID ('dbo.BOM') IS NOT NULLDROP 阅读全文
摘要:
if Exists (Select * from sys.Objects where object_id=object_id(N'dbo.TestRowToColumn') and type in (N'U') )drop table dbo.TestRowToColumngo create tab 阅读全文