摘要:
onclick="Approve(' + '\'' + R[i]["RowID"] + '\',' + '\'' + i + '\'); return false;" 阅读全文
摘要:
1. 分割后按顺序取数据 /* fnMain_GetStrSegment (SQL_SCALAR_FUNCTION)Description: Extracts a specific segment of a string, given the delimiterUsage remarks / exa 阅读全文
摘要:
SELECT dateadd(ms,0,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)) SELECT dateadd(ms,-3,DATEADD(dd, DATEDIFF(dd,-1,getdate()), 0))SELECT DATEADD(mm, DATEDI 阅读全文
摘要:
DECLARE @Name NVARCHAR(50),@NRIC NVARCHAR(15),@PersonID INTDECLARE CUR_Test CURSOR FORSELECT [Name],NRIC,PersonID FROM tblCtcPersonTest1 OPEN CUR_Test 阅读全文
摘要:
DECLARE @Name NVARCHAR(50),@NRIC NVARCHAR(15),@PersonID INTDECLARE CUR_Test1 CURSOR FORSELECT [Name],NRIC,PersonID FROM tblCtcPersonTest1 OPEN CUR_Tes 阅读全文