全部博文(69)
发布时间:2014-12-15 17:26:02
/*There is a column with data like 'plase20080412OK', 'jdjldk19351123', please write a query to get the Date value.*/Create table #GetDateStr (String1 varchar(50))insert into #GetDateStr values ('please20080412ok'), ('Jane19880416Hi'), ('euout19950612dk');/*The subquery is used to trim th.........【阅读全文】
发布时间:2014-12-13 15:08:18
Today, I delete some rows from a table accidentally, and the worst is that I didn't backup any databases including log. Fortunately, I found a original copy in another sql server, so I added the server link to get the rows back.IF EXISTS(SELECT * FROM sys.servers WHERE name = N'.........【阅读全文】
发布时间:2014-11-22 04:18:30
Recently, migrated all data from Lotus Domino to SQL server. Steps: writing a LotusScript Agent export all data to a csv flat file. As the the large and long time data are complicate, I have to export the data by year to make the errors figured out easily.%REMSub InitializeDes.........【阅读全文】
发布时间:2014-11-12 03:28:51
During Learning of MSBI Stack: SSIS, SSAS, SSRS, I got a lot from the following sharing:1. BIWORK -- http://www.cnblogs.com/biwork/from http://www.cnblogs.com/Summarized very well, I really understood SSAS from here.2. 专注微软平台的商业智能解决方案http.........【阅读全文】
发布时间: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.........【阅读全文】