distal-attribute
distal-attribute
distal-attribute
distal-attribute

SQL newbie - Store data in database through SP.

RobbDaRobb posted 2 weeks ago in General

Hi,

I created a querry - It works..

INSERT INTO dbo.General(Tracking_ID,BU_unit,Supplier,Customs_status) Values('hello','world','it','is me') Select * From dbo.General

MY question is how do I change this to a Storedprocedure and be able to save it.

Thank you very much.

BubikolRamios posted 2 weeks ago

left click on db - create new stored proc ...

RobbDaRobb posted 2 weeks ago

BEGIN SET NOCOUNT ON SET ANSI_WARNINGS OFF INSERT INTO dbo.General(Tracking_ID,BU_unit,Supplier,Customs_status) Values('hello','world','it','is me') Select * From dbo.General END

I added nocound and ansi_warning, either way if it is there or not i receive the error. Operation is not allowed when the object is closed

Please login to leave a reply, or register at first.