Missing SQL Collation - social.msdn.microsoft.com
Jul 7, 2015 · If the following statement returns the correct result in query window, please use the T-SQL statement “ALTER DATABASE [DBname] COLLATE Latin1_General_CI_AS” which is mentioned in …
Export a table data to a PDF file - social.msdn.microsoft.com
Dec 8, 2013 · In my R&D, i found some piece of code which will save a single column of the table to PDF format.
ADH Service Status - social.msdn.microsoft.com
How to find out ADH (Active Directory Helper) Service Status by T-SQL Statement My requirement is: ADH Service is installed but not running for this situation i need query
Switch () in MDX - social.msdn.microsoft.com
Dec 12, 2008 · MDX is (trying to be) more like T-SQL, so the name of the command is CASE.
Query Store-Regressed queries - social.msdn.microsoft.com
Jul 23, 2018 · This forum is for users discussing issues involve SharePoint 2013, since the issue is more relative to T-SQL, I would move it to SQL Server > Transact-SQL. The reason why we recommend …
Convert SQL CE to SQL Server - social.msdn.microsoft.com
Oct 15, 2010 · I thought I could use Database Publishing Wizard to generate t-sql that i can run on the server. Visual Studio 08 is supposed to have the wizard integrated but it does not seem it does. I …
Reverse substring - social.msdn.microsoft.com
Aug 12, 2011 · Is there a T-SQL function for "reverse" substring? For example, let´s say I need to fetch the letter A from a code with the format ABC. I would do something like so:
JProCo Database - social.msdn.microsoft.com
Aug 7, 2012 · In the past I have been working with the JProCo database, I am following the book SQL Queries Joe for Pros, but with the new instalation of the SQL Server Management Studio I cannot …
msbi_Dev's Profile - social.msdn.microsoft.com
Replied to a forums thread T-SQL Query help ( From YTD to Actual) in the Transact-SQL Forum.