HI, while inserting , pass that 10 columns with null values
insert into emp ( empid , empname ) values ( null , null) or you also declare a input parameter and pass it while inserting into table. @empname VARCHAR(20) = null; insert into emp ( empname ) values ( @empname) -- Srihari On Thu, Mar 18, 2010 at 2:43 PM, Jamie Fraser <[email protected]>wrote: > Care to post a sample of your Stored Procedure? > > Or post the whole thing on pastebin.com > > On Wed, Mar 17, 2010 at 10:17 AM, Vaibhav Goel <[email protected]> > wrote: > > Dear All, > > First of all thanks to support to this group.I am facing a problem > > Since last few days. > > Actually i am using Sql server Database which is located at different > > system. I remotely access this Database Server. > > I have one table in my database.This table contain around 60 fileds. and > i > > wrote a Stored procedure to update 50 columns of this tables. Other 10 > > fields can have null values. > > But what happened,when i execute this procedure it update 50 columns with > > defined values as well as it update all other 10 fields with some garbage > > values. in some fields, it update with greek fields like it use some > symbols > > like arrow or science symbol 'miyu'. > > can anybody have any idea why it is happening?? > > > > > > Pls Help me. > > > > Thanks in Advance > > > > Regards > > Vaibhav Goel > > [email protected] > > >
