Viewing 3 posts - 16 through 18 (of 18 total)
IF EXISTS (SELECT * FROM Product WHERE id = 6)
BEGIN
MERGE Product AS Tgrt
USING Product AS Src
ON Trgt.id = Src.id
WHEN MATCHED THEN
UPDATE Product
SET ProductName = 'name 6'
WHEN NOT MATCHED THEN
INSERT...
June 18, 2012 at 1:15 pm
#1502412
That makes sense. The update is triggered only when query is executed against them. Thanks.
June 18, 2012 at 12:41 pm
#1502400
Would you guys want to share your views on whether or not sp_updatestats would be necessary in regular db maintenance job if you have your Auto Update Stats to ON?
June 15, 2012 at 2:25 pm
#1501890