createcurrencysprocs.sql

来自「< SQL Server2005程序设计>」· SQL 代码 · 共 72 行

/*
This script implements the stored procedures created by the TableAdapter 
Wizard in the creation of the Currency DataTable in the AdventureWorks 
typed DataSet (in the Chapter08 Visual Studio sample code project).
You need run this script only if you do not wish to create the DataSet 
manually in its designer
*/

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'uspSelectCurrency' AND user_name(uid) = 'dbo')
	DROP PROCEDURE dbo.uspSelectCurrency
GO

CREATE PROCEDURE dbo.uspSelectCurrency
AS
	SET NOCOUNT ON;
SELECT     CurrencyCode, Name, ModifiedDate
FROM         Sales.Currency
GO

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'uspInsertCurrency' AND user_name(uid) = 'dbo')
	DROP PROCEDURE dbo.uspInsertCurrency
GO

CREATE PROCEDURE dbo.uspInsertCurrency
(
	@CurrencyCode nchar(3),
	@Name Name,
	@ModifiedDate datetime
)
AS
	SET NOCOUNT OFF;
INSERT INTO [Sales].[Currency] ([CurrencyCode], [Name], [ModifiedDate]) VALUES (@CurrencyCode, @Name, @ModifiedDate);
	
SELECT CurrencyCode, Name, ModifiedDate FROM Sales.Currency WHERE (CurrencyCode = @CurrencyCode)
GO

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'uspUpdateCurrency' AND user_name(uid) = 'dbo')
	DROP PROCEDURE dbo.uspUpdateCurrency
GO

CREATE PROCEDURE dbo.uspUpdateCurrency
(
	@CurrencyCode nchar(3),
	@Name Name,
	@ModifiedDate datetime,
	@Original_CurrencyCode nchar(3),
	@Original_Name Name,
	@Original_ModifiedDate datetime
)
AS
	SET NOCOUNT OFF;
UPDATE [Sales].[Currency] SET [CurrencyCode] = @CurrencyCode, [Name] = @Name, [ModifiedDate] = @ModifiedDate WHERE (([CurrencyCode] = @Original_CurrencyCode) AND ([Name] = @Original_Name) AND ([ModifiedDate] = @Original_ModifiedDate));
	
SELECT CurrencyCode, Name, ModifiedDate FROM Sales.Currency WHERE (CurrencyCode = @CurrencyCode)
GO

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'uspDeleteCurrency' AND user_name(uid) = 'dbo')
	DROP PROCEDURE dbo.uspDeleteCurrency
GO

CREATE PROCEDURE dbo.uspDeleteCurrency
(
	@Original_CurrencyCode nchar(3),
	@Original_Name Name,
	@Original_ModifiedDate datetime
)
AS
	SET NOCOUNT OFF;
DELETE FROM [Sales].[Currency] WHERE (([CurrencyCode] = @Original_CurrencyCode) AND ([Name] = @Original_Name) AND ([ModifiedDate] = @Original_ModifiedDate))
GO