Viewing 15 posts - 1,381 through 1,395 (of 1,419 total)
[
The same reason you unit test anything? It's either the new development or it's something you're modifying.
New development and modifications should be tested over and over until they work as...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 6:07 pm
Yes I would 100% disagree with that, every object in the database does not interact with every other object in the DB in some exponentially spirally level of complexity. ...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 5:44 pm
Sometimes
They're distinct. Is because performance?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 5:37 pm
Ah, ok. So the reason you may want to keep unit tests is if anything needs to change with your data model, you've already documented how things should work and...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 5:24 pm
In my opinion unit testing in a relational database is basically fruitless. The whole idea is the data model is schema bound. So what are you testing but only...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 4:49 pm
David
the non-SQL parts of our C# app are tested with a few unit tests and a lot of manual tests.
We plan to reverse the quantity (unit testing first and...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 4:43 pm
In my opinion unit testing in a relational database is basically fruitless. The whole idea is the data model is schema bound. So what are you testing but only to...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 4:28 pm
It's possible to get rid of "or" in where clause using DeMorgan's Law. If the goal is readable code tho... sometimes that pretty much goes out the window.
Some test data: Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 19, 2019 at 1:08 pm
Last year I had to do something similar with a csv file. Openrowset can't contain sql expressions, only literal strings. So dynamic sql is the way to go. Something like:
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 16, 2019 at 8:40 pm
Step 1: generate some dummy data
/* create a table to hold the country and province values */
/* as well as a column to store the cntry_prov_code...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 16, 2019 at 4:39 pm
If your database originally resided on a different server (with a different collation), columns created would have used that default. Columns created after the migration would default to the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 16, 2019 at 2:27 pm
Why do you declare province to be char(2) and then assign it left(col_name, 1) which is only 1 character?
Does the sequence reset for each country?
What is the needed sort order...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 16, 2019 at 1:34 pm
Suppose the code you need to calculate is called the "Country Province Number" CPN. The issue here is the example you provided only declares variables for a single record and...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 16, 2019 at 12:49 pm
You have 2 tables?
The output...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 16, 2019 at 12:27 pm
The "or" we were looking for. The second example, the one with "coalesce", consolidates the 3 columns (Employed, Not employed, Retired) into 1 column (Employed status) by selecting the first...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 16, 2019 at 11:58 am
Viewing 15 posts - 1,381 through 1,395 (of 1,419 total)