Viewing 15 posts - 11,206 through 11,220 (of 15,376 total)
Welsh Corgi (7/25/2012)
GSquared (7/25/2012)
Modify your error proc (usp_GetErrorInfo) so that it inserts into a table, then you're good to go.
I did that and it worked fine.
I have a very basic...
July 25, 2012 at 12:54 pm
All this work and effort to store a piece of data that should be retrieved real time using a view instead. 😛
I would comment on the table structure a little...
July 25, 2012 at 10:58 am
That assumption is entirely to generic to have any basis on fact. Why would a delete and an insert cause a recompile? There is nothing about having two statements in...
July 25, 2012 at 10:47 am
byecoliz (7/25/2012)
The tool is a modeling tool that gives DDL scripts as a result. so apparently it gives the DDL of one platform.
with T-SQL you can develop...
July 25, 2012 at 10:45 am
Phil Parkin (7/25/2012)
Nice article - thanks for the link. When I read absolutes (like 'meaningless') my brain subconsciously challenges them. I still think it was the wrong word 🙂
Maybe it...
July 25, 2012 at 10:22 am
byecoliz (7/25/2012)
July 25, 2012 at 10:10 am
ScottPletcher (7/25/2012)
ALTER TRIGGER UPDate_PONumber
ON dbo.PurchaseOrderDetail
AFTER INSERT, UPDATE, DELETE
AS
UPDATE PON
SET SubTotal = PO_Total.SubTotal
FROM dbo.PONumber...
July 25, 2012 at 9:49 am
edward_hall76 (7/25/2012)
He is the information in the database.On a view will it update the PONumber table everytime something is updated or added to the PurhcaseOrderDetail
I don't understand your response here....
July 25, 2012 at 9:30 am
This post is over 3 years old and the OP has not logged into SSC since they created the original post. Move along...nothing to see here.
July 25, 2012 at 9:26 am
Stefan Krzywicki (7/25/2012)
Lynn Pettis (7/25/2012)
Jeff Moden (7/25/2012)
Stefan Krzywicki (7/25/2012)
July 25, 2012 at 9:26 am
edward_hall76 (7/24/2012)
Here is the script for the database.
Holy cow. We don't need the entire database just the stuff relevant to your issue. In the future it would probably be in...
July 25, 2012 at 9:04 am
OK so you tried to post some code but you missed the mark. The code you posted is full of syntax errors and variables not declared. There are columns referenced...
July 25, 2012 at 7:39 am
Nice straight forward question. Keep them coming Pradeep.
July 25, 2012 at 7:14 am
You are welcome. Glad you were able to figure out a solution.
July 25, 2012 at 6:58 am
Matt Miller (#4) (7/24/2012)
Sean Lange (7/24/2012)
True and good reminder. You could however do something like this:
update blah
set mycol='SomeNewValue'
output @@rowcount
(snipped for brevity)
Neat idea, but unfortunately it...
July 24, 2012 at 2:51 pm
Viewing 15 posts - 11,206 through 11,220 (of 15,376 total)