Viewing 14 posts - 1 through 14 (of 14 total)
Unit tests are specific in nature. A unit test determines whether a unit of code meets a certain specification. When unit tests fail they should point to a...
April 14, 2009 at 2:40 pm
This is interesting - but it's not generating unit tests - it's generating integration tests which are not diagnostic, and do not run quickly, or cover all functionality.
April 14, 2009 at 1:39 pm
Thanks for the help Terry!
I am trying that right now. I will let you know the outcome.
-Jonathan
June 27, 2005 at 11:14 am
Looks like you want to think in terms of sets here.
You can probably indentify the rows that need to be updated with a view (where they exist on bot hh...
May 17, 2005 at 3:56 pm
If you want to send a message to MSMQ from one machine to another, you need to install MSMQ on three servers.
On the Primary Domain Controller (PDC) you need to...
May 16, 2005 at 4:10 pm
I think you are referencing lots of tables in your view. So the underlying data may be more volatile than you think.
Another approach you may want to consider is materializing...
May 13, 2005 at 9:28 am
I only glanced at your T-SQL, but I think what you want to do is the following. HTH!
-Pick an ID that is unique for each insert, say PatientID, and then...
May 13, 2005 at 9:20 am
Alternatively, you can define an INSERT trigger to set the insertdate.
May 12, 2005 at 3:58 pm
You may fare better using DTS from Enterprise Manager.
In enterprise manager, choose Tools -> Data Transformation Services -> Export Data.
Follow the prompts, and you can name target type, separator...
May 12, 2005 at 3:39 pm
My gut reaction is that your employers really want you to create a view, so that they can see similar objects in one data structure.
If the entities are different, they...
May 12, 2005 at 3:31 pm
I've done some development where I materialize base views into tables... Generally, if the result sets are very large, or some of the base views distinct their results, this can...
May 12, 2005 at 3:11 pm
The following will probably work for you:
INSERT INTO businesses ([name], datelastmodified)
SELECT DISTINCT left([secondary ins co],80), '5/3/2005'
FROM upload2 T1
WHERE NOT EXISTS
( SELECT 1 FROM businesses T2
WHERE productid = 12
AND left(t1.[secondary ins...
May 12, 2005 at 3:07 pm
I have what I believe is a better way of doing this.
I don't like to build strings and then exec the results, as there is the possibility of SQL injection,...
May 12, 2005 at 3:00 pm
If you have message queue configured to run over the network, you are likely actually sending data from the SQL Server Box to the testbox via the PDC. So you...
May 12, 2005 at 2:45 pm
Viewing 14 posts - 1 through 14 (of 14 total)