create procedure nums
@no char(10),@num nvarchar(15)
with encryption
as
select [UserNum] from [NT_sys_admin]
where adminGroupNumber =@no
go
declare @n nvarchar(15)
exec nums '00000001',@n
print @n
go
数据表结构如下
内有一条记录
记录下来自己学习备忘,O(∩_∩)O~
create procedure nums
@no char(10),@num nvarchar(15)
with encryption
as
select [UserNum] from [NT_sys_admin]
where adminGroupNumber =@no
go
declare @n nvarchar(15)
exec nums '00000001',@n
print @n
go
数据表结构如下
内有一条记录
记录下来自己学习备忘,O(∩_∩)O~