Re: Update string too long?
From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 02/15/05
- Next message: Andrew J. Kelly: "Re: Comments in SP"
- Previous message: Gerard: "Linked Server - Query"
- In reply to: Vinod Kumar: "Re: Update string too long?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 08:25:45 -0500
If you don't realize, there is a groups.google.com that you can use to
search through the newsgroups, as wells as google.com for the web. I find a
lot of folks don't realize about searching through groups, even a really
good programmer that started with us recently.
-- ---------------------------------------------------------------------------- Louis Davidson - drsql@hotmail.com SQL Server MVP Compass Technology Management - www.compass.net Pro SQL Server 2000 Database Design - http://www.apress.com/book/bookDisplay.html?bID=266 Blog - http://spaces.msn.com/members/drsql/ Note: Please reply to the newsgroups only unless you are interested in consulting services. All other replies may be ignored :) "Vinod Kumar" <vinodk_sct@NO_SPAM_hotmail.com> wrote in message news:cushv5$hsb$1@news01.intel.com... >> something like that. Beginner posts are the most helpful and it is >> distracting to read thru the slams. Surely you SQL Gods had to learn >> somewhere :) > > Dont be so harsh on yourself ... This "is" and "should be" the one stop > for > your SQL Server queries and these message boards are quite useful to get > problems solved and learn more ... Having said that, there are sometimes > queries that on a basic search on BOL might have the answers. That is when > such replies are got ... But I surely want to encourage people with > problems > on SQL Server to post it here rather than thinking if it were basic or > complex ... Do a basic google and search the BOL for answers, else you > know > we are there to help you ... > > -- > HTH, > Vinod Kumar > MCSE, DBA, MCAD, MCSD > http://www.extremeexperts.com > > Books Online for SQL Server SP3 at > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp > > "Sue" <Sue@discussions.microsoft.com> wrote in message > news:D45F493E-8BD4-4910-86FD-E60A913C50CC@microsoft.com... >> > To prevent this add an ISNULL() function around each column and set the >> > second parameter to '' (quote-quote). >> >> Perfect! This is exactly what was happening and your solution solved it > for >> me. Thank you VERY much! I wish I had posted before spending 4 hours > trying >> on my own! >> >> > BTW, what is the data type and length for the >> > dbo.MSP_TASKS.EXT_EDIT_REF_DATA column you are inserting into? Can it >> > support the full length of the inserted data? >> >> The data type for MSP_TASKS.EXT_EDIT_REF_DATA is Text 16. The tables I >> am >> working with are those that support Microsoft Project, so all data types > and >> column/field sized are defined for me. The update I am doing is required >> prior to doing an update on other fields. I was comfortable that the > field >> size could handle it because I have been doing this same thing >> programatically for some time. >> >> Oh... and my comment was because I have seen many posts by obvious > beginners >> (myself included) where the response was "if you had read... " or "you > must >> not know what you are talking about or you would know it is called a... " > or >> something like that. Beginner posts are the most helpful and it is >> distracting to read thru the slams. Surely you SQL Gods had to learn >> somewhere :) >> >> "David Gugick" wrote: >> >> > > >> > > Sorry if this question is so simple that I should have been able to >> > > find the solution elsewhere. Also if I didnt use the terminology >> > > correctly. I am only trying to get this resolved, not to be judged >> > > for what I don't know yet. This board/newsgroup/discussion group is a >> > > bit intimidating. >> > >> > We are all sweet. >> > >> > If any of those columns have a NULL value when concatenating, you'll >> > get >> > NULL in the final column. >> > >> > Select 'n' + 'u' + 'l' + null -- This returns NULL >> > >> > To prevent this add an ISNULL() function around each column and set the >> > second parameter to '' (quote-quote). >> > >> > BTW, what is the data type and length for the >> > dbo.MSP_TASKS.EXT_EDIT_REF_DATA column you are inserting into? Can it >> > support the full length of the inserted data? >> > >> > And we won't question to reason for this routine as you asked... >> > >> > -- >> > David Gugick >> > Imceda Software >> > www.imceda.com >> > > >
- Next message: Andrew J. Kelly: "Re: Comments in SP"
- Previous message: Gerard: "Linked Server - Query"
- In reply to: Vinod Kumar: "Re: Update string too long?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
