https://www.sqlines.com/ 2026-06-10T23:34:30+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2018-05-30T18:00:32+00:00 https://www.sqlines.com/sybase/get_default_character_set?rev=1527703232&do=diff In Sybase ASE you can use sp_helpsort system procedure to get the information about the default character set: Sybase ASE: -- Get the default character set sp_helpsort Sample result (Multiple result sets): Character Set = 3, cp437 Code Page 437, (United States) character set. Sort Order = 50, bin_cp437 Binary Sort Order for Code Page 437 (cp437). For more information, see: text/html 2012-10-27T22:05:02+00:00 https://www.sqlines.com/sybase/insert_n_rows_commit_after_m_rows?rev=1351375502&do=diff It can be useful to test the performance of Sybase Adaptive Server Enterprise (ASE) by inserting a large number of rows with dummy data into a test table. Let's create a Transact-SQL script to do that. Sybase Transact-SQL Script First let's create a test table: text/html 2018-01-02T19:29:58+00:00 https://www.sqlines.com/sybase/procedure_text?rev=1514921398&do=diff In Sybase ASE you can use sp_helptext system procedure to output the source code of a stored procedure: Sybase ASE: -- Specify the name of your procedure sp_helptext showOrdersSummary Result (2 result sets): # Lines of Text 3 text CREATE OR REPLACE PROCEDURE showOrdersSummary ... SELECT @region_out ... CLOSE cur2 DEALLOCATE cur2 ... sp_help_text returns 2 results set, one showing the number of lines in the stored procedure, another is actual text in chunks of 255 characters pe…