November 15, 2011 at 6:28 am
hi everyone,as im new to sql server i would like you to help me with the stored procedures.
the requirement is to get the data in the dropdownlist.
i have a table with columns cat_id and category_name and i have to write the stored procedure for this.
November 15, 2011 at 7:19 am
You're going to have to give us a lot more than that...
What do you have so far? Where specifically are you stuck?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 15, 2011 at 1:39 pm
hi everyone,as im new to sql server i would like you to help me with the stored procedures.
the requirement is to get the data in the dropdownlist.
i have a table with columns cat_id and category_name and i have to write the stored procedure for this.
You're not really giving anyone enough to really go on to offer assistance...but I think this may help:
CREATE PROCEDURE dbo.web_ddl_GetCategories AS
-- EXEC dbo.web_ddl_GetCategories
SELECT
cat_id, category_name
FROM dbo.CategoryTable
ORDER BY cat_id
GO
I assume this is a web or some sort of .Net application?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply