02 2010 档案
摘要：How to Debug your Stored Procedure?In many cases, you might want to test your SP on various scenarios and go through each step on how your data gets changed at each step.The below steps should help yo...
阅读全文
摘要：Create Procedure truncateAllTables@dbName nvarchar(512)As/* It truncates all tables in specified database @dbName.*/Declare@sqlString nvarchar(4000);Set@sqlString = 'Declare @t nvarchar (1024)Declare...
阅读全文
摘要：1--从Table表中取出第m条到第n条的记录：(NotIn版本)23SELECTTOPn-m+1*4FROMTable5WHERE(idNOTIN(SELECTTOPm-1idFROMTable))678--从TABLE表中取出第m到n条记录(Exists版本)910SELECTTOPn-m+1*FROMTABLEASaWHERENotExists11(Select*From(SelectTop...
阅读全文
摘要：Delete与Top连用限制删除行 晚上写程序，希望使用top关键字限制删除行的范围，试了几次总是发现语句不能执行。当时自己的思路是这样的 delete producttemp where productid in （select top 5* from producttemp）google了一下发现Csdn上面给类似问题的回复与我写出的sql语句思路差不多，估计大家都没有试验过，就凭自己感觉这么...
阅读全文
摘要：select a.name 表名,b.name 列名 from sysobjects a,syscolumns b where a.id=b.id and b.name='字段名' and a.type='U'
阅读全文
摘要：CREATE PROCEDURE spAutoProc_ZField @SourceTableName varchar(50), @TargetTableName varchar(50), @FieldMapTable varchar(50)ASDECLARE @altQuerynvarchar(1000),@sqlnvarchar(1000),@updQuerynvarchar(1000),@c...
阅读全文
