Viewing 15 posts - 1 through 15 (of 520 total)
This is a really good one.
I wish it is true because MySQL's programming capability is far behind SQL Server T-SQL.
Is the Apr.1 joke becoming our wish list? The classic...
April 1, 2016 at 7:08 am
Nice trick Mark.
September 26, 2012 at 8:00 pm
Great idea, Steve. I hope MS can adjust its license policy to what you described.
October 18, 2011 at 8:10 am
I am afraid sheet name is a necessary. It is equivalent to table name.
By default, Excel put Sheet 1, Sheet 2, ... as sheet name. In office 10, it does...
February 8, 2011 at 7:01 am
I would say catalouge views and DMVs added in 2005. Those really changed the ways that DBAs get meta-data and troubleshoot problems. But DMVs are still not widely adopted. They...
December 17, 2010 at 6:25 am
Step 5 means copy the t-log generated on primary to secondary while you were upgrading the secondary to 2008, and restore it on the secodnary with no-recovery.
June 29, 2010 at 7:22 am
When we talk about the time format (UTC or local), we need to think about it in the scope of whole application, not just storage. UTC is clean for storage...
March 2, 2010 at 9:45 am
The SP is a generic tool to import xml spreadsheet. After data is imported, you can apply any logic and processing to the data within your table. As that said,...
February 24, 2010 at 3:15 pm
In your case, it's better to pre-create your table with all necessary columns, allow null for those columns that do not exist in the worksheet. Then call the SP to...
February 24, 2010 at 11:52 am
I used xquery orignally and changed to use OPENXML and PIVOT due to the following two issues:
1) It was slow for big xml;
2) If any cell in the spreadsheet does...
February 23, 2010 at 1:22 pm
Please use the link in the "Resource" section at end of the article.
February 23, 2010 at 1:19 pm
I tried on an excel with 274 columns, it worked fine.
I did test the scenarios when I gave you the necessary changes in the previous posts. I tested again today,...
February 23, 2010 at 7:07 am
Both are yes.
Since those 37 columns are nullable, the SP should ignore them. So I think you found a bug. Thanks.
The fix is pretty simple. You can find the...
February 19, 2010 at 8:35 am
JGay 2041 (2/19/2010)
1 - running debug. In debug SQL is one line, I split here for readability
February 19, 2010 at 8:24 am
I am sure what caused the error, maybe duplicated columns (headers) in the spreadsheet. Can you run the SP in debug mode and check the output?
February 19, 2010 at 6:45 am