Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
CREATE PROCEDURE usp_INSERTUPDATEEMP ( @EmpID AS INT, @LastName AS NVARCHAR(20), @FirstName AS NVARCHAR(20) ) AS BEGIN IF EXISTS (SELECT EmployeeID FROM Employees WHERE EmployeeID = @EmpID) BEGIN -- Write your update query UPDATE Employees SET FirstName = @FirstName, LastName = @LastName WHERE EmployeeID = @EmpID END ELSE BEGIN -- Write your insert query INSERT INTO Employees (EmployeeID, FirstName, LastName) VALUES ( @EmpID, @FirstName, @LastName ) END END
|error during execute sql task execution, but only at times...||12||81|
|Pivot Query Problem||9||30|
|How to order Highest and lowest value rows alternatively in SQL Server ?||4||24|
|How to simplify my SQL statement?||9||10|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!