Viewing 15 posts - 946 through 960 (of 1,415 total)
Eric M Russell (2/19/2015)
ZZartin (2/19/2015)
Eric M Russell (2/19/2015)It's unclear how a table containing only Title + Author, and duplicates allowed, would be used by an application. If someone wanted to...
February 19, 2015 at 11:59 am
Yeah, even more so it used to work in 2000 (codebase for 2005...), I can sort of see their reasoning on NaN, but for the infinities, they seem to have...
February 19, 2015 at 11:31 am
stpii (2/19/2015)
Working in a project using Entity Framework (Code First)...
Until now the project has been connected to a (generated) SQL Server Compact 4.0 database,
but now we want to connect to...
February 19, 2015 at 11:09 am
Eric M Russell (2/18/2015)
butcherking13 (2/18/2015)
February 19, 2015 at 11:00 am
mittensonmaui (2/17/2015)
Unfortunately, they do not give us access to that which I don't understand.
Tell "them" to make sure an index is present that matches the query criteria. Otherwise, the query...
February 17, 2015 at 12:01 pm
Seems like it would work. I would however also insert a record in your log when the procedure starts, and when it successfully finishes. The absense of a successful finish...
February 16, 2015 at 8:47 am
TomThomson (2/14/2015)
TriggerMan (2/12/2015)
February 15, 2015 at 2:14 pm
having a random string, like a guid, will result in massive amount of page splits every time a new user is added.
Well thats unexpected. I would think it would be...
February 12, 2015 at 1:02 pm
Please review the following stored procedure CreateInvoice to determine what we can do for logging an exception that occurs within it ??
I like to keep a log table available that...
February 12, 2015 at 11:54 am
You can absolutely loop through rows and columns like a matrix in T-SQL. If you have any significant number of rows to do this with then make sure you have...
February 10, 2015 at 3:12 pm
CELKO (2/10/2015)
So whats the downside to a field per line?
Look up this common illusion:
Did you see the trick? Your brain forms clusters of letters and words called...
February 10, 2015 at 2:29 pm
No, but it is common design error. Unfortunately we have no DDL, so we have to start guessing. I also see you put one field [sic] or keyword per line...
February 10, 2015 at 10:41 am
aaron.reese (2/9/2015)
It was not my intention to rubbish stack exchange, I use it regularly for non SQL related activities. My point was that a lot of the people who...
February 9, 2015 at 1:26 pm
aaron.reese (2/8/2015)
@joe, it would be lovely to live in your SQL bubble where all RDMS is built and managed by people with 20 years experience, a masters degree...
February 9, 2015 at 9:17 am
pharmkittie (2/1/2015)
February 5, 2015 at 10:12 am
Viewing 15 posts - 946 through 960 (of 1,415 total)
