Here's what we came up with.
1>use database
2>go
1> set rowcount 10
2> go
1> select * from table where ID='XXXXX'
2> go
Reset to default definition.
1> set rowcount 0
2> go
This blog covers Unix system administration HOWTO tips for using inline for loops, find command, Unix scripting, configuration, SQL, various Unix-based tools, and command line interface syntax. The Unix OS supports tasks such as running hardware, device drivers, peripherals and third party applications. Share tips/comments. Read the comments. But most importantly: Read Disclaimer - Read Disclaimer.
Here's what we came up with.
1>use database
2>go
1> set rowcount 10
2> go
1> select * from table where ID='XXXXX'
2> go
Reset to default definition.
1> set rowcount 0
2> go
2 comments:
When you upgrade to ASE 12.5, you can use top N. For example:
select top 10 * from my_table
Thanks Jason for the heads-up. We will be upgrading next week to 12.5.
Also, I like 12.5's syntax a lot better for this particular task.
Post a Comment