problem with stored procedure

Question

0.00/5 (No votes)

See more:

i want to show value of column sub for each row in table,but stored peocedure returns 0 while executing, column sub has type varchar

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[subcat]

@main varchar(max)

as
begin
select sub from category where main='@main'

end

Posted 19-Oct-13 19:02pm

Abhishek Ginani

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Accepted Answer · 2013-10-19T19:19:00

Solution 1

Remove the single quotes, use like below

SQL

select sub from category where main=@main

Posted 19-Oct-13 19:19pm

thatraja

problem with stored procedure

1 solution

Solution 1

Add your solution here

Preview 0

problem with stored procedure

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us