Database

steve_rm wrote:

Is there any method that I could use to detect if the database is current or not.

IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
              WHERE TABLE_NAME = 'MyTableName'
              AND COLUMN_NAME = 'ColumnName')
BEGIN
    -- Add the column we checked for
    ALTER TABLE ....
END

crazysanker wrote:

i used one trigger with 'instead of', but the pblm is T1 is not updated but values inserted to T2 perfromed fine.

INSERT INTO T1
    SELECT Field1,Field2,Field3
    FROM inserted

CREATE TRIGGER Trig_InsteadOfINS_T1 ON T1
INSTEAD OF INSERT
AS
--etc, etc.

CREATE TRIGGER Trig_INS_T1 ON T1
AS
--etc, etc.

SELECT Column_1, Column_2, Column_3, Column_4, Column_5, Column_6, Column_7, Column_8, Column_9, Column_10 FROM tblName

select ids.id,
(select top 1 column1 from mytesttable t2 where t2.id = IDs.id order by column1) as column1,
(select top 1 column2 from mytesttable t2 where t2.id = IDs.id order by column1) as column2,
(select top 1 column3 from mytesttable t2 where t2.id = IDs.id order by column1) as column3,
(select top 1 column1 from mytesttable t2 where t2.id = IDs.id order by column1 desc) as column4,
(select top 1 column2 from mytesttable t2 where t2.id = IDs.id order by column1 desc) as column5,
(select top 1 column3 from mytesttable t2 where t2.id = IDs.id order by column1 desc) as column6
from (select distinct id from mytesttable) as IDs