--查詢表結(jié)構(gòu)
SELECT sys.syscolumns.NAME 字段,sys.systypes.NAME 類型, sys.syscolumns.length 長(zhǎng)度 FROM SysColumns INNER JOIN systypes ON sys.syscolumns.xtype = sys.systypes.xtype
WHERE syscolumns.id=object_id('表名') AND sys.systypes.NAME<>'sysname'
--獲取存儲(chǔ)過程內(nèi)容
select text from syscomments WITH(NOLOCK) where id=object_id('存儲(chǔ)過程')
--查詢數(shù)據(jù)庫中存儲(chǔ)過程
select name from QWMS_CSMC.dbo.sysobjects WITH(NOLOCK) where xtype='P'
--數(shù)據(jù)庫分頁
SELECT TOP (10) * -- 10 pageSize
FROM ( SELECT row_number() OVER (ORDER BY EmployeeBasic .UID ASC ) [row_number],* FROM [dbo].[EmployeeBasic]
) AS temp
WHERE temp.[row_number] > 1*10 --pageIndex*pageSize
ORDER BY temp .UID ASC
刪除重復(fù)
重復(fù)數(shù)據(jù)：
重復(fù)數(shù)據(jù)
--排除重復(fù)數(shù)據(jù) 關(guān)鍵點(diǎn)：有一個(gè)能夠排序字段场躯，然后根據(jù)字段去排除大于部分或者小于部分?jǐn)?shù)據(jù)
SELECT id,zexno,tknum FROM [dbo].[Z_SD_RFC_SENDDATA_EC] AS Z WHERE ZEXNO ='0003415668'
AND EXISTS (SELECT 'Y' FROM [Z_SD_RFC_SENDDATA_EC] AS T WHERE T.TKNUM =Z.TKNUM AND T.ZEXNO=Z.ZEXNO
AND T.ID>Z.ID)
得到結(jié)果：
結(jié)果
