Database

Tridip Bhattacharjee wrote:

please provide me good information about various locking mechanism

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

INSERT INTO Table1 (Column1, Column2)
VALUES (@Value1, @Value2);

INSERT INTO Table1 (Column1, Column2)
SELECT Column1, Column2 FROM Table2
WHERE Column1 = @Parameter;

INSERT INTO Table1 (Column1, Column2)
SELECT t2.Column1, t3.Column2 FROM Table2 AS t2
INNER JOIN Table3 AS t3 ON t2.ColumnID = t3.ColumnID
WHERE t2.Column1 = @Parameter;

SELECT TOP(1) * FROM (
SELECT TOP(2) StartTime FROM dbo.RunSummary ORDER BY StartTime DESC
) T ORDER BY StartTime

Syafiqah Zahirah wrote:

what can I do?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

select max(Actuators.Date)
from table1
where Actuators.Date<(select max(Actuaors.Date) from t1);

AshwiniSH wrote:

Can anyone please provide me the connection string?

AshwiniSH wrote:

1. domain is created in my server.
2. Remote access is enabled for the sql server
3. TCP/IP port is also enabled.

From link[^]:

Basically, when you failed to connect to your SQL Server, the issue could be:
1) Network issue,
2) SQL Server configuration issue.
3) Firewall issue,
4) Client driver issue,
5) Application configuration issue.
6) Authentication and logon issue.

AshwiniSH wrote:

I am struggling for this since 3 days.