Viewing 15 posts - 646 through 660 (of 728 total)
yes, Perfect. Thats what I was looking for. Thanks once again.
June 30, 2011 at 4:16 am
I just want to input a string separated by comma and process it to give me output with same string separated by comma BUT having quoted each word so that...
June 30, 2011 at 3:46 am
Total Records ?
TABLEA around 8000000 and TABLEB around 20000.
Using simple Delete statement like
NO.
Delete from tab1 ? or some other procedure to delete the data ? I am asking the...
June 30, 2011 at 2:29 am
Thanks Nakul. Thats not what I'm looking for. Lolz.
Actually looking for "If input string is like AAAA, pqrstuv, xxxx-lmn, ZZZsswD then output string should be 'AAAA', PQRSTUV', 'XXX-LMN', 'ZZZSSWD'".
June 30, 2011 at 12:39 am
Here is the attachment. I've scratched my head blue and black. 🙁
June 29, 2011 at 7:24 am
It shows 9.00.1399.00 for SQL Server 2005 Management Studio.
June 22, 2011 at 3:27 pm
Sorry if it sounds stupid gail bu how can I check if SSMS will be 2005 RTM
June 22, 2011 at 2:17 pm
I am not sure about pre SP2 thing but definitely it is clustered index seek and not scan.
June 22, 2011 at 1:09 pm
Hello Gail. Somehow it's not possible for me to post execution plan. 🙁
Though i know it is hard to predict but I will be thankful if you could tell...
June 22, 2011 at 12:03 pm
Totally agreed with Sujit. Use char only in case of fixed[strictly] length value else varchar [with maximum length of the value].
June 22, 2011 at 11:32 am
Agreed. Nolock should not be followed. However if MS has provided that hint, then where exactly it should be used [to be precise] ?
June 21, 2011 at 4:54 am
Viewing 15 posts - 646 through 660 (of 728 total)