Julian Date YYYYDDD to Gregorian Date - social.msdn.microsoft.com
Oct 8, 2015 · To implement logic, either add 2 days to T-SQL logic or explicitly pass 1 Jan 1900 as start date instead of integer value 0 in SSIS to get the same behavior as in T-SQL.
Error 0xc001f205 trying to import .accdb into database
Oct 19, 2014 · Question 0 Sign in to vote All, been trying to import a .accdb file into MS SQL 2008 and I get the following error
regular expressions in transact sql - social.msdn.microsoft.com
Aug 28, 2009 · i need some help tp write code in order to search the string ( regular expressions) in t- sql.
Convert Binary to Ascii - social.msdn.microsoft.com
Dec 12, 2006 · In this case set the field to have a data source of a T-SQL statement. In that statement, perform a select of the field you're interested in, but apply the CONVERT () or …
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 …
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 …
delete local subscription with T-SQL - social.msdn.microsoft.com
Jun 20, 2011 · I need novice-level steps to use t-sql to delete a local Subscription, which in not displayed in the Mgmt Studio (SLQ 2005). I believe the subscription exists because I tried to …
SQL whitespace sensitive? - social.msdn.microsoft.com
Is T-SQL supposed to be whitespace sensitive? The following SQL when run in SQL 2008 Management Studio produces two errors unless I put the "GO" on its own line. I even tried …
how to disconnect and clear the user in sys.sysprocesses?
Mar 9, 2012 · Question 0 Sign in to vote SELECT db_name (dbid) as DatabaseName, count (dbid) as NoOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > …
Restoring Database from Azure Blob Storage failing from SSMS …
Apr 7, 2018 · Your T-SQL statement doesn’t seem right to me, and I cannot make it work. Am I missing something? The statement below works for me (with SQL Server 2016):