摘要:
USE AdventureWorks2008R2;GOCREATE PROCEDURE dbo.InsertUnitMeasure @UnitMeasureCode nchar(3), @Name nvarchar(25)AS BEGIN SET NOCOUNT ON;-- Update the row if it exists. UPDATE Production.UnitMeasure SET Name = @Name WHERE UnitMeasureCode = @UnitMeasureCode-- Insert the row if the UPDATE statement fail 阅读全文