Database

SELECT 
    CASE
        WHEN OD_STOCK_CODE LIKE '%BUPN%' THEN (([OD_UNITCST]*0.7)*[OD_QTYORD])
        ELSE 0
    END AS BOXDisc
FROM
    WhateverTable

UPDATE customer<br />
SET [name] = @newname<br />
WHERE [id] = @id<br />
AND [rowversion] = @timestamp  <-- timestamp value

cbhkenshin wrote:

what sholud i change only the connection string so that it will work over lan and for more than one user.

Server=MyServerMachine

Server=MyServerMachine\NamedInstance

SELECT COUNT(*) FROM user<br />
WHERE username = 'user' AND pass = PASSWORD('pass')

Select A.Flds , B.Flds From Server1.db1.dbo.Table1 A<br />
Inner Join Server1.db2.dbo.Table1 B A.Fld = B.Fld

dansoft wrote:

in which format the user have to input the date in asp.net?

SqlCommand cmd = new SqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = "SELECT * FROM MyTable "+
    "WHERE SomeDate BETWEEN @startDate AND @endDate";
cmd.Parameters.Add("@startDate", theStartDateTimeObject);
cmd.Parameters.Add("@endDate", theEndDateTimeObject);
SqlDataReader reader = cmd.ExecuteDataReader();