SQL Slayer - Group: Administration

mlakarj on Know of any SQL Unit Test technologies?

Fri, 20 Aug 2010 08:35:50 -0700

Question for the SQL Brain Trust:

Does anyone know of a good technology out there for doing SQL Server Unit Tests? Is there anything available in Visual Studio or Data Dude?

Thanks.

-Jeff

SQLGeek on Database Projects in 2008 not scripting header comments of stored procedures anymore??

Mon, 19 Oct 2009 10:16:42 -0700

So while doing some research I came across this. Not exactly what I wanted to see....

http://social.msdn.microsoft.c.....44961aa91b

SQLGeek on Database Projects in 2008 not scripting header comments of stored procedures anymore??

Mon, 19 Oct 2009 09:47:13 -0700

I also think this is a bug. This is affecting me as well as I am now adding all of our intranet databases to TFS. What's the point of having a header policy if VS just strips it out!

I am trying to find a way around this with no luck so far. Cliff's solution will work but it seems like overkill for something that should be supported.

buckleyc on Database Projects in 2008 not scripting header comments of stored procedures anymore??

Fri, 09 Oct 2009 15:46:43 -0700

Not as hard as you might think.

/*comments here*/

CREATE Procedure dbo.test

AS

BEGIN

select 1

END

GO

DECLARE @Definition varchar(max)

DECLARE @comments varchar(max)

DECLARE @ProcTop varchar(max)

DECLARE @ProcBottom varchar(max)

DECLARE @StartComment int

DECLARE @EndComment int

DECLARE @StartProc int

SELECT @Definition=OBJECT_DEFINITION(OBJECT_ID('dbo.Test'))

SET @StartComment = CHARINDEX('/*',@Definition)

SET @EndComment = CHARINDEX('*/',@Definition)

SET @StartProc = CHARINDEX('BEGIN',@Definition)

SET @comments = SUBSTRING(@Definition,@StartComment,@EndComment+1)

SET @ProcTop = SUBSTRING(@Definition,@EndComment+2,@StartProc-@EndComment)

SET @ProcBottom = SUBSTRING(@Definition,@StartProc+5,LEN(@Definition))

PRINT @ProcTop + (CHAR(13)+CHAR(10)) + @Comments + @ProcBottom

Just loop your objects and do dynamic sql. You'll want to replace Create Procedure with Alter Procedure.

mlakarj on Database Projects in 2008 not scripting header comments of stored procedures anymore??

Fri, 09 Oct 2009 06:42:09 -0700

VS 2008 DB Projects ("Data Dude"). And guess what: it strips out comments between "AS" and "BEGIN" as well, any comment that isn't actually in the contents of the proc. We can try to move all our headers to be within the contents of the proc (not really a "header" then, is it?), but that would be time consuming and tricky to do by hand or by script.

buckleyc on Database Projects in 2008 not scripting header comments of stored procedures anymore??

Thu, 08 Oct 2009 15:53:36 -0700

Do you mean VS 2008 database projects? SSMS 2008 Projects? That TFS thing that I cannot seem to remember the name of?

Sounds like a bug to me. What I would suggest creating the objects like this:

Create Procedure schema.name

@param1 datatype

AS

/*

comments here

*/

mlakarj on Database Projects in 2008 not scripting header comments of stored procedures anymore??

Thu, 08 Oct 2009 13:07:11 -0700

I’ve noticed Database Projects in 2008 are not scripting header comments of stored procedures anymore. They’re being stripped out. Which is odd because it worked fine with 2005. This is frustrating because this is where we usually keep all stored proc modification history. Can anyone please help?