Welcome! Please take a few seconds to create your free account to post threads, make some friends, remove a few ads while surfing and much more. ClutchFans has been bringing fans together to talk Houston Sports since 1996. Join us!
Thanks for the suggestions all. I got a lot of good info to start researching more. It's always hard with a big groups, some of us want to go...
The agony!!
Nooo! Please not Gary Payton. I don't think he'll be a good fit here at all, on the court or in the locker room.
Reverberate
Does anybody have any good recommendations for any state or national parks or other areas for camping for a weekend? We'll have a big group and...
http://www.gotapex.com/
Don't forget your rebate! It'll save ya $49
If you want other ppl's input on Torque and the laptop you are looking into, go to: http://notebookforums.com/
I heard good things about powernotebook.com and torque. Good laptops. So are: http://www.hypersonic-pc.com http://www.discountlaptops.com...
I was looking at the 9100 this morning also and now within a few hours it's gone! =(
If you are looking for a new laptop, Dell Home is currently having one of their best deals and it will end at 6:00 cst today. Use this coupon:...
I think GMail was banning accounts for things like this. Not positive tho.
Update members set groupid = 34 where SSN='123-46-7844' You only need ' around varchar, char, datetime etc.. if it's a int, tinyint etc......
You guys are learning about triggers but have gotten into updating or deleting records from a table? :confused: Try Delete from [table]...
Just be sure to create all the fields you need, set the right datatype and declare it as null or not null, same as the original table. Are you...
right click the database and click refresh.
The trigger, you just create it once, and it will automatically run everytime the members gets updated/inserted/deleted. Just set it and forget...
oops, not good writing free hand like this. Anyhooo.. CREATE TRIGGER UpdateMemberCount ON [dbo].[members] FOR Insert, Delete, Update AS...
What tool are you using sql query analyzer?
yeah, there is a logic flaw in the individual update trigger. It isn't there in the combined trigger.