ALTER Procedure mingcheng
as
create table #table1
(
a1 varchar(50),
a2 varchar(50)
)
insert #table1 (a1,a2)
select name,pass from user where name='' or pass=''
第一次玩这玩意,红色部分,我想从页面传入两个值,是随机的,现在怎么定义临时表的参数.....,还有上面只是看了一下素材,写的,不知结尾还要有啥标志,语法有没有错误?希望高手指点
------解决方案--------------------
declare @name as varchar(100)
declare @pass as varchar(100)
set @name = '页面传过来的值'
set @pass = '页面传过来的值'
insert #table1 (a1,a2) select name,pass from user where [email protected] or [email protected]
------解决方案--------------------
可以不用临时表，直接在需要的表里查询
- SQL code
ALTER Procedure mingcheng --两个参数@name varchar(100),@pass varchar(100)asselect *from tbnamewhere name = @name and pass = @pass --或 orgo--执行exec mingcheng '张三','123456'