CODEWITHSUNDEEP
c#unit-testingsql-server-2005
lordkain
lordkain

Reputation: 3109

SQL script compatible SQL Server 2005

I have an application and this will "install" some stored procedures into a local database.

I want to make a unit test to validate the stored procedures so that the will be valid from SQL Server 2005 and up.

Is there a way to do this with / without SQL Server?

Upvotes: 0

Views: 161

Answers (1)

marc_s
marc_s

Reputation: 754408

The Data Dude (Gert Drapers) describes how to use the built-in SQL Server T-SQL parser in your application here:

If you want to only check the validity of the SQL code that you have - this might be a nice way to go, and it doesn't require SQL Server per se to be installed where you run your unit tests.

Upvotes: 1

Related Questions