2.7w+
社区成员
- 全部
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
dick_lee 2005-01-14
注解是用/*或--
dick_lee 2005-01-14
记住好像存储过程里没有for循环的，有while.
xluzhong 2005-01-14
create procedure 存储过程名称
@type varcahr(10) -----输入参数
as
----
select *
from tablename
where type=@type
----sql语句
go
@type varcahr(10) -----输入参数
as
----
select *
from tablename
where type=@type
----sql语句
go
daijingjie2002 2005-01-14
create proc p
as
select * from item
返回一个表
create proc p
@s varchar(10)
as
select * from item where item_no=@s
传递参数进去，再返回表
as
select * from item
返回一个表
create proc p
@s varchar(10)
as
select * from item where item_no=@s
传递参数进去，再返回表
venket 2005-01-14
e.g
create proc res
@table varchar(20)
as
select count(*) 结果集 from @table
create proc res
@table varchar(20)
as
select count(*) 结果集 from @table
iswear428 2005-01-14
CREATE PROCEDURE dbo.YOUPRO
@TYPE varchar(9)
AS
SELECT ID,NAME,SEX ,TYPE
FROM YOUTABLE
WHERE TYPE=@TYPE
ORDER BY ID
GO
@TYPE varchar(9)
AS
SELECT ID,NAME,SEX ,TYPE
FROM YOUTABLE
WHERE TYPE=@TYPE
ORDER BY ID
GO
