摘要： ODataQueryExpressionFetchXmlLINQFilteredViewsPerforming Create, Update or Delete functionX X Retrieve record valuesXXXXXCan be used in report writing X XRetrievin... 阅读全文

摘要： 1. Subquery Any Syntax: -- any-- remove inner order byselect EnglishProductName, ListPrice from DimProductwhere ListPrice > any(select avg(ListPrice) from DimProductgroup by ProductSubcategoryKey... 阅读全文

摘要： 1. Union Syntax: -- union 10 recordsselect * from Table1unionselect * from Table2--select EnglishProductName from Table1unionselect EnglishProductName from Table2Analysis:You can union more than ... 阅读全文

摘要： 1. Local temporary table Syntax: -- local temporaryselect EnglishProductName, ListPrice - DealerPrice as Discount into #NewDimProductfrom DimProductwhere ListPrice - DealerPrice is not nullorder ... 阅读全文

摘要： SELECT DB_NAME(dbid) as DBName, loginame as LoginName, * FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame ; 阅读全文

摘要： ALTER DATABASE OKQ8 SET SINGLE_USER WITH ROLLBACK IMMEDIATE--AFTER 60 SECONDSALTER DATABASE OKQ8 SET ENABLE_BROKER --DISABLE_BROKER WITH NO_WAIT--do you stuff hereALTER DATABASE OKQ8 SET MULTI_USER... 阅读全文

摘要： 1. Through Command Prompt: msdtc –uninstall msdtc –install Reference: On each server, do the following: From Ser... 阅读全文

摘要： Use this command script: net use r: https://some.portal.org/documents [password] user:domainName\[username]copy c:\somefile.txt r:\somefile.txt 阅读全文

摘要： I got two options to create directory in the remote server by executing T-SQL: 1. xp_cmdshell EXECUTE master..xp_cmdshell N'md "c:\db\backup"' --Or you can create a bat to wrap multiple script... 阅读全文

摘要： 返回去掉了前导、尾随和重复的空白的参数字符串 string normalize-space(string) 通过去掉前导和尾随空白并使用单个空格替换一系列空白字符，使空白标准化。如果省略了该参数，上下文节点的字符串值将标准化并返回。 以下函数调用返回“abc def”： normalize-space(" abc def ") 如果参数不是字符串类型，将先使用 str... 阅读全文