Thanks

What do u do if today is a chirstmas day? I most properly having some good food, and greetings for everyone..!!

I apologies for what i did.. I know i should listen you first but as u said i am a small kid and i need to go far away.. I can not compete with u, your knowledge, your points but as a senior u should have helping hands.. I can learn today a big lesson and now i can think i was fool for what i did and totally unprofessional.. I have to go far away, I hope i get support from u and u help a kid to grow up.. Sorry, Aadhar

U please read the question.. he is talking about only 100 clients.. u know in a second how many number of locks sql can handle?? every time i don't belive i am good enough for all condition.. same applies to u also..

See its fine.. it it would be a draw back, sql shouldnt given it as an option.. Yes there may be dirty read or penthoms but see.. it executes on hard cases where traffic u can find as in mili seconds.. please go through it when it actually creates problem.. Transaction isolation level are used by many companies.. are they fool?? huh.. i myself use read uncommit.. this all are good if u know your architecture..

Well it will.. In that case u can use lock hint Select * from TableName WITH (NOLOCK) where 1=1 AND (some condition)

you can use lock hints.. update table WITH (TABLOCKX) set status = 1 where keyId = 6 This lock is most safe as well as it increses your performance..

Where 1=1 I mean that is obvious..

Keep your column in an numeric format OR convert it manually in numeric format so it dont create destruction.

Hi, U can use following statment..

SELECT ISNULL(File_Name, '')
FROM Files
WHERE File_Name = @FileName1

because is is string so it should return blank

First thing is u should avoid sub query as a column and make a inner join and take a column from sub table as it improves your performance when u fire your query with large data. Second is it works fine till sub query produces single record for parameter, if there is more than one row returned by sub query, it throws errors. Third for same u can use distinct clause in sub query.