CREATE PROCEDURE test
@TName varchar(255)
AS
select * from @TName where flag<>'0'
delete from @TName where flag='-1'
update @TName set flag='0'
GO
@TName varchar(255)
AS
select * from @TName where flag<>'0'
delete from @TName where flag='-1'
update @TName set flag='0'
GO
解决方案 »
- 用何种方案能将sql数据库中的数据有条件的导入access数据库中,请高手指点。。。。
- sql语句
- 求查询同一表中字段变化数据
- 触发器的一个问题,请大家教教我,谢谢!!!!!
- 请教一个收藏页面的数据库设计
- 好奇怪的问题,急死我了,快帮帮我!
- 简单问题
- [请教]门户网站产品库搜索问题???
- 寻求SQL server数据库大量临时记录集的解决方法
- 触发器?!
- 在ESQL中如何执行存储过程?
- 当我对adoquery1 post 时,出现错误:Row cannot be located for updating。Some values may have been changed since it was last read.
AS
execute('select * from '+@TName+' where flag<>''0''')
execute('delete from '+@TName+' where flag=''-1''')
execute('update '+@TName+' set flag=''0''')
GO
如果你英文可以,推荐你一篇文章,很不错的:
http://www.algonet.se/~sommar/dynamic_sql.html
AS
execute('select * from ['+@TName+'] where flag<>''0''')
execute('delete from ['+@TName+'] where flag=''-1''')
execute('update ['+@TName+'] set flag=''0''')
GO