Viewing 15 posts - 2,746 through 2,760 (of 2,769 total)
One of us usually ends up sleeping on the couch! 🙂
December 16, 2009 at 2:18 pm
CirquedeSQLeil (12/16/2009)
Now we need a database like that for basketball.
I'd be surprised if there isn't one out there somewhere. I actually found the baseball database by doing a Google...
December 16, 2009 at 2:09 pm
Yeah, lifelong upstate New Yorker here.
It also occurred to me that maybe this thread does have something to do with SQL. One of the things I've been doing with...
December 16, 2009 at 1:25 pm
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
Viewing 15 posts - 2,746 through 2,760 (of 2,769 total)