随笔分类 -  DB

SQL server 数据同步 Merge 的一个小bug
摘要：a.Name NVarchar(40)b.Name Varchar(40)MERGEaASTARGETUSING(SELECTid,nameFROMb)ASSOURCEON(TARGET.[id]=SOURCE.[id])WHENMATCHEDANDCHECKSUM(TARGET.Name)!=CHECKSUM(CONVERT(NVARCHAR(40),SOURCE.[Name]))THENUPDATESETTARGET.[Name]=SOURCE.[Name],WHENNOTMATCHEDBYTARGETTHENINSERT([id],[Name])VALUES(SOURCE.[ID],S. 阅读全文

posted @ 2011-07-29 15:07 青春的虎子 阅读(361) 评论(0) 推荐(0)

四种sql server 数据库分页的测试
摘要：SET statistics io onSET STATISTICS TIME ONGOView Code ----1PRINT'fistbegin'DECLARE@timeDATETIMEDECLARE@msintSET@time=GETDATE()SELECT*FROMClient.clientAScINNERJOIN(SELECTRowNum,ClientIDFROM(SELECTROW_NUMBER()OVER(ORDERbyClientIDASC)ASRowNum,ClientIDFROMclient.client)ASccWHEREcc.RowNumbetween1 阅读全文

posted @ 2011-07-22 11:41 青春的虎子 阅读(597) 评论(1) 推荐(0)

use Stored procedure return a tabel(存储过程返回table)
摘要：存储过程返回tableCREATE PROCEDURE ax INTASSELECT * FROM TABLE WHERE XX > x -- no RETURN DECLARE @a INT = 1CREATE @VarTable Table( *)INERT @VarTableEXEC A @a 阅读全文

posted @ 2011-03-23 14:45 青春的虎子 阅读(547) 评论(0) 推荐(0)

导航