如何在sql server 2008中批量更新

发布于 2024-12-14 04:11:42 字数 397 浏览 4 评论 0原文

我有一个包含 10000 条记录的表，现在我添加了用于放置明文密码的字段，所以现在我想更新所有记录，但应该根据用户名更新新字段...如下所示。

update users set secdetail = case when username = 'abbas' then 'abbas@123' .... end

我正在使用 sqlcommand 从 .net 代码运行此查询，每当我在加载一段时间后尝试刷新页面时，我都会收到一条消息，提示“

The query processor ran out of stack space during query optimization. Please simplify the query

请帮忙”。

原文

i have a table which contains 10000 records, now i have added the field for placing the plaintext password, so now i want to update all the records, but should update the new field on the basis of the username... like below.

update users set secdetail = case when username = 'abbas' then 'abbas@123' .... end

i am running this query from .net code, using sqlcommand, whenever i try to refresh the pagem after loading for sometime, i gets a message saying,

The query processor ran out of stack space during query optimization. Please simplify the query

Please help.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

守不住的情 2024-12-21 04:11:42

为什么不在 .net 代码中创建一个循环来生成由分号分隔的正确 sql 更新语句

Update Users Set Secdetail = 'abbas@123' Where Username = 'abbas';
Update Users Set Secdetail = 'bbbas@123' Where Username = 'bbbas';
Update Users Set Secdetail = 'cbbas@123' Where Username = 'cbbas';
...

Why not create a loop in your .net code to produce proper sql update statements separated by semicolins

Update Users Set Secdetail = 'abbas@123' Where Username = 'abbas';
Update Users Set Secdetail = 'bbbas@123' Where Username = 'bbbas';
Update Users Set Secdetail = 'cbbas@123' Where Username = 'cbbas';
...

回复收藏 0 原文

~没有更多了~