I realise this is pretty old but I wrote this, works with 2008r2+

https://the.agilesql.club/blogs/Ed-Elliott/2016-04-08/SQLCover-Code-Coverage-For-SQL-Server-T-SQL

and this explains what code coverage is:

https://the.agilesql.club/blogs/Ed-Elliott/2016-04-11/what-is-code-coverage-in-sql-server-t-sql

ed

GilaMonster (12/10/2015)

---

No, we're not. We don't have the rigour, the formality, the adherence to standards that characterises engineering disciplines. The scientific method is not 'try stuff at random until something...

No we are not engineers also data scientists are not scientists if you look at the definition of a scientist 🙂

sqldoubleg (11/17/2015)

---

Joe Garrick (11/17/2015)

---

DROP and CREATE for an object works great until you run into one that has any kind of security assigned. If you drop and create, rights granted...

Martin Fowler is pretty clear that refactoring means looking for and cleaning substandard code for example:

http://martinfowler.com/articles/workflowsOfRefactoring/#opp-flow

Jeff Moden (11/11/2015)

---

I love refactoring because we can indeed get rid of a huge amount of technical debt, improve performance and scalability of the code, simplify by removed gobs of...

Write unit tests and so...

I guess that is another reason to...

sknox (10/5/2015)

---

if 1 = 0

...

nfink (10/5/2015)

---

I fully support VCS and in my development environment the db portion is the most lacking in this area. 🙂 I appreciate the different perspectives the author has provided...

JustMarie (10/5/2015)

---

Taking out the name and parameters makes sense. Those are already in the code.

I don't agree with taking out the descriptive parts because stored procedures can and will...

Jeff Moden (10/5/2015)

---

[font="Arial Black"]From the Article:[/font]

---

So if we take out the code that has been commented out by not being reachable we end up with:

create procedure usp_DoSomething (@PARAMETER int)

as

...

Jambu Krishnamurthy (9/16/2015)

---

Hi,

That was a great article. I have been doing many home-grown-solutions at various placed I had worked for almost 10 years to get SQL Server objects into source...

JohnJack (9/15/2015)

---

We have struggled with this for a few years now.

We tested out RedGate Source Control with SVN (Subversion) on a few projects and found that we had a few...

GShenanigan (9/15/2015)

---

Thanks Ed.

I've been intrigued by the Redgate test data generation (whether I can get budget for it is another thing :-P) but I'm curious as to how configurable it...