When I export a table to Excel file, upon import twin sheets being offered (SheetName, SheetName$). It appears that both have the same data, and can be imported into two different tables.
It is descr…
Created on 3/20/2013 (updated 8 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 781734
|
|
Here is the error with time data type:
SELECT * FROM [GAMMA_AZURE].AdventureWorks2012.HumanResources.Shift;
/*
Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' for linked server 'GAMMA_A…
Created on 2/27/2013 (updated 3 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 780161
|
|
|
Closed
as Won't Fix
|
|
Here is the description:
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/bb149610-76b2-4e9e-a4b5-bb76dc152845
Created on 11/16/2012 (updated 24 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 771374
|
|
Here is the image of the dialog box with bottom cutoff:
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/e1798e87-6f6a-4726-8786-c10bb64beef9
Created on 11/15/2012 (updated 13 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 771199
|
|
The new system functions, CONCAT, FORMAT, PARSE, TRY_PARSE, TRY_CONVERT, DATEFROMPARTS, DATETIMEFROMPARTS, CHOOSE, EOMONTH and so on are not listed in SSMS Object Explorer among the other system funct…
Created on 8/20/2012 (updated 3 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 758807
|
|
The following statement fails:
SELECT concat(N'Sales.', objname) AS TableName, *
FROM fn_listextendedproperty (NULL, 'schema', 'Sales', 'table', default, NULL, NULL)
ORDER BY TableName;
/*
Msg …
Created on 7/23/2012 (updated 5 days ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 755202
|
|