如:
create procedure adduser
@username
sysname,
@password
varchar(20),
@loginname
sysname,
@popedomRange
varchar(3),
@popedom
varchar(1),
@state
varchar(10),
@section
varchar(100),
@trueName
varchar(30),
@officePhone varchar(20),
@homePhone
varchar(20),
@movPhone
varchar(20),
@eMail
varchar(100),
@officeAddress varchar(200),
@homeAddress varchar(200)
as
begin
insert into dbo.tbl_grduser(name, password, popedomRange, popedom, state,
section, trueName, officePhone, homePhone, movPhone, eMail,
officeAddress, homeAddress, grdSysName, grdSysInputDate)
values (@username, @password, @popedomRange, @popedom, @state,
@section, @trueName, @officePhone, @homePhone, @movPhone, @eMail,
@officeAddress, @homeAddress, @loginname, getdate())
select username=@username
select password=@password
EXEC sp_addlogin 变量,变量
EXEC sp_adduser 变量,变量
grant select on tbl_stu_basicInfo to grdstore
end
go
---好象哪个变量sqlserver直接看作是常量!!!
在变量上加什么符号??
谢谢大家!急!!!!!!
|