if condition problem

Question

5.00/5 (1 vote)

See more:

I want to UPdate my table if some condition Takes place

if not i want to insert to my table

but i have errore in my code for some reason can anybody tell me what is my errore

SQL

ALTER PROC [dbo].[SqldataTable]
@id real,
@prod nvarchar(50),
@category varchar(50),
@price real,
@instock bit,
@count real,
@DateUpdate datetime,
@description nvarchar(max)
 

as
--somthing wrong here!
if  (ID like @id)

begin


UPDATE  [DBT] 
set

ID=@id,
ProductName=@prod,  
Category=@category,
Price=@price,
Instock=@instock,
[Count]=@count,
DateUpdate=@DateUpdate,
[Description]=@description  
  
where ID=@id
 
 
end



else

begin

INSERT INTO [DBT] (ID,ProductName,Category,Price,Instock,[Count],DateUpdate,[Description])
VALUES (@id,@prod,@category,@price,@instock,@count,@DateUpdate,@description)
 
 end

Posted 20-Dec-13 11:24am

Member 10388286

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard C Bishop · Accepted Answer · 2013-12-20T11:29:00

Solution 1

You need to declare ID(it will need to be named something else though) and change that line to this:

DECLARE @secondID varchar(max)

Set @secondID = Select ID FROM table WHERE ID = @id

IF @id = @secondID
   BEGIN
       --your code
END

"ID" will be the id column in your table and "table", of course is the table you are querying.

Posted 20-Dec-13 11:29am

Richard C Bishop

Updated 20-Dec-13 12:11pm

v5

Comments

[no name] 20-Dec-13 17:38pm

but i want to compere the ID column value to the new insert value

Richard C Bishop 20-Dec-13 17:51pm

See my update to the solution.

Mike Meinz · Accepted Answer · 2013-12-20T15:00:00

I do not know why you are trying to compare ID (which is not declared or instantiated) but I assume that you want to do an INSERT if the record with ID = @ID does not exist and an UPDATE if it does exist.

Below is how I would do it. Starting with Microsoft SQL Server 2008, there is a MERGE statement that could be used to cause the same result.

C#

ALTER PROC [dbo].[SqldataTable]
@id real,
@prod nvarchar(50),
@category varchar(50),
@price real,
@instock bit,
@count real,
@DateUpdate datetime,
@description nvarchar(max)
as


if  (select COUNT(*) from [DBT] where ID=@ID) > 0
begin
UPDATE  [DBT] 
set
ProductName=@prod,  
Category=@category,
Price=@price,
Instock=@instock,
[Count]=@count,
DateUpdate=@DateUpdate,
[Description]=@description  
where ID=@id
end
 
else
 
begin
INSERT INTO [DBT] (ID,ProductName,Category,Price,Instock,[Count],DateUpdate,[Description])
VALUES (@id,@prod,@category,@price,@instock,@count,@DateUpdate,@description)
end

if condition problem

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

if condition problem

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us