This is Amar Gupta, Blogging Technical & personal things, Right now working as a Technical Associate in eTech Acess Marketing Consulting Pvt. Ltd. , in this company Deals Insurance Sector so There many of Use of Technology Like SQL server, .Net Framework, Marketing campaign for advertise Business purpose.
So personalty i describe here that what i am doing & phasing problem at the time of development, for reminder or beneficial for other member.
—————————————————————-
Thanks U to All Who discuss with Me, To Enhancement Technology**
—————————————————————
Hi This is Amar Gupta,
This is My first Blog in WordPress.com, I M just try to expose what is happening in Sql Server, C#.Net, WCF, LINQ and other using new Technology.
Today working on SQL Server functionality ,With (NoWait) & With (NoLock)
With (NoLock) :- Produce result in dirty way , and at the time of processing not show any message.
With (NoWait) :- It is the Standard functionality after NoLock , It is provide a good result or show message , that what happening with that data.
————————————–
For Example: —
——————————-
CREATE TABLE First (ID INT, Col1 VARCHAR(10))
GO
INSERT INTO First (ID, Col1)
VALUES (1, ‘First’)
GO
Now open two different connections:
Connection 1: Run following query
BEGIN TRAN
DELETE FROM First
WHERE ID = 1
Connection 2: Run following query
BEGIN TRAN
SELECT ID, Col1
FROM First WITH(NOWAIT)
WHERE ID = 1
——————————–