全部博文(69)
发布时间:2014-11-08 09:19:05
Connecting to SQL Server Analysis Services from a remote domain / loginWhen connecting to SSAS from a different remote domain / login using Excel 2010 where you have set up a windows user.........【阅读全文】
发布时间:2014-10-18 13:40:00
在用SQL Server导入Excel数据时出现:The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)错误.The method to solve this problem:download AccessDatabaseEngine.exe from Microsoft website: http://www.microsoft.com/en-us/download/confirmation.a.........【阅读全文】
发布时间:2014-10-11 06:33:47
What is the difference between Ojbect_ID() and DB_ID()?......【阅读全文】
发布时间:2014-09-24 11:18:45
A Foreach Loop Container will execute once for each item in the collection of items that it is looking at. A For Loop Container will execute the tasks a specified number of times, in other words 10 times, or 25 times, and the number of times is specified in the definition of the con.........【阅读全文】
发布时间:2014-09-03 15:33:27
Before it was diffcult for me to understand the sequence object in RDBMS. By now, after trying to deduping a table. I use it, and found it is usefull.--- create a sequence --create sequence seq1start with 1increment by 1minvalue 1go-- add an empty column to a table --alter table.........【阅读全文】