Set the default value constain to the 10 columns with default value as null.
On Thu, Mar 18, 2010 at 12:26 AM, Krishna <[email protected]> wrote: > can u post the stored procedure script > > > On Thu, Mar 18, 2010 at 10:42 AM, Processor Devil < > [email protected]> wrote: > >> keyboard/chair problem? >> >> 2010/3/17 Vaibhav Goel <[email protected]> >> >>> 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.
