全部博文(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'.........【阅读全文】