This usually does the trick, placed at the top of a test script:

-- OPEN trans?

WHILE @@trancount > 0 COMMIT TRAN

GO

What is your specific question? You can edit the proc and add another parameter (with a default value) if you want it to be backward compatible.

I suspect you had a nested transaction. If you tried to test the script by stopping it, you may have created a nested transaction the second time you ran...

I have a C# cert and haven't touched the language in seven years. CLR functions for sql server are few and far between with no demand.

My recommendation would be...

ScottPletcher (4/23/2015)

---

Stripping out delimiters should never eliminate information from the data. If you need to, you can set a tinyint code that reflects the meaning of the delimiters. ...

mistylove98 (4/23/2015)

---

I am working on a delete statement that has 2 separate conditions. I have to delete from my orders table orders with a date within the range of 10-10-1996...

I think we all struggle because there is no good answer to this problem.

There are three types of formats for data that serve different purposes:

Storage - using the built-in data...

Technically everything is stored as bits and bytes. Number storage is quite dense (efficient). I would expect credit card numbers to be stored in an encrypted varbinary column....

I had to read this to understand what a DevOp is:

http://en.wikipedia.org/wiki/DevOps

I've consulted at many corporate headquarters and found most of their databases designed at a kindergarten quality level. The...

You can't do SET-wise operations because theoretically SETs do not allow duplicates - duplicates will be ambiguous. Assuming your table is a HEAP, you must cursor through the rows...

declare

@StartDate date = '2015-01-01',

@EndDate date = '2015-01-05'

;

SELECT dateadd(DAY, x.rn, @StartDate)

FROM

( SELECT (ROW_NUMBER() OVER(ORDER by object_id))-1 AS rn FROM sys.objects) AS x

WHERE

x.rn <= DATEDIFF(DAY,@StartDate,@enddate )

;

Itzik Ben-Gan saves the day once again!

I was bothered that the join clause for the right table of a left outer join was being ignored. Little did I know...

There...

Restoring your backup of "MyDatabase" will create a new database called "MyDatabaseCopy" with different file names if you follow the script below. You may need to highlight and execute...

The essence of the article, to me, seems to be about the power struggle between a DBA and Developer that happens every time a change is requested. I want...

SELECT crdate, DATEDIFF(MINUTE,'19000101', crdate) / 15

FROM sysobjects

ORDER BY DATEDIFF(MINUTE,'19000101', crdate) / 15

WITH x AS

(

SELECT DATEDIFF(MINUTE,'19000101', crdate) / 15 as QuarterHour

FROM sysobjects

)

SELECT QuarterHour, COUNT(*)

FROM x

GROUP by QuarterHour

ORDER by QuarterHour

;