I think it's the best solution too srihari! Regards Bruno Soares.
On Thu, Mar 18, 2010 at 10:17 AM, srihari k <[email protected]> wrote: > 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] >> > >> > > To unsubscribe from this group, send email to dotnetdevelopment+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
