Viewing 15 posts - 376 through 390 (of 431 total)
cs_troyk (8/14/2009)Did you see this workaround for multiple inserts? (Limited to 2 tables and SS2K8, but interesting nonetheless) http://weblogs.sqlteam.com/peterl/archive/2009/07/29/How-to-insert-into-two-tables-in-one-statement.aspx
Yes. You can use OUTPUT to insert to another table in 2005...
August 14, 2009 at 1:15 pm
cs_troyk (8/14/2009)Imagine how much easier life would be if you could declare constraints (both column constraints and inclusion dependencies) that reference views... http://connect.microsoft.com/SQLServer
That would be useful indeed. But...
August 14, 2009 at 12:52 pm
Matt Miller (8/14/2009)I copied it right out of his post, ran it, and got no error - what am I missing here?
Whether you get an error or not is dependent...
August 14, 2009 at 12:13 pm
Matt, you missed the point of what I was saying. My UPDATE should not violate the constraint, that's true. But what I wanted to demonstrate was that the constraint will...
August 14, 2009 at 10:50 am
Lowell,
I posted before I saw your reply but I think you will find your solution suffers the same problem.
August 14, 2009 at 10:33 am
I was talking about both the specific case and the more general situation.
Using a function as part of a constraint is a procedural solution rather than a declarative one. It's...
August 14, 2009 at 10:29 am
Mr. Newbie (8/12/2009)
Is it possible to implement this using database constraint or should I just let my application check first the number of records in the tblToolsTrans table for a...
August 14, 2009 at 4:08 am
josh.d.kelly (8/13/2009)
August 14, 2009 at 3:49 am
In 2005 the following xquery expression results in "
".
In 2008 it results in "
".
This seems to have nothing much to do with the SQL Server DATETIME type but maybe they...
August 2, 2009 at 9:27 am
I suggest you do this during a maintenance window while there is no-one using the DB. Emptying the file could take a long time, depending on the data size. Make...
July 28, 2009 at 7:38 am
Take a look at Vadim Tropashko's book SQL Design Patterns for examples of relational division problems and solutions.
Full marks for a good question by the way. It's a bit unfortunate...
July 25, 2009 at 3:02 am
RBarryYoung (7/18/2009)
July 19, 2009 at 11:47 am
Because they are different queries. The logic of SQL's treatment of nulls is not very consistent unfortunately and that's one reason why many people try to avoid nulls altogether.
In the...
July 12, 2009 at 8:45 am
dcorbitt (7/2/2009)
July 2, 2009 at 2:11 pm
Andy Bod (3/22/2009)
Can you advise how, if I go for the multiple database option I can best keep the structure and sp's in sync? Can this be automated?
My advice is...
March 25, 2009 at 4:35 am
Viewing 15 posts - 376 through 390 (of 431 total)