数据库更新多项方法？

[九月_leaf]

数据库用列名 id,key,value ，一共有n项数据,id为id1-idn, 值为value1-valueN，如果要一次更新这n项值，需要怎么写更新sql

[ouyh12345]

一个一个地更新吧

[franzhong]

	int IDs[]= {1,2,3,4,5,6}; 
	char* VALs[]={"A","B","C","D","E","F"};
	int countArr = sizeof(IDs) / sizeof(IDs[0]);
	
	while(countArr){
	--countArr;
	//在这儿循环更新
	cout<<"updata table1("<<IDs[countArr]<<",key,value) values(123,'abc',"<<VALs[countArr]<<");"<<" Updata Finished!"<<endl;
	}

[sg_knight]

DECLARE @Index	INT;
DECLARE @n	INT;
DECLARE @ID	VARCHAR(10);
DECLARE @VALUE  VARCHAR(10); 

SET @Index = 0;
SET @n = 10;
WHILE(@Index < @n)
BEGIN
	SET @ID = 'ID' + CONVERT(VARCHAR(1), @Index);
	SET @VALUE = 'VALUE' + CONVERT(VARCHAR(1), @Index);
	UPDATE TEST SET id = @ID, value = @VALUE WHERE KEYID = @Index;
	SET @Index = @Index + 1;
END

楼主可以参考下，关键ID和VALUE的值要有规律可循，要不就只能一个个更新了。