Viewing 15 posts - 1,921 through 1,935 (of 2,894 total)
saribobby (3/13/2012)
I am updating one field through Store procedure, But sometimes it doesn't get updated, Is there any particular reason for not updating.
In this table i...
March 13, 2012 at 7:27 am
pallavi.unde (3/13/2012)
...
I read Option(fast n) executes query fast and gives o/p soon.
...
Where have you read this from?
It does not make query to run any faster! It just makes query to...
March 13, 2012 at 7:17 am
Question like that should be posted in according with the "forum etiquette" (link at the bottom of my signature). Only 'cause you "first-timer" here:
This how you should post "I...
March 13, 2012 at 7:11 am
What about posting some ddl, data sample and the script itself? Follow the link at the bottom of my signature to find out how to do so. There are not...
March 12, 2012 at 2:45 pm
Looking into your UDF, it would definitely benefit from implementing it as CLR function.
Also, you can try to split your query in two parts.
First filtering out everything without checking...
March 12, 2012 at 1:36 pm
ard5karthick (3/12/2012)
And it is 36 Bit not 16 Bit and Each Digits can be of HexaDecimal Value From (0 -9)...
March 12, 2012 at 1:24 pm
Are you sure that there are some data which satisfies all WHERE clauses?
Try to run exactly the same SELECT on your source server...
Without double quotes your statement is invalid.
March 12, 2012 at 11:14 am
366 points! You are not first-timer here.
Please try to post your question as per "forum etiquette", link at the bottom of my signature.
March 12, 2012 at 10:36 am
Ok,
Product A. vs Product B.
Having: Product B cost as twice as Product A, require twice as many people and hours to achieve exactly same requirements
I can easily show that...
March 12, 2012 at 10:32 am
Elliott Whitlow (3/12/2012)
I used to deal with this sillyness in a previous job, until IT finally...
March 12, 2012 at 9:33 am
opc.three (3/12/2012)
...
Table '#test_objects'. Scan count 1, logical reads 1174, physical reads 0, read-ahead reads 0,
lob logical reads 0, lob physical reads 0, lob read-ahead reads...
March 12, 2012 at 9:25 am
1. Ask to hire someone with VB skills
or
2. Ask for complete requirements
I cannot see how you can reliably rewrite someone else code written in a language you can't read.
As for...
March 12, 2012 at 9:10 am
GilaMonster (3/12/2012)
ALTER TRIGGER [dbo].[tr_TaxID]ON [dbo].[Item] after INSERT, UPDATE AS
UPDATE item SET taxid = 1 WHERE item.id IN (SELECT id FROM inserted);
Done.
Just small note:
If you do it as above, even when...
March 12, 2012 at 9:04 am
Viewing 15 posts - 1,921 through 1,935 (of 2,894 total)