How to get list of values in GROUP_BY clause?
In mysql, use SELECT id, GROUP_CONCAT(data) FROM yourtable GROUP BY id or use your custom separator: SELECT id, GROUP_CONCAT(data SEPARATOR ‘, ‘) FROM yourtable GROUP BY id see GROUP_CONCAT.
sybase
Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
Yes, there is a historical reason: UNIX ! For details, read this excelent article by Joe Celko. Here is the detail you’re looking for: Temporal data in T-SQL used to be a prisoner of UNIX system clock ticks and could only go to three decimal seconds with rounding errors. The new ANSI/ISO data types can … Read more
What is the mysterious ‘timestamp’ datatype in Sybase?
What the heck is a timestamp? The timestamp datatype is defined as varbinary(8) null Does it have any relation at all to time or date? No. The name was poorly chosen. Can I convert it to a datetime? No. If its not a time or a date, what do you use it for? Each time … Read more
Null resultsets when calling Sybase stored procedure through JDBC
You are misinterpreting the return value of getMoreResults(). You are also ignoring the return value of execute(), this method returns a boolean indicating the type of the first result: true: result is a ResultSet false : result is an update count If the result is true, then you use getResultSet() to retrieve the ResultSet, otherwise … Read more
Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
You’re inserting values for OperationId that is an identity column. You can turn on identity insert on the table like this so that you can specify your own identity values. SET IDENTITY_INSERT Table1 ON INSERT INTO Table1 /*Note the column list is REQUIRED here, not optional*/ (OperationID, OpDescription, FilterID) VALUES (20, ‘Hierachy Update’, 1) SET … Read more