Why won't my SQL Server database show any results while running stored procedure? -
please @ code created. first block stored procedure created.
the second block me running code manually, bypassing stored procedure.
the 3rd block me running code using stored procedure.
when run code without stored procedure, results. when run code via stored procedure, don't anything, though it's presumably same code.
alter procedure [dbo].[uspchecksalevin] @vin nvarchar(17) select * sales vin = @vin select * sales (vin = 09872345098723457) go uspchecksalevin 09872345098723457
do like:
uspchecksalevin '09872345098723457'
this because 09872345098723457 numeric , leading 0 truncated literal. of course work if have non 0 leading digit.
proof:
create procedure test @p varchar(5) select @p go exec test 01234 exec test '01234'
outputs:
1234 01234
Comments
Post a Comment