|
imranabdulaziz
Yak Posting Veteran
83 Posts |
 Posted - 2007-07-07 : 02:03:18
|
| Dear All,I am using sql2005.i am writing stored procedure to save various master data . I recognize master by @type (input verible) and assign it to @mst veriable then based on @mst no I perform saving task . I created sp . now I am trying to execute then I am getting error “Invalid object name 'SizeMst'. “ I am running this query from its database.Stored perocedure is Alter procedure [dbo].[Sp_RestMst_Save]@type int ,@id varchar(20),@shortdesp varchar(50),@longdesp varchar(100),@userid varchar(50),@ipadd varchar(50)as declare @mst intset @mst = @typeif ( @mst = 1) begin ;-- saving data in sizemstupdate SizeMst set sshortdesp = @shortdesp , sdesp = @longdesp,smodifiedby = @userid , smodifieddt = getdate() ,ipadd = @ipadd where sizeid = @id;if(@@rowcount = 0)insert into SizeMst(sizeid,sshortdesp,sdesp,screatedby,screateddt,ipadd) values(@id,@shortdesp,@longdesp,@userid, getdate(),@ipadd);end ;elseif(@mst = 2) begin ;-- saving data in brandMstupdate BrandMst set bshortdesp = @shortdesp ,bdesp = @longdesp, bmodifiedby = @userid , bmodifieddt = getdate() ,ipadd = @ipadd where brandid = @id;if(@@rowcount = 0)insert into brandMst(brandid,bshortdesp,bdesp,bcreatedby,bcreateddt,ipadd) values(@id,@shortdesp,@longdesp,@userid, getdate(),@ipadd);end ;elseif(@mst = 3) begin ;-- saving data in metalktmstupdate MetalKtMst set mshortdesp = @shortdesp ,mdesp = @longdesp, mmodifiedby = @userid , mmodifieddt = getdate() ,ipadd = @ipadd where metalktid = @id;if(@@rowcount = 0)insert into MetalKtMst(metalktid,mshortdesp,mdesp,mcreatedby,mcreateddt,ipadd) values(@id,@shortdesp,@longdesp,@userid, getdate(),@ipadd);end ; Please guide me in doing so or give me some useful link.Thanks regardsimran khan |
|
getting error "“Invalid object name 'SizeMst'. “ "