December 4, 2008 10:41pm pst

1. chapmandew 2,492,866
2. angelIII 2,311,810
3. mark_wills 745,570
4. aneeshatti... 623,069
5. BrandonG... 548,950
6. ScottPletc... 523,767
7. EugeneZ 393,777
8. acperkins 380,843
9. ee_rlee 353,240
10. dtodd 349,319
11. momi_sa... 296,832
12. mwvisa1 276,442
13. matthews... 259,351
14. cs97jjm3 245,703
15. appari 191,167
16. nmcdermaid 185,708
17. dqmq 175,308
18. rickchild 174,460
19. Zberteoc 170,438
20. MohammedU 169,998
21. brejk 169,574
22. dportas 162,055
23. Thomasian 153,702
24. jimpen 149,280
25. DanielWilson 142,230

1. angelIII 11,268,223
2. aneeshatti... 4,680,948
3. acperkins 4,369,303
4. ScottPletc... 4,337,819
5. chapmandew 2,492,866
6. arbert 2,245,195
7. Lowfatsp... 2,174,384
8. EugeneZ 1,669,939
9. imran_fast 1,484,261
10. rafrancisco 1,460,132
11. Hilaire 1,221,775
12. nmcdermaid 1,170,292
13. Nightman 1,148,504
14. Mr_Peer... 1,087,815
15. ptjcb 1,074,620
16. bhess1 1,073,837
17. dtodd 935,662
18. adathelad 793,208
19. matthews... 781,683
20. appari 778,404
21. Sirees 776,352
22. mark_wills 745,570
23. BriCrowe 722,959
24. amit_g 683,229
25. BrandonG... 646,746

10.13.2008 at 08:43AM PDT, ID: 23809817 | Points: 250

	[x] Attachment Details

Create Trigger autonumber

Asked by chirpl_chirpl in MS SQL Server, SQL Server 2005

Hi,
I've this table TAB1:

COD_ID............NAME........DESCRIP

I'd like to create a trigger that when I insert a new record into table TAB1 I get the value of column COD_ID = NAME_0000000001......NAME_0000000002.............NAME_0000000003............NAME_0000000010................(NAME underscore 10byte autonumber)

for example:

INSERT INTO TAB1 (NAME, DESCRIP)
VALUES ('AAA', 'THIS IS EXAMPLE');

select *
from tab1;

COD_ID....................NAME............DESCRIP
AAA_0000000001.........AAA...........THIS IS EXAMPLE

INSERT INTO TAB1 (NAME, DESCRIP)
VALUES ('BBB', 'THIS IS EXAMPLE2');

select *
from tab1;

COD_ID....................NAME............DESCRIP
AAA_0000000001.........AAA...........THIS IS EXAMPLE
BBB_0000000002.........BBB...........THIS IS EXAMPLE2

INSERT INTO TAB1 (NAME, DESCRIP)
VALUES ('XXX', 'THIS IS EXAMPLE3');

select *
from tab1;

COD_ID....................NAME............DESCRIP
AAA_0000000001........AAA...........THIS IS EXAMPLE
BBB_0000000002.........BBB...........THIS IS EXAMPLE2
XXX_0000000003........XXX...........THIS IS EXAMPLE3

INSERT INTO TAB1 (NAME, DESCRIP)
VALUES ('CCC', 'THIS IS EXAMPLE4');

select *
from tab1;

COD_ID....................NAME............DESCRIP
AAA_0000000001........AAA...........THIS IS EXAMPLE
BBB_0000000002.........BBB...........THIS IS EXAMPLE2
XXX_0000000003........XXX...........THIS IS EXAMPLE3
CCC_0000000004........CCC...........THIS IS EXAMPLE4
.......................................................................................
.......................................................................................
.......................................................................................
.......................................................................................
.......................................................................................
.......................................................................................

How can I write this trigger to get my output??

Thanks in advance!Start Free Trial

Keywords: Create Trigger autonumber

	Title
1	Retrieve Autonumber after Add Record…
2	AutoNumber
3	rec.AddNew and AutoNumber
4	Formating Autonumber
5	Identity column (Autonumber) should…
6	autonumber

Loading Advertisement...

20081112-EE-VQP-42 / EE_QW_2_20070628