Viewing 15 posts - 5,221 through 5,235 (of 6,036 total)
Could be usefull:
SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON | OFF }
July 30, 2006 at 7:17 pm
FYI
For NOT NULL coluns COUNT(Column) and COUNT(*) will ALWAYS return the same result.
Run this and feel lucky:
SELECT Col_1, COUNT(*
July 30, 2006 at 6:56 pm
If it's not a sectret, what's the point?
July 30, 2006 at 6:37 pm
You better copy the SQL code generated by EM into QA and run it from there.
QA does not have timeouts. Unless you set it up.
And better do it overnight.
July 27, 2006 at 6:33 pm
I tell you, it's not about speed!
It's not about locks!
You UPDATE statement is wrong!
You update the whole table tblLicRebateStatement, all rows with any programID, not only where programID = 319.
It...
July 27, 2006 at 6:28 am
That's typical problem with badly designed queries.
They seem OK because they use to work for sometime. But one day after next portion of data inserted into database they suddenly become...
July 27, 2006 at 6:07 am
The problem is you are updating table from another instance of the same table.
It creates deadlock.
Use this:
UPDATE L
SET July 27, 2006 at 3:35 am
UPDATE tbl_leads_queue
SET lead_status_id = 7
WHERE
parent_lead_id = @LeadID
AND partner_id = 19
AND lead_status_id = 3
AND date_sent between convert(datetime, convert(int, getdate()-0.5)) and convert(datetime, convert(int, getdate()+0.5)) - convert(datetime, '00:00:00.003')
July 26, 2006 at 5:59 pm
Actually you I can use a select statement to set the value of a parameter variable that is declared locally in the stored procedure.
It just must be SELECT.
SELECT @paramCheckSumNo ...
July 26, 2006 at 5:50 pm
There are no output only parameters.
OUTPUT parameter is INPUT as well.
Just dare to use it.
July 26, 2006 at 3:33 am
OK, start exersise from the beginning.
Being in EM or QA press {F1}.
In Index tab type "output parameters".
Press Enter.
In the list appeared find "Returning values using OUTPUT parameters".
Select it...
July 26, 2006 at 1:57 am
Did you hear about the magic and power of knowledge hidden behind the key {F1}?
July 26, 2006 at 1:20 am
Probably your function contains SELECT(s) from another table(s) by the value in rows of Table1.
They name it "hidden cursor" and not recommend to use anywhere.
If it's true I would suggest...
July 25, 2006 at 11:55 pm
SELECT Column1, Column2, case when Column1=’xyz’ then ‘hello’ end as Column3
FROM (
SELECT dbo.MyFunction(a) as Column1, b as Column2
FROM Table1
) dt
July 25, 2006 at 11:27 pm
Viewing 15 posts - 5,221 through 5,235 (of 6,036 total)