ALTER PROCEDURE [dbo].[Qf_LoginRecord]
@empid int,
@EmpCheckCode varchar(50),
@Ret int output
AS
set @Ret=1
BEGIN
insert into dbo.Qf_UserAccount (Empid,EmpRant,EmpMobile,EmpCheckCode,CreateTime)
select @empid,empRant=cast(rand(binary_checksum(newid()))*3 as int)+1,empmobile=(select mobile from [172.16.1.245].[jxtshare].[dbo].[Ad_Employ] where empid=@empid),@EmpCheckCode,getdate()
if @@error=0
begin
set @Ret=0
return
end
END
有这么一个存储过程
在asp.net 中调用这个存储过程
private void loginrecord()
{
Jxllt.DBUtility.DbHelperSQL.ConnDataBase("jxtmsg", "");
SqlParameter[] list ={ new SqlParameter("@empid", SqlDbType.Int), new SqlParameter("@EmpCheckCode", SqlDbType.VarChar,50), new SqlParameter("@Ret", SqlDbType.Int) };
list[0].Value =Convert.ToInt32(this.txtEmpid.Text);
list[1].Value = Hid_code.Value.ToString();
list[2].Direction = ParameterDirection.Output;
Jxllt.DBUtility.DbHelperSQL.ExecRunProce("Qf_LoginRecord", list);
}
我现在想把ALTER PROCEDURE [dbo].[Qf_LoginRecord]
@empid int,
@EmpCheckCode varchar(50),
@Ret int output
AS
set @Ret=1
BEGIN
insert into dbo.Qf_UserAccount (Empid,EmpRant,EmpMobile,EmpCheckCode,CreateTime)
select @empid,empRant=cast(rand(binary_checksum(newid()))*3 as int)+1,empmobile=(select mobile from [172.16.1.245].[jxtshare].[dbo].[Ad_Employ] where empid=@empid),@EmpCheckCode,getdate()
if @@error=0
begin
set @Ret=0
return
end
END
有这么一个存储过程
在asp.net 中调用这个存储过程
private void loginrecord()
{
Jxllt.DBUtility.DbHelperSQL.ConnDataBase("jxtmsg", "");
SqlParameter[] list ={ new SqlParameter("@empid", SqlDbType.Int), new SqlParameter("@EmpCheckCode", SqlDbType.VarChar,50), new SqlParameter("@Ret", SqlDbType.Int) };
list[0].Value =Convert.ToInt32(this.txtEmpid.Text);
list[1].Value = Hid_code.Value.ToString();
list[2].Direction = ParameterDirection.Output;
Jxllt.DBUtility.DbHelperSQL.ExecRunProce("Qf_LoginRecord", list);
}
我现在想把empRant的值在这里面取出来,应该怎么做,能不能实实现
@empid int,
@EmpCheckCode varchar(50),
@Ret int output
AS
set @Ret=1
BEGIN
insert into dbo.Qf_UserAccount (Empid,EmpRant,EmpMobile,EmpCheckCode,CreateTime)
select @empid,empRant=cast(rand(binary_checksum(newid()))*3 as int)+1,empmobile=(select mobile from [172.16.1.245].[jxtshare].[dbo].[Ad_Employ] where empid=@empid),@EmpCheckCode,getdate()
if @@error=0
begin
set @Ret=0
return
end
END
有这么一个存储过程
在asp.net 中调用这个存储过程
private void loginrecord()
{
Jxllt.DBUtility.DbHelperSQL.ConnDataBase("jxtmsg", "");
SqlParameter[] list ={ new SqlParameter("@empid", SqlDbType.Int), new SqlParameter("@EmpCheckCode", SqlDbType.VarChar,50), new SqlParameter("@Ret", SqlDbType.Int) };
list[0].Value =Convert.ToInt32(this.txtEmpid.Text);
list[1].Value = Hid_code.Value.ToString();
list[2].Direction = ParameterDirection.Output;
Jxllt.DBUtility.DbHelperSQL.ExecRunProce("Qf_LoginRecord", list);
}
我现在想把ALTER PROCEDURE [dbo].[Qf_LoginRecord]
@empid int,
@EmpCheckCode varchar(50),
@Ret int output
AS
set @Ret=1
BEGIN
insert into dbo.Qf_UserAccount (Empid,EmpRant,EmpMobile,EmpCheckCode,CreateTime)
select @empid,empRant=cast(rand(binary_checksum(newid()))*3 as int)+1,empmobile=(select mobile from [172.16.1.245].[jxtshare].[dbo].[Ad_Employ] where empid=@empid),@EmpCheckCode,getdate()
if @@error=0
begin
set @Ret=0
return
end
END
有这么一个存储过程
在asp.net 中调用这个存储过程
private void loginrecord()
{
Jxllt.DBUtility.DbHelperSQL.ConnDataBase("jxtmsg", "");
SqlParameter[] list ={ new SqlParameter("@empid", SqlDbType.Int), new SqlParameter("@EmpCheckCode", SqlDbType.VarChar,50), new SqlParameter("@Ret", SqlDbType.Int) };
list[0].Value =Convert.ToInt32(this.txtEmpid.Text);
list[1].Value = Hid_code.Value.ToString();
list[2].Direction = ParameterDirection.Output;
Jxllt.DBUtility.DbHelperSQL.ExecRunProce("Qf_LoginRecord", list);
}
我现在想把empRant的值在这里面取出来,应该怎么做,能不能实实现
declare @num int, @sql nvarchar(4000)
set @sql= 'select @a=count(*) from tableName '
exec sp_executesql @sql,N '@a int output ',@num output
select @num