CREATE PROCEDURE [dbo].[Products_SelectDropDownListData] AS BEGIN SET NOCOUNT ON; SELECT [ProductID], [ProductName] FROM [dbo].[Products] ORDER BY [ProductName] ASC END