Viewing 15 posts - 2,746 through 2,760 (of 2,766 total)
if you want to upgrade your MCAD remember to take the two exam upgrade because the one exam upgrade comes with more than 90 percent fail rate.
Yikes!!! That's good...
December 16, 2009 at 12:22 pm
I just remembered something . . .
VARCHAR(MAX) is equivalent to the TEXT type in SQL Server. You should change the column type to TEXT. However, Microsoft is depreciating...
December 16, 2009 at 11:54 am
No. What I'm saying is change the destination to VARCHAR(MAX). That would make the column large enough to be handle variable-length character data to whatever the upper limit...
December 16, 2009 at 11:51 am
One other thought (speaking of stray characters): data cleansing is always a good thing. For example, since you're importing from Excel, it's probably using the TAB character as a...
December 16, 2009 at 9:49 am
Sheez . . . that's quite the variety of data.
Here's how I'd tackle it . . .
For the first column, make it a VARCHAR(MAX) column (equivalent to TEXT, which...
December 16, 2009 at 9:44 am
If I'm not mistaken, I believe VARCHAR(MAX) is actually equivalent to the TEXT field type. My understanding is that Microsoft will be phasing out TEXT and replace it with...
December 16, 2009 at 8:26 am
I had a similar problem. In regard to the truncation errors, what I initially did was create a staging table and set all my character fields to TEXT. ...
December 16, 2009 at 8:12 am
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab1
Maybe I should try poking around Microsoft's site a bit more! 🙂
Nevertheless, your thoughts are still welcome!
December 15, 2009 at 12:10 pm
YO!!!
Just came across this thread!!!
Pianist, clarinetist, and songwriter here!!!
December 15, 2009 at 11:14 am
I haven't taken the time to dissect your code, but I did want to write my thoughts when it came to attacking set-based vs. structured programming.
Most traditional structured languages are...
December 11, 2009 at 11:09 am
For what it's worth, I come from a structured programming and OOP background myself (mostly VB, VB.NET, ASP.NET, etc.).
But when it comes to SQL and set-based programming, I take a...
December 11, 2009 at 7:35 am
You don't give very much information to work with. What do the queries look like? And how big are the data sources?
Give us some detail, and we might...
December 10, 2009 at 2:40 pm
I found this article profound to the point that I forwarded it to my wife.
Going the extra mile will only help you out in the long run.
December 10, 2009 at 7:32 am
Great article. I've long argued that "if you want to get anywhere in life, you have to step out of your comfort zone."
December 10, 2009 at 7:30 am
This is painful to read. Can you post an example (a small sample should suffice) of what the output should look like? You'll probably get more responses that...
December 9, 2009 at 8:07 am
Viewing 15 posts - 2,746 through 2,760 (of 2,766 total)