SQL - Insert , but if exist replace (Microsoft SQL)

[rover2341]

SQL - Insert , but if exist replace (Microsoft SQL).

Replace into does not work. as it doesn't accept the key word into.

 

[Accname]

Dont know if this will help you but it might be relevant:
http://stackoverflow.com/questions/234/sql-server-2005-implementation-of-mysql-replace-into

http://www.databasejournal.com/feat...p/3759636/SQL-Server-2008-MERGE-Statement.htm

 

[rover2341]

I ended up with this, using a procedure. But in mySQL... it would have quite a bit easier.

USE [DickinsonBrosSQL]
GO
/****** Object:  StoredProcedure [dbo].[UpdateItem]    Script Date: 9/2/2013 9:21:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
ALTER PROCEDURE [dbo].[UpdateItem](@ITEMID AS varchar(50),
                                  @USERID AS varchar(50),
                                  @ITEMFILE AS text,
                                  @GAME AS varchar(50),
                                  @GAMETYPE AS varchar(50),
                                  @TITLE AS varchar(50),
                                  @DESCRIPTION AS varchar(500),
                                  @ENABLED AS tinyint)
                                 
AS
 
BEGIN
 
   
 
    IF  ((select top 1 ITEMID from Item where ITEMID = @ITEMID) is null)
        BEGIN
 
            INSERT INTO 
                [Item]([ITEMID],
                      [USERID],
                      [ITEMFILE],
                      [GAME],
                      [GAMETYPE],
                      [TITLE],
                      [DESCRIPTION],
                      [CREATED],
                      [ENABLED])
                VALUES(@ITEMID, @USERID, @ITEMFILE, @GAME, @GAMETYPE, @TITLE, @DESCRIPTION, GETDATE(), @ENABLED)   
                   
        END
 
    Else
        BEGIN
 
        UPDATE  [Item]
        SET    [ITEMID] = @ITEMID,
                [USERID] = @USERID,
                [ITEMFILE] = @ITEMFILE,
                [GAME] = @GAME,
                [GAMETYPE] = @GAMETYPE,
                [TITLE] = @TITLE,
                [DESCRIPTION] = @DESCRIPTION,
                [EDITED] = GETDATE(),
                [ENABLED] = @ENABLED
        where @ITEMID = ITEMID
 
        END
 
END