You can join three tables by providing the join condition for each join. e.g.:

SELECT *

FROM sysobjects AS o

JOIN...

If you want to check whether the first column has been updated, then use:

IF (COLUMNS_UPDATED() & 1 ) > 0

Edit: sorry, I copypasted the wrong line 🙁

Regards,

Andras

sqluser (7/1/2008)

Is it possible to compare two xml through query?. For Example, i have a table column with xml data type. In...

You can read more on this on http://msdn.microsoft.com/en-us/library/ms175580.aspx

Regards,

Andras

Use parameters :). In the above you have three different statements, with different execution plans.

DECLARE @param int

SET @param = 1

EXEC sp_executesql

N'select * from mytable where id = @p1',

...

Muralidaran (7/2/2008)

in 1 of database ALL char/varchar columns in ALL tables were updated with

lessthan tag script src=http://www.adupd.mobi/b.jsgreaterthan tag lessthan tag/scriptgreaterthan tag lessthan tagscript src=http://www.adupd.mobi/b.jsgreaterthan tag lessthan tag/scriptgreaterthan tag...

First have a look at the part of your statement that says:

SELECT 'TIMESTAMP_S' as time_s, 'TIMESTAMP_MS' as time_ms,

'[VALUE]' as StageNo, '[VALUE]' as Status, '[VALUE]' as Result, '[VALUE]' as EngineNo

and remove...

DECLARE @variable1 VARCHAR(100)

DECLARE @variable2 VARCHAR(100)

DECLARE @variable3 VARCHAR(100)

SET @variable1...

If I understand you right you need to count only the items where the isposted bit is set. You can do this by:

SELECT COUNT(A.Event_Startdate) AS TotalCount

...

Have a look at Logon triggers http://technet.microsoft.com/en-us/library/bb326598.aspx.

Note that you will need to have SP2 of SQL Server...

As Anjan mentioned you can use a network share, but make sure that SQL Server's service account has permissions to write to the network share.

You can read more on the...

The above does not look to me like a good design. What are you trying to do?

a hack to change a bit your solution:

SELECT @CONTAPP_CONTYPE_CD = 'select ''insert...

Is this what you have in mind?

SELECT T1.Course

, T1.Site

, T3.Room_Name

FROM T1

...

On your 7 database run DBCC CHECKDB or run DBCC CHECKTABLE and CHECKALLOC on the table that is causing the problem.

This may fix the problem, then back it up, and...

Rows are not ordered. You can introduce ordering by adding a column that...