MSSQL Server stored procedure
1 2 3 4 5 6 7 8 9 10 11 12 13 | CREATE PROCEDURE ProductInsert( @ProductName varchar (25), @Price int , @ProductInStock int ) AS IF EXISTS( SELECT * FROM PRODUCTS WHERE ProductName=@ProductName) BEGIN PRINT 'This product already there is ' ; END ELSE BEGIN INSERT INTO PRODUCTS (ProductName,Price,ProductInStock) VALUES (@ProductName,@Price,@ProductInStock) END |