aspirantcoder.com
object_name | Aspirant Coder
http://aspirantcoder.com/tag/object_name
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Tag Archives: object name. Sybase : How to check programmatically if index contains particular column? May 9, 2013. So you’d like to check if a certain column is included in an index created on a table, that’s easy:. Index max rows per page. Unless you want to do that in a programmatic way, because parsing sp helpindex. Let’s check by looking at the sp helpindex source code:. Returns th...
aspirantcoder.com
SQL | Aspirant Coder
http://aspirantcoder.com/tag/sql
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Sybase : How to select random number within a specific range? December 24, 2012. Let’s say, I need a random number within a specific range, how do I do that? Here’s the code that will do it:. How to trace user activity to a file in SAP Sybase ASE. December 8, 2012. This video is a part of the SAP D&T Academy. Definitely worth checking out.). 8221; (opens pdf file in new window). Obvious...
aspirantcoder.com
Sybase | Aspirant Coder
http://aspirantcoder.com/category/sybase
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Sybase : How to check programmatically if index contains particular column? May 9, 2013. So you’d like to check if a certain column is included in an index created on a table, that’s easy:. Index max rows per page. Unless you want to do that in a programmatic way, because parsing sp helpindex. Unfortunately, there is no name of the column included in this table:. Returns the name of the...
aspirantcoder.com
stored procedure | Aspirant Coder
http://aspirantcoder.com/tag/stored-procedure
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Tag Archives: stored procedure. Sybase : How to disable return status when executing stored procedure? January 21, 2013. Let’s say I want to run a stored procedure in an isql session and then send the result set via mail:. Isql -S server -U username -P passwd 1 set nocount on 2 exec PSTEST 'F', 7 3 go x y - - - - - - - A 1 F 7 Z 9 (return status = 0). Set proc return status off. Sybase ...
aspirantcoder.com
statistics | Aspirant Coder
http://aspirantcoder.com/tag/statistics
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. How to trace user activity to a file in SAP Sybase ASE. December 8, 2012. Today, I’ve been checking if there are any videos on YouTube on Sybase ASE’s dbcc traceon usage and I’ve found this interesting video by Lester Leonares about a nice functionality to log user activity to a file:. This video is a part of the SAP D&T Academy. Definitely worth checking out.). Sybase : How to check pr...
aspirantcoder.com
index_col | Aspirant Coder
http://aspirantcoder.com/tag/index_col
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Tag Archives: index col. Sybase : How to check programmatically if index contains particular column? May 9, 2013. So you’d like to check if a certain column is included in an index created on a table, that’s easy:. Index max rows per page. Unless you want to do that in a programmatic way, because parsing sp helpindex. Unfortunately, there is no name of the column included in this table:.
aspirantcoder.com
random | Aspirant Coder
http://aspirantcoder.com/tag/random
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Sybase : How to select random number within a specific range? December 24, 2012. Let’s say, I need a random number within a specific range, how do I do that? Here’s the code that will do it:. Sybase : How to check programmatically if index contains particular column? Sybase : How to disable return status when executing stored procedure? Sybase Performance and Relational Database.
aspirantcoder.com
Sybase | Aspirant Coder
http://aspirantcoder.com/tag/sybase
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Sybase : How to check programmatically if index contains particular column? May 9, 2013. So you’d like to check if a certain column is included in an index created on a table, that’s easy:. Index max rows per page. Unless you want to do that in a programmatic way, because parsing sp helpindex. Unfortunately, there is no name of the column included in this table:. Returns the name of the...
aspirantcoder.com
Sybase : How to count number of rows in a table – demystified | Aspirant Coder
http://aspirantcoder.com/sybase-how-to-count-number-of-rows-in-a-table-demystified
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Sybase : How to count number of rows in a table – demystified. December 10, 2012. Today I’ve encountered a great forum post. Explaining how to count the number of rows in a table “the right way” by Derek Asirvadem. So, it’s not:. SELECT COUNT(*) FROM mytable. It is not even:. SELECT COUNT(1) FROM mytable. Can be slightly better by hinting the usage of an index:. The right way is to do:.
aspirantcoder.com
admin | Aspirant Coder
http://aspirantcoder.com/author/admin
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Sybase : How to check programmatically if index contains particular column? May 9, 2013. So you’d like to check if a certain column is included in an index created on a table, that’s easy:. Index max rows per page. Unless you want to do that in a programmatic way, because parsing sp helpindex. Unfortunately, there is no name of the column included in this table:. Returns the name of the...
