ya that question in sql server forums..post by me only

oh ok thanks..

shall i want to know..

how to alter a numeric column to identity in sql server

CREATE TRIGGER [LW_NO] ON dbo.dim_GEOGRAPHY

AFTER INSERT

AS

DECLARE @LW INT

SELECT @LW =MAX(GEOGRAPHY_sk)

FROM dbo.dim_GEOGRAPHY

UPDATE dbo.dim_GEOGRAPHY

SET GEOGRAPHY_sk = @LW + 1

from dim_geography

where geography_sk is null

ya friend so thanks i got that..thanks

hey i create trigger like this

CREATE TRIGGER [dim_geography_trigger]

ON dbo.dim_GEOGRAPHY

AFTER INSERT

AS

DECLARE @LW INT

SELECT @LW =MAX(GEOGRAPHY_sk)

FROM dbo.dim_GEOGRAPHY

UPDATE dbo.dim_GEOGRAPHY

SET GEOGRAPHY_sk = @LW + 1

this trigger will update all GEOGRAPHY_sk =GEOGRAPHY_sk+1 but i want...

hi,

By using trigger only i want increment by one..i wont use identity in my sk column

hey i create trigger like this

CREATE TRIGGER [dim_geography_trigger]

ON dbo.dim_GEOGRAPHY

AFTER INSERT

AS

DECLARE @LW INT

SELECT @LW =MAX(GEOGRAPHY_sk)

FROM dbo.dim_GEOGRAPHY

UPDATE dbo.dim_GEOGRAPHY

SET GEOGRAPHY_sk = @LW + 1

this trigger will update all GEOGRAPHY_sk =GEOGRAPHY_sk+1 but i...

thanks a lot..

my scenario..

i copied all tables from oracle db to sql db.. in oralce db by using trigger,

sequence auto generate to insert date to...

how to pass table value to variable in ssis

ya thanks for u r reply

ya ok but that is for sql server 2008 R2 version i am asking for sql server 2008 version only

512 mb