Microsoft Query cannot run SQL code with a T-SQL variables in it?
Oct 17, 2011 · I am unable to use Microsoft Query to return data from a query that includes T-SQL variables. The weird thing is that Microsoft Query handles the data fine, but then has a problem …
SQL Job Agent Error: The insert column list used in the MERGE …
Nov 9, 2018 · You've not included the column in the MERGE statement at all It seems the column Job_Number is NOT NULL able column so you need to pass atleast a default value for it to avoid the …
T-SQL equivalent of Guid.Empty - social.msdn.microsoft.com
Oct 7, 2021 · Your question was "what is the T-SQL equivalent of Guid.Empty". I added it using C# in order to find out, by doing what the T-SQL equivalent is. And it turned to be the intuitive answer: a …
TSQL Statement for Bulk Export Data? - social.msdn.microsoft.com
Feb 15, 2016 · Is there a TSQL statement that will export table data in bulk. I know “BULK INSERT”, but that can only be used to bulk import data, not export. And bcp utility can do the export, but it is …
Question on restoring encrypted databases on different servers
Jul 12, 2007 · I have run into problems trying to use backed-up encrypted databases. I have an ASP.Net/SqlServer 2005 website for which I have production, test, and development environments, …
FetchXML filter - social.msdn.microsoft.com
Feb 8, 2011 · I am trying to build a filter in a FetchXML statement to do the following (using T-SQL syntax): where (gradefilter = 0) or (minimumgrade >= 1 and maximumgrade <=12)
Looping through files in a directory - social.msdn.microsoft.com
Aug 20, 2009 · I'm trying to loop through several thousand picture files in a directory to insert them into sql. My question is, how do I get the names of all files in a directory and go through them one by one?
Running PL/SQL Syntax on Microsoft SQL Server 2008
Jan 20, 2011 · Generally the majority of statements are the same e.g. (IF, THEN, WHERE). However, I'm specifically having problems with JOINS in T-SQL. Is it possible to introduce new functions to …
Load complex XML files into SQL Tables - social.msdn.microsoft.com
Jan 25, 2018 · I have requirement to load complex XML file into SQL tables using SSIS. When I added XML source in Data flow Task which show me multiple outputs, it seems not correct, Please suggest …
Impersonate dbo user - social.msdn.microsoft.com
Apr 21, 2017 · I currently have a trigger that audit ADD, UPDATE and DELETE on product table but the audited user is always web_user which is the only user assigned to the database as dbo owner, I …