Database

N a v a n e e t h wrote:

putting a lock to the row when I select "PageView" for updating. Update the count and release the lock

hspc wrote:

Why do you select the row and lock it?

N a v a n e e t h wrote:

I thought of using locking.

Update tblPages<br />
Set ViewCount = ViwCount + 1<br />
Where PageID = @PageID

DECLARE @top NVARCHAR(10)
DECLARE @query NVARCHAR(100)
SET @top = '10'
SET @query = 'SELECT TOP ' + @top + ' * FROM YourTable'
EXECUTE SP_EXECUTESQL @query

<br />
Alter proc SelectTop<br />
(<br />
@Top_No int <br />
)<br />
as <br />
<br />
set rowcount @top_no<br />
select * from origainal_Msg where status=0<br />

int i=1;<br />
string s = i.ToString().PadLeft(3,'0');

set quoted_identifier off<br />
select "b'day"<br />
set quoted_identifier on

set quoted_identifier off<br />
select "b'day"<br />
set quoted_identifier on