随笔档案「2014年6月」 - tkaren

摘要：前台：借款审批单 ----------------------------------- ... 阅读全文

posted @ 2014-06-05 10:44 tkaren

摘要：CREATE trigger [dbo].[Debt_Insert] on [dbo].[Debt] for insert as declare @tmpOrderID1 varchar(30)select @tmpOrderID1= OrderID from debt where OrderID ... 阅读全文

posted @ 2014-06-05 10:38 tkaren

sql语句判断默认值为getdate()的约束是否存在

摘要：TFlowCreateTask--表名AddDate--字段名if not exists( select d.name from syscolumns a join sysobjects b on a.id=b.id join syscomments... 阅读全文

posted @ 2014-06-05 10:34 tkaren 阅读(674) 评论(0) 推荐(0)