求删除包含指定数据的记录的脚本 需要删除 user 表中,列 username 包含有 (已注销)的所有记录,如 张三(已注销) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 delete from user where username like '%(已注销)%' delete from [user] where charindex('(已注销)',username)>0delete from [user] where username like '%(已注销)%' delete from user where name like '%己注销%' delete from [user] where username like '%(已注销)%'delete from [user] where charindex('(已注销)',username)>0 试用 openquery 函数查询 查询结果分组排序的问题~~各位大大们来啊!! 如何返回Select语句的第一条记录给变量? SQL语句优化经验 sql server 2005 怎样修改表的模式schema 请指教! 如何用一个连接字符串连接2个数据库 急!!哪位大侠知道我安装的MSSQL2000为什么全文索引不可用(没有microsoft search服务) 关于MYSQL与SQL2005/2008数据库的问题 再请帮忙看看~ 这个问题有点难度,盼高手出手! SQL Server DTS/SSIS 滥用之复制数据库对象 在SQL上连接ORCAL数据库正常,查询数据时报错
delete from [user] where username like '%(已注销)%'
delete from user where name like '%己注销%'
delete from [user] where username like '%(已注销)%'delete from [user] where charindex('(已注销)',username)>0