A中调用B
execute b 变量1,变量2
execute b 变量1,变量2
解决方案 »
- VS2008连接数据库的问题,求9,错误提示是这样的
- 在网页中,如何实现把txt文件导入到oracle
- 关于利用模板 自动生成 页面的 方法
- 问执行的先后顺序?
- 我在windows2003中安装了.net2003遇到了问题,请指教!急!
- 一段html代码 看不懂 请高手解释
- 用户定义控件中返回OleDbDataReader的问题,请帮忙看看,谢谢
- 水晶报表出现:"Error in File C:\WINDOWS\TEMP\temp_3eb04901-d93f-46cc-af29-db8807527b5c.rpt: Invalid group condition."错误 ,如何
- 如何动态创建一个控件
- 在网页中动态生成的HyperLink控件如何布局?比如换行等
- 菜鸟请教(急急急,在线等。。。)
- /*紧急*/可不可以像使用数组一样使用使用Session
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOALTER PROCEDURE ssEmpAdd
@empid int =null output,
@empcode varchar(20)=null,
@loginid varchar(16),
@name varchar(20),
@email varchar(50)=null,
@officetel varchar(50)=null,
@mobile varchar(20)=null,
@officefax varchar(20)=null,
@basnote text=null,
@sex bit,
@branchid smallint,
@dep1 smallint,
@dep2 smallint=null,
@dep3 smallint=null,
@pos1 varchar(20)=null,
@pos2 varchar(20)=null,
@pos3 varchar(20)=null,
@eloginid varchar(16),
@ename varchar(20),
@ip varchar(50),
@allowlogin bit=null,
@htel1 varchar(20)=null,
@bjdepid int=null,
@branchdep varchar(50)=null,
@stationid smallint=null,
@techid smallint=null,
@empstatus smallint=1
AS
insert into mrbaseinf(empcode,loginid,name,email,officetel,mobile,officefax,basnote,sex,branchid,pwd,allowlogin,htel1,bjdepid,branchdep,stationid,techid,empstatus)
values(@empcode,@loginid,@name,@email,@officetel,@mobile,@officefax,@basnote,@sex,@branchid,
'D4-1D-8C-D9-8F-00-B2-04-E9-80-09-98-EC-F8-42-7E',@allowlogin,@htel1,@bjdepid,@branchdep,@stationid,@techid,@empstatus)
set @empid=@@identity
insert into mrposition(empid,sortid,depid,positionid) values(@empid,1,@dep1,@pos1)
insert into mrposition(empid,sortid,depid,positionid) values(@empid,2,@dep2,@pos2)
insert into mrposition(empid,sortid,depid,positionid) values(@empid,3,@dep3,@pos3)
exec ssActLogAdd @ename,'添加员工','员工表',@name,@ip,@eloginid ---插入欢迎的提醒语名句
insert into ssRemindinf(empid,content)
values(@empid,'欢迎你第一次使用iloa.net,希望iloa.net能成为你日常办公中的好帮手!')
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO我要传递给B的变量是@empidB如下:SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOALTER PROCEDURE ssEmpAdduser
@id varchar(20)=null,
@woauserid varchar(50)=null,
@userid varchar(50)=null,
@username varchar(50)=null,
@comid varchar(20)=null,
@comname varchar(100)=null,
@depid bigint=null,
@depname varchar(50)=null,
@dutyid bigint=null,
@dutyname varchar(50)=null,
@editstate int=null,
@syncmess varchar(200)=null,
@standone varchar(50)=null,
@standtwo varchar(50)=null,
@standthree varchar(50)=null,
@re varchar(200)=null,
@synctime varchar(20)=null,
@logid varchar(50)=null,
@useridid bigint=null output
AS
declare @userdd bigint
execute ssEmpAdd @empid=@useridid
insert into woauser(id,woauserid,userid,username,comid,comname,depid,depname,dutyid,dutyname,editstate,syncmess,standone,standtwo,standthree,re,synctime,useridid)
values(@id,@woauserid,@userid,@username,@comid,@comname,@depid,@depname,@dutyid,@dutyname,@editstate,@syncmess,@standone,@standtwo,@standthree,@re,@synctime,@useridid)GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO请大家帮帮忙