34,588
社区成员
发帖
与我相关
我的任务
分享
string tmpStr = @"(Select Distinct A.* FROM MOCTC AS A LEFT JOIN MOCTD AS B ON A.TC001=B.TD001 AND A.TC002=B.TD002 Where '+ @Keywords+' )";
string str = @"(SELECT TOP " + pagesize.ToString() + " * FROM " + tmpStr + " as A WHERE CHECKSUM(TC001,TC002) NOT IN (SELECT TOP " + Convert.ToString(pagesize * (pageindex - 1)) + " CHECKSUM(TC001,TC002) FROM " + tmpStr + " AS A ORDER BY TC001,TC002) ORDER BY TC001,TC002) ";
string sql = "Select A.* ,B.MQ002 AS TC0012,C.MB002 AS TC0042,D.MD002 AS TC0052,E.MA002 AS TC0062,F.MA002 AS TC0152,G.ME002 AS TC0212 From " + str + " as A LEFT JOIN CMSMQ as B ON A.TC001=B.MQ001 LEFT JOIN CMSMB as C ON A.TC004=C.MB001 LEFT JOIN CMSMD as D ON A.TC005=D.MD001 LEFT JOIN PURMA as E ON A.TC006=E.MA001 LEFT JOIN DSCSYS.dbo.DSCMA AS F ON A.TC015=F.MA001 LEFT JOIN CMSME AS G ON A.TC021=G.ME001";
Select A.* FROM MOCTC AS A LEFT JOIN MOCTD AS B ON A.TC001=B.TD001 AND A.TC002=B.TD002 Where (A.TC008='54' OR A.TC008='55')
Select distinct CHECKSUM(TC001,TC002) as a FROM MOCTC AS A LEFT JOIN MOCTD AS B ON A.TC001=B.TD001 AND A.TC002=B.TD002 Where (A.TC008='54' OR A.TC008='55')
Select distinct Binary_CHECKSUM(TC001,TC002) as a FROM MOCTC AS A LEFT JOIN MOCTD AS B ON A.TC001=B.TD001 AND A.TC002=B.TD002 Where (A.TC008='54' OR A.TC008='55')
select Checksum('5402','20091216005')
select Checksum('5401','20091216035')
/*
-----------
-502171623
(1 行受影响)
-----------
-2112784375
(1 行受影响)
*/
select Checksum('5402','20091216005')
select Checksum('5401','20091216035')
-----------
-502171623
(所影响的行数为 1 行)
-----------
-2112784375
(所影响的行数为 1 行)