Hi, You said ,you were performing UPDATE not INSERT.While Inserting the records what was the value in the 10 columns?
The 10 clumn's values changing after UPDATE operation,right?Then using SQL profiler, you can confirm it when the updation is happening for 10 columns.OR If you are using TFS, it is possible to debug ur procedure line by line like debugging your C# code. I dont think so, we have to specify the remaining 10 cloumns and pass Null values to it. Thanks On Thu, Mar 18, 2010 at 2:23 PM, Atul Atey <[email protected]> wrote: > 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. > -- "People who never make mistakes, never do anything." dEv To unsubscribe from this group, send email to dotnetdevelopment+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
