Viewing 15 posts - 13,021 through 13,035 (of 15,379 total)
SKYBVI (2/8/2012)
GilaMonster (2/8/2012)
Yes.Thanks.
Then these begin and rollback transactions are used for whcih TSQL statments??
Regards,
Skybvi
If you have a batch of updates for example. Maybe you need to update 3 different tables,...
February 8, 2012 at 2:11 pm
LutzM (2/7/2012)
February 8, 2012 at 2:07 pm
exec SDoinidis_Duluth_LicenseeActivity @Address = 'Some Value'
February 8, 2012 at 11:09 am
That will work if ALL your HTML is properly formatted so it can be parsed into xml. This is likely not going to be the case and properly removing all...
February 8, 2012 at 11:02 am
sunny.tjk (2/8/2012)
Could someone please tell me if the following query is correct:Begin Transaction
Delete from tableabcd where starttime < '1/1/2011'
Rollback Transaction
Well that depends on what you define as "correct". There do...
February 8, 2012 at 10:49 am
It failed because you didn't pass the parameter when called your stored proc.
February 8, 2012 at 10:46 am
Something like this?
SELECT Customer_Number FROM Customer_Offer
WHERE Product_Offer = 'Offer2'
and Custom_Number in
(
SELECT Customer_Number FROM Customer_Offer
WHERE Product_Offer = 'Offer1'
)
February 8, 2012 at 10:43 am
lonex (2/8/2012)
You were right that without the data it is hard to validate code. I will be trying to create sample data and code as per best practice...
February 8, 2012 at 10:19 am
river1 (2/8/2012)
Sorry, didn't understood you point...
This is a database about stocks (Car parts)
This parts (wheel, tires, etc...) can be located...
February 8, 2012 at 10:01 am
river1 (2/8/2012)
In the location_type you don't have just vheicules...You have three different records:
1) Cars
2) Trucks
3) WareHouse
This is where the stocks can be
I followed that. Maybe that should be Vehicle and...
February 8, 2012 at 9:44 am
I don't think you want a table for this. This really should be a view instead of a permanent table. Otherwise you have to insert/update/delete from this table every time...
February 8, 2012 at 9:30 am
GilaMonster (2/8/2012)
Sean Lange (2/8/2012)
Cadavre (2/8/2012)
February 8, 2012 at 9:22 am
Cadavre (2/8/2012)
February 8, 2012 at 9:09 am
http://www.sqlservercentral.com/articles/T-SQL/66097/%5B/url%5D
Make sure to read all the way to the bottom so you will find the link to part 2.
February 8, 2012 at 9:00 am
John Mitchell-245523 (2/8/2012)
Yes, but the point is that with UPDATE...FROM, you'll never know about it.John
At least until the users start screaming that their data is wrong. 😛
If you...
February 8, 2012 at 7:52 am
Viewing 15 posts - 13,021 through 13,035 (of 15,379 total)