34,575
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t
CREATE TABLE #T(id INT IDENTITY(1,1) primary KEY,s VARCHAR(100))
GO
INSERT INTO #t(s) VALUES('a')
GO 10
DELETE FROM #t WHERE id<3
SELECT * FROM #t
SELECT * into #tt FROM #t ORDER BY id
TRUNCATE TABLE #t
select ident_current('#t')
INSERT INTO #t
SELECT s FROM #tt ORDER BY ID
SELECT * FROM #t
int id = 1;
//遍历一个表多行一列
foreach (DataRow row in MyDataSet.Tables[0].Rows)
{
//读取当前编号ID
string tID = row[0].ToString(); //数据表的第1列=编号ID
//修改ID号,从1开始递进
string sqlCommd = "update tb_ControllerType set ID='" + id + "' where ID='" + Convert.ToInt32(tID) + "'";
MySqlConnect.ExecuteNonQueryCommand(sqlCommd, Global_Parameter.str_SqlConnect);
id++;
}