Viewing 15 posts - 8,086 through 8,100 (of 9,401 total)
When you try to delete from the child table, are you sure the referential integrity error is with the parent table? It could be that the child table has...
May 16, 2014 at 7:26 am
crookj (5/16/2014)
Ed Wagner (5/15/2014)
Stuart Davies (5/15/2014)
Ed Wagner (5/14/2014)
Stuart Davies (5/14/2014)
BWFC (5/14/2014)
Ed Wagner (5/13/2014)
Stuart Davies (5/13/2014)
crookj (5/12/2014)
Ed Wagner (5/12/2014)
Revenant (5/12/2014)
Ed Wagner (5/12/2014)
TomThomson (5/12/2014)
crookj (5/12/2014)
PlateGlass
Dinner
Roll
Butter
(Roll over) Beethoven
(Chuck) Berry
(Twist and) Shout
Yell
Rebel
Idol
Lazy
Teenager
Adolescent
Attitude
May 16, 2014 at 6:29 am
The child table will have a foreign key constraint to the parent. Do you understand why you have to delete the child rows before deleting the parent row?
May 16, 2014 at 6:00 am
It looks like there's more than one problem with Microsoft's SQL documentation. They do have a bit of it to maintain, but you'd think they would get the docs...
May 16, 2014 at 5:25 am
I know I'm a day late, but I still learned something with this one. Trace flags are not my strong suit. I don't know them off the top...
May 16, 2014 at 5:22 am
Lynn Pettis (5/15/2014)
It is your style. Just reading it screams that you are always right and everyone else is wrong.
Lynn Pettis (5/15/2014)
May 15, 2014 at 1:59 pm
SQLRNNR (5/14/2014)
Luis Cazares (5/14/2014)
I'm afraid, "he-who-shall-not-be-named" is back in the forums.I hope that I can behave well enough.
Who? Tom Marvolo Riddle?
You know, I think that was a great series...
May 15, 2014 at 1:43 pm
Stuart Davies (5/15/2014)
Ed Wagner (5/14/2014)
Stuart Davies (5/14/2014)
BWFC (5/14/2014)
Ed Wagner (5/13/2014)
Stuart Davies (5/13/2014)
crookj (5/12/2014)
Ed Wagner (5/12/2014)
Revenant (5/12/2014)
Ed Wagner (5/12/2014)
TomThomson (5/12/2014)
crookj (5/12/2014)
PlateGlass
Dinner
Roll
Butter
(Roll over) Beethoven
(Chuck) Berry
(Twist and) Shout
Yell
Rebel
Idol
Lazy
Teenager
May 15, 2014 at 5:24 am
Glad to hear it worked out for you in the end.
May 14, 2014 at 12:37 pm
Something like this?
SELECT ProjectID, ProjectName, ProjectDescription
FROM tbl_Projects
WHERE (ProjectID = @ProjectNumber OR @ProjectNumber IS NULL);
Performance may be a little better firing them individually without the OR...
May 14, 2014 at 7:48 am
Sean Lange (5/14/2014)
GilaMonster (5/14/2014)
Koen Verbeeck (5/14/2014)
This was a funny topic 😀 (especially the last replies)Sorry, am a little short on patience today.
I almost spit my coffee on the screen when...
May 14, 2014 at 7:41 am
Don't test with a 1,000-row table. Test with a 1,000,000-row table. Many things can run well with 1,000 rows. Testing on a 1,000,000 rows tends to expose...
May 14, 2014 at 6:07 am
Stuart Davies (5/14/2014)
BWFC (5/14/2014)
Ed Wagner (5/13/2014)
Stuart Davies (5/13/2014)
crookj (5/12/2014)
Ed Wagner (5/12/2014)
Revenant (5/12/2014)
Ed Wagner (5/12/2014)
TomThomson (5/12/2014)
crookj (5/12/2014)
PlateGlass
Dinner
Roll
Butter
(Roll over) Beethoven
(Chuck) Berry
(Twist and) Shout
Yell
Rebel
Idol
May 14, 2014 at 5:35 am
If you have concerns about fragmentation, use an integer. If you need to support more rows, use a big integer. If you aren't concerned about fragmentation or storage,...
May 14, 2014 at 5:32 am
Viewing 15 posts - 8,086 through 8,100 (of 9,401 total)