SEO

#1 (**permalink**) 04-08-2008, 06:01 PM

I'm trying to dynamically create a series of rows. For example, rows
with just values 1 through 5. I can think of how this can be done in
Oracle:

select rownum from employees where rownum <= 5

which will give me:
rownum
-------
1
2
3
4
5

Is there a way to do this in Sybase?

Onassis

#2 (**permalink**) 04-08-2008, 06:01 PM

Hi ,

You canuse the idenity column feature of the ASE ( sybase ).
all that you hvae to do it is declare one of the the field to be
identity column. It will generate the sequence number.
Read the sybase manuals at manuals.sybase.com/as.htmt for the identity
columsn .
Still you have then i will be send you how to do that .
( I would suggest you to read the feature which help you in future ).

Regards
Navneet

ocayetano@gmail.com wrote:
> I'm trying to dynamically create a series of rows. For example, rows
> with just values 1 through 5. I can think of how this can be done in
> Oracle:
>
> select rownum from employees where rownum <= 5
>
> which will give me:
> rownum
> -------
> 1
> 2
> 3
> 4
> 5
>
> Is there a way to do this in Sybase?
>
> Onassis

#3 (**permalink**) 04-08-2008, 06:02 PM

If you don't wish to use an identity column:
Create table #temp ( rownum int, textcol varchar (25))
declare @C int
select @C = 0
while @C < 5
begin
select @C = @C + 1
insert #temp values (@C, 'any value')
end

#4 (**permalink**) 04-08-2008, 06:02 PM

Thanks to both suggestions. Both will work for me.

Onassis

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

SEO

Creating fake rows