比如有一函数:
create function fn (@id nvarchar(50))
returns nvarchar(50)
as
begin
return @id
end
select dbo.fn(01) 得出的结果是1.
但是我想要的是select dbo.fn(0123223)得出0123223.
select dbo.fn(000111022)得出000111022怎么解决?谢谢!
create function fn (@id nvarchar(50))
returns nvarchar(50)
as
begin
return @id
end
select dbo.fn(01) 得出的结果是1.
但是我想要的是select dbo.fn(0123223)得出0123223.
select dbo.fn(000111022)得出000111022怎么解决?谢谢!
select dbo.fn('0123223')
--你给的参数是nvarchar类型的,而你传入的饿参数是int类型的
--肯定不是你要的结果了create function fn (@id nvarchar(50))
returns nvarchar(50)
as
begin
return @id
endselect dbo.fn('0123223')/*
--------------------------------------------------
0123223(所影响的行数为 1 行)*/drop function fn