UPDATE ZlEmployee
SET ZhiWu='' WHERE ZhiWu IS NULL UPDATE ZlEmployee
SET Dept='' WHERE Dept IS NULL
IF (SELECT OBJECT_ID('TEMPDB..#DeptZhiWu'))>0
DROP TABLE #DeptZhiWu
SELECT Code,Name,CONVERT(CHAR(30),'') AS ZhiWuCode,
CONVERT(CHAR(30),'') AS ZhiWuName, CONVERT(INT,0) AS BianZhi,
CONVERT(INT,0) AS DaoZhiRs,CONVERT(INT,0) AS WeiDaoZhiRs,Manager
INTO #DeptZhiWu
FROM ZlDept Where Code like '1001%' IF (SELECT OBJECT_ID('tempdb..#Dept_ZhiWu'))>0
DROP TABLE #Dept_ZhiWu
SELECT * INTO #Dept_ZhiWu
FROM Dept_ZhiWu
WHERE 1=2
INSERT INTO #Dept_ZhiWu(DEptCode,ZhiWuCode,BianZhi)
SELECT DEPT,ZhiWu,0
FROM ZlEmployee
WHERE ZhiWu<>'' AND Dept<>''
GROUP BY DEPT,ZhiWu INSERT INTO #Dept_ZhiWu
SELECT *
FROM Dept_ZhiWu
WHERE Not Exists(SELECT *
FROM #Dept_ZhiWu
WHERE DeptCode=Dept_ZhiWu.DeptCode AND ZhiWuCode=Dept_ZhiWu.ZhiWuCode)
。像这样长的sql语句如何在asp.net中执行,且要邦定DataGrid呀
SET ZhiWu='' WHERE ZhiWu IS NULL UPDATE ZlEmployee
SET Dept='' WHERE Dept IS NULL
IF (SELECT OBJECT_ID('TEMPDB..#DeptZhiWu'))>0
DROP TABLE #DeptZhiWu
SELECT Code,Name,CONVERT(CHAR(30),'') AS ZhiWuCode,
CONVERT(CHAR(30),'') AS ZhiWuName, CONVERT(INT,0) AS BianZhi,
CONVERT(INT,0) AS DaoZhiRs,CONVERT(INT,0) AS WeiDaoZhiRs,Manager
INTO #DeptZhiWu
FROM ZlDept Where Code like '1001%' IF (SELECT OBJECT_ID('tempdb..#Dept_ZhiWu'))>0
DROP TABLE #Dept_ZhiWu
SELECT * INTO #Dept_ZhiWu
FROM Dept_ZhiWu
WHERE 1=2
INSERT INTO #Dept_ZhiWu(DEptCode,ZhiWuCode,BianZhi)
SELECT DEPT,ZhiWu,0
FROM ZlEmployee
WHERE ZhiWu<>'' AND Dept<>''
GROUP BY DEPT,ZhiWu INSERT INTO #Dept_ZhiWu
SELECT *
FROM Dept_ZhiWu
WHERE Not Exists(SELECT *
FROM #Dept_ZhiWu
WHERE DeptCode=Dept_ZhiWu.DeptCode AND ZhiWuCode=Dept_ZhiWu.ZhiWuCode)
。像这样长的sql语句如何在asp.net中执行,且要邦定DataGrid呀
dim str as string
str="updata ZlEmployee set"
然后弄一些条件语句 对str 增增减减
一个类型 一个str 这样可以执行的吧
这么长的sql用存储过程阿