|
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- Stored Procedure usp_Products_SelectByPrimaryKey
-- Purpose: Get an existing row in table Products
-- Parameters:
USE Northwind
-- First delete the stored procedure if it already exists.
If (EXISTS (SELECT * FROM dbo.sysobjects
WHERE (Name = 'usp_Products_SelectByPrimaryKey') AND (Type = 'P')))
DROP PROCEDURE usp_Products_SelectByPrimaryKey
GO
-- This stored procedure was created
-- on Saturday, December 02, 2006 at 10:33:54 PM.
-- Template: Retrieve Row by Primary Key
-- Purpose: Get an existing row in table Products
CREATE PROCEDURE usp_Products_SelectByPrimaryKey
(
@ProductID int
)
AS
SELECT
[Products].[ProductID] as ProductID,
[Products].[ProductName] as ProductName,
[Products].[SupplierID] as SupplierID,
[Products].[CategoryID] as CategoryID,
[Products].[QuantityPerUnit] as QuantityPerUnit,
[Products].[UnitPrice] as UnitPrice,
[Products].[UnitsInStock] as UnitsInStock,
[Products].[UnitsOnOrder] as UnitsOnOrder,
[Products].[ReorderLevel] as ReorderLevel,
[Products].[Discontinued] as Discontinued FROM [Products] LEFT OUTER JOIN
Categories AS T0 ON T0.[CategoryID] = [Products].[CategoryID] LEFT OUTER JOIN
Suppliers AS T1 ON T1.[SupplierID] = [Products].[SupplierID]
WHERE
(
[Products].[ProductID] = @ProductID
)
GO
-- End Procedure
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.
A list of licenses authors might use can be found here
Danilo is the creator of
SmartRules, a Business Rules Engine. He is an industry consultant working primarily with companies interested in implementing dynamic rules programming concepts to add flexibility to their architectures on web, CE, and desktop platforms. He operates his own website,
Kontac, where you will find more information.
To contact Danilo, email him at danilo.mendez@gmail.com.