Tuesday, 28 August 2018
Subscribe to:
Post Comments (Atom)
ALTER PROCEDURE MyProc
@input char(10)
AS
BEGIN
SET NOCOUNT ON;
SELECT isonum
FROM iso where isonum LIKE '%' + @input + '%'
ORDER BY isonum
END
isonum from iso where isonum like '%2333%'
- I get the data,but when executing the stored procedure:exec MyProc '2333'
- I get nothing???@input char(10)
to @input varchar(10)
isonum from iso where isonum like '%2333 %'
Hello Friends! I am Ramana a part time blogger from Hyderabad.
0 comments:
Post a Comment