Hello,
I need the Right Syntax of this Staement
IF(select count(*) from Department where Department_Id=@.De_Id)=0
begin
insert into Depatment vaule.....etc
esle
update
end
just i have problem with the syntax of first If StatementSomething like this would be a bit more efficient.
Searching stops when the first row is encountered, whereas SELECT count(*) has to search the entire filtered set.
Also, 'IF' does not require an 'END' as in Visual Basic.
Code Snippet
IF EXISTS
( SELECT 1
FROM Department
WHERE Department_ID = @.De_ID
)
INSERT INTO Department ( Columns )
VALUES ( @.Values )
ELSE
UPDATE Department
SET
Column1 = @.Value1,
etc.
|||For anyone who is currently doing the first touch to the new version of SQL Server 2008, you should try the MERGE statement (aka UPSERT) which was requested for many of the previous version and is finally implemented.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
