Viewing 15 posts - 1,756 through 1,770 (of 6,036 total)
SELECT i.PK_Column, d.OtherColumn [Old Value], i.OtherColumn [New Value]
FROM inserted I
INNER JOIN deleted d on d.PK_Column = i.PK_column
This would work in FOR UPDATE trigger only.
On INSERT table deleted is empty, and...
December 15, 2015 at 3:36 pm
PJ_SQL (12/15/2015)
For one that has been updated I used trigger to insert into new table.
But How do I also...
December 15, 2015 at 3:31 pm
Luis Cazares (12/15/2015)I'm pretty sure that LEN('h_hmid=') will always return 7, as that's a string literal with a constant value.
It's constant only until they change the name of parameter.
"7"...
December 15, 2015 at 2:08 pm
jaquino012 (12/14/2015)
Hi,@steve-2 Jones - SSC Editor
Yes iam doing a general query for a spell checker.
Does querying it using a Access is much more faster than SQL?
Actually, using SQL is...
December 14, 2015 at 8:54 pm
Luis Cazares (12/11/2015)
.. adjust the data types (varchar2 to varchar, ...
varchar2 is nvarchar.
December 14, 2015 at 6:12 pm
kat35601 (12/14/2015)
so a good order would have 5 items all with a status greater then 3
None of the orders from your data set fits this description.
Does it mean all of...
December 14, 2015 at 6:03 pm
ScottPletcher (12/14/2015)
Select order_number,
min(serial_number) AS serial_number_min,
max(serial_number) AS serial_number_max,
min(status) AS status_min,
max(status) AS...
December 14, 2015 at 5:55 pm
Post the whole query.
With the fragment you posted I can only suggest to replace the correlated subquery with a join.
December 14, 2015 at 5:51 pm
ScottPletcher (12/14/2015)
They should have the same level of permission in a test environment that they do in production, otherwise you haven't tested security, right?
Do developers really have the same level...
December 14, 2015 at 5:34 pm
ScottPletcher (12/14/2015)
For Application Events. Stored proc parameters are not events, of course.
Starting a procedure is quite an event for the application.
And supplied parameters are part of description of that...
December 14, 2015 at 5:28 pm
LinksUp (12/14/2015)
DateDiff(dd, case when det_dte is null GetDate() else det_dte end,...
December 14, 2015 at 5:06 pm
The error is somewhere else in the query.
Or - either det_dte or rec_dte is not datetime.
December 14, 2015 at 3:41 pm
ScottPletcher (12/14/2015)
1) I wouldn't advise writing that type of info into error logs.
Why?
What do you think Application Event Log is for?
December 14, 2015 at 3:34 pm
ScottPletcher (12/14/2015)
hopefully your normal app logins don't have that high a level.
On a test host?
December 14, 2015 at 3:26 pm
You may add something like this into your procedure:
DECLARE @ProcName sysname, @Param INT
SELECT @ProcName = OBJECT_NAME(@@PROCID), @Param = 1000
IF HOST_NAME() = 'My Test Host'
RAISERROR ('Started procedure %s, Parameter supplied: @Param=%d',...
December 14, 2015 at 2:44 pm
Viewing 15 posts - 1,756 through 1,770 (of 6,036 total)