May 1, 2017 at 12:00 am
Comments posted to this topic are about the item SQL Server Unit Testing in Visual Studio
May 1, 2017 at 9:18 pm
Unit testing is not about running an SP and reading the results. It is all about mocking, stubbing and faking and running in CI. That's why I do not use Microsoft's solution.
But now it appeared that the solution I use is not compatible with Columnstore indexes. That is sad to me.
May 2, 2017 at 11:18 pm
Tried doing this, but for some reason the "Create Unit Tests..." option is disabled.
Running Visual Studio Professional 2015 v 14.0.25431.01 Update 3
SQL Server Data Tools v 14.0.61021.0
--------------------
Colt 45 - the original point and click interface
September 22, 2017 at 1:24 am
Can I run multiple tests in one class, please?
I would like to test multiple conditions against stored procedure.
January 5, 2020 at 8:53 pm
Can somebody comment on how this compares to using the T-SQL-t framework. I have only a general idea about, but haven't used it in the real world.
July 23, 2020 at 9:41 pm
I'm having trouble using some of the newer/odder INSERT/SELECT INTO syntax's
They run just fine from a .SQL dialog from VS2015, but not within a SQL unit-test.
In all cases I am populating a temp table and using MSSQL 2015.
This standard syntax works just fine in both a SQL unit-test and as a SQL script in DevStudio;
INSERT INTO #Expect ([Name], [System_Type_Name]) VALUES ('Mail_Option', 'Varchar(20)')
However, these will not work in a unit-test but if you copy-n-paste into a script they work fine;
SELECT * INTO #Actual FROM OPENROWSET('sqlncli', 'server=xxx;Trusted_Connection=yes;','EXEC xxx')
or
INSERT INTO #Actual EXEC dbo.Xxx
The error is;
System.Data.SqlClient.SqlException: Incorrect syntax near the word 'INTO'.
Your help is appreciated.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy