Database

update master_accounts
set master_accounts.a = de.a,master_accounts.b = de.b,etc...
from master_accounts
join depot_accounts de
on master_accounts.acountid = de.accountid

DECLARE @MyDate DATETIME<br />
SET @MyDate = GETDATE()<br />
WHILE (DATEPART(dw, @MyDate)) <> 'Monday'<br />
BEGIN<br />
SET @MyDate = DATEADD(day, -1, @MyDate)<br />
END

mon***z wrote:

lst_emp.DataTextField=objds.Tables[0].Columns["txtval"].ToString();
lst_emp.DataValueField=objds.Tables[0].Columns["emp_id"].ToString();

lst_emp.DataTextField = "txtval";<br />
lst_emp.DataValueField = "emp_id";

con.Open();<br />
<br />
SqlDataAdapter adp= new SqlDataAdapter(lstrsql,con);<br />
DataSet objds=new DataSet();<br />
adp.Fill(objds); <br />
<br />
lst_emp.DataSource = objds.Tables[0].DefaultView<br />
cmbBookFrom.ValueMember = "emp_id"<br />
cmbBookFrom.DisplayMember = "txtval"

INSERT INTO SalesLogix.sysdba.ACCOUNT <br />
SELECT * <br />
FROM Doncaster4.salesLogix.sysdba.ACCOUNT AS DONCASTER<br />
WHERE NOT EXISTS(SELECT * FROM SalesLogix.sysdba.ACCOUNT AS HARTSHILL WHERE DONCASTER.ACCOUNTID = HARTSHILL.ACCOUNTID)

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