CREATE PROCEDURE [dbo].[PorcedureName]
-- Add the parameters for the stored procedure here
@ColumName1 type,
@ColumName2 type,
@ColumName3 type,
@ColumName4 type
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
DECLARE @X_ColumName1 type,
DECLARE @X_ColumName2 type,
DECLARE @X_ColumName3 type,
DECLARE @X_ColumName4 type
SELECT @X_ColumName1=ColumName1
@X_ColumName2=ColumName2
@@X_ColumName3=ColumName3
@X_ColumName4=ColumName4
FROM [dbo].[TableName1]
WHERE ColumName1= @ColumName1-----search the result by primary key
IF @@ROWCOUNT = 1 --update
BEGIN
SELECT @X_ColumName1=ISNULL(@ColumName1,@X_ColumName1)
SELECT @X_ColumName2=ISNULL(@ColumName2,@X_ColumName2)
SELECT @X_ColumName3=ISNULL(@ColumName3,@X_ColumName3)
SELECT @X_ColumName4=ISNULL(@ColumName4,@X_ColumName4)
EXEC [dbo].[ProcedureName2(update)]---
@X_ColumName1=ColumName1,@X_ColumName2=ColumName2,@X_ColumName3=ColumName3,@X_ColumName4=ColumName4
---OR other update sql
END
ELSE--Insert
BEGIN
EXEC [dbo].[ProcedureName3(insert)] @X_ColumName1=ColumName1,@X_ColumName2=ColumName2,@X_ColumName3=ColumName3,@X_ColumName4=ColumName4 END
--Or other insert sql
END