SEO

#1 (**permalink**) 02-29-2008, 06:40 PM

hi,
i am a beginner to ms sql server2000
i have a table
create table ddd (a int, b int)
by table structure is a b
now when i enter a value in b column suppose '2' in column b
bext time when i insert a value in the column a i have to get the value
in b as 3 is thi spossible with triggers

insert into gdg values (1,2)
a b
1 2
insert into gdg (a) values(2)
a b
2 3----------------> i have to get this 3 automatically

is there any method to get this

pls help me

satish

#2 (**permalink**) 02-29-2008, 06:40 PM

You could try

DECLARE @lastNum INT
SET @lastNum = (SELECT TOP 1 ISNULL(b,0) + 1 FROM ddd ORDER BY b DESC)
insert into ddd (a,b)
values(2,@lastNum)

--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm

"satish" <satishkumar.gourabathina@gmail.com> wrote in message
news:1141969999.103702.215120@v46g2000cwv.googlegr oups.com...
> hi,
> i am a beginner to ms sql server2000
> i have a table
> create table ddd (a int, b int)
> by table structure is a b
> now when i enter a value in b column suppose '2' in column b
> bext time when i insert a value in the column a i have to get the value
> in b as 3 is thi spossible with triggers
>
> insert into gdg values (1,2)
> a b
> 1 2
> insert into gdg (a) values(2)
> a b
> 2 3----------------> i have to get this 3 automatically
>
> is there any method to get this
>
> pls help me
>
> satish
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

can i increment the column (c1+2) ---by creating the trigger