|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Identity And Select Top x
in MSQ i have this stuff to play
Select Top "x" From Database, when "X" is the number of records i wan´t to get back from the DB. How can i do something similar in Firebird ? In SQL i can make a Stored Proc. like this. Insert Into "Table" (Name, Adress) Values ("Diego","Wall Street") Set @outpout_parameter = @@Identity How can i get the Auto Id in Firebird ? |
|
#2
|
||||
|
||||
|
Quote:
for top x you can use "select first 10 * from employee" and for identity read about generators http://www.firebirdsql.org/index.php?op=faq#q00111.dat Last edited by mariuz : January 8th, 2005 at 04:11 PM. |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Identity And Select Top x |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|