The following code is supposed to print all rows contained in the temporary table #table_A: However, it results in the following error message: How can I print all rows contained in a (temporary) table? Here’s another way of putting my question: I’m trying to do something like that: Is there a way to declare a variable containing a whole row
Tag: sap-ase
Sybase ASE 15 Aggregate Function for strings
I’am findind a way to aggregate strings from differents rows into a single row in sybase ASE 15. Like this: Something like FOR XML PATH in T-SQL. Thanks! Answer Sybase ASE does not have any string aggregate functions like list() or group_concat(); and while there is some support for FOR XML, it does not include support for the PATH option/feature.
How can SELECT COUNT(*) different from count of all records in the table?
So I have a table: SELECT COUNT(*) returns a different value than SELECT DISTINCT COUNT(*). How can this be possible? I also tried which returned the same count as the distinct query. I can’t see how with a primary key and all fields being NOT NULL, there can be a different total count than the count of unique records. BTW,