Viewing 15 posts - 3,241 through 3,255 (of 7,191 total)
If I remember correctly, when data is imported from Excel, it only looks at the first half dozen or so rows in order to determine the width of the columns....
February 4, 2015 at 5:54 am
Sounds like the data in your spreadsheet is too wide to insert into at least one of the columns in your table.
John
February 4, 2015 at 5:33 am
Have you tried what it suggests in the error message?
John
February 4, 2015 at 2:24 am
If you usually only have one file in your folder, you should be able to get its name quite easily using xp_cmdshell, Powershell, or your favourite other scripting tool. ...
January 30, 2015 at 9:51 am
Whether anyone thinks it's arrogant or controlling or what have
I only said it's arrogant to tell someone that you don't know and whose environment and circumstances you don't know that...
January 21, 2015 at 9:49 am
Yes, I'm the DBA here and Hungarian notation does not form part of our standards. But I'm not the DBA everywhere, and I'm not arrogant enough to suggest that...
January 21, 2015 at 8:17 am
I suppose it depends on your data. You'd have to put the columns in questions into separate tables, which would require changes to your database schema and your code....
January 21, 2015 at 2:43 am
Jeff Moden (1/20/2015)
John Mitchell-245523 (1/15/2015)
SQLvis (1/15/2015)
Is there a list of standard object nomenclature for indexes, procedures, functions, and views (etc) that most teams should follow?
Not really. It's more important...
January 21, 2015 at 2:06 am
Do you mean varchar(max) and nvarchar(max) columns? Where did you read that it's best to separate them, and how would you propose to do it?
John
January 20, 2015 at 5:35 am
Those columns don't have maximum lengths. They can be as long as the data in them. Probably best to sum up the lengths for all the columns that...
January 20, 2015 at 5:28 am
No, I mean please show us the actual query you've tried. And if you also supply the table DDL and sample data in the form of CREATE TABLE and...
January 20, 2015 at 5:01 am
The allow updates option doesn't have any effect any more (from SQL Server 2005). You could use a trigger instead of a constraint in order to return the error...
January 20, 2015 at 4:40 am
It's just a simple join you need, isn't it? Please will you show us what you've already tried, so that we can show you where you're going wrong?
John
January 20, 2015 at 4:35 am
You see where it says "Operating system error = 32"? If you don't know what that error code means, go to a command prompt and type [font="Courier New"]net helpmsg...
January 15, 2015 at 7:50 am
SQLvis (1/15/2015)
Is there a list of standard object nomenclature for indexes, procedures, functions, and views (etc) that most teams should follow?
Not really. It's more important to have a convention...
January 15, 2015 at 5:10 am
Viewing 15 posts - 3,241 through 3,255 (of 7,191 total)