A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SSRS report parameters set after publishing to report manager||1||72|
|Grid querry results||41||82|
|MS SQLK Server multi-part identifier cannot be bound||5||46|
|SQL Need to calculate age from DOB, no stored procedures or functions allowed||10||52|