May 26, 2010 · Note make sure you do not create duplicate stored procedures for example same T-SQL statement can be there in multiple places in your C# code so you use one sp this is …

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.

Sep 13, 2012 · I want to be able to force a restore or a delete on a database even if there still have some active connections. In SQL Server management studio there is a checkbox when …

May 13, 2013 · In SQL Server 2005, how do you disable/enable an Alert using T-SQL? All examples I have found are using SSMS.

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

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 …

Apr 9, 2018 · This is not possible using a normal T-SQL query, unless you do a sub query for each row, and collect the results of the subquery into a format suitable to store those multiple …

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 …

Oct 17, 2019 · for training purposes, I'm collecting a meaning set of best pratices about T-SQL stored procedures.

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 …