Top "Sybase" questions

How to escape single quotes in Sybase

I come from MySQL and the below query doesn't work in Sybase. How should I escape single quotes? UPDATE Animals …

sql sybase

How to delete duplicate rows in sybase, when you have no unique key?

Yes, you can find similar questions numerous times, but: the most elegant solutions posted here, work for SQL Server, but …

sql sybase duplicate-removal sqlanywhere

How do I execute different SELECT statements based on a CASE

I am facing a problem in executing queries with CASE statement. Based on my condition,(for eg. length), I want …

sql sybase case

PDO To Connect to MSSQL Over MSSQL_* Functions

There is a range of mssql_* Which are not in the depreciation process. They work the same as mysql_* functions; …

php database sybase

A way to check if the temporary table exists or not

I have this following query : IF NOT EXISTS (SELECT 1 FROM sysobjects WHERE id = Object_id('tempdb..TEMP_THETH_DETAILS')) EXECUTE ( …

sybase sap-ase

How can I escape single and double quotes in SQL prepared statement?

I have a SQL statement similar to the one shown below in Perl: my $sql="abc..TableName '$a','$…

sql perl string sybase quotes

SQL - Returning distinct row for data with Max created timestamp value

Within my program, I audit incoming data, which can be of 4 types. If the data meets all required criteria, it …

sql database sybase

Sybase, execute string as sql query

In Sybase SQL, I would like to execute a String containing SQL. I would expect something like this to work …

string sybase execute

How do I update multiple columns with a subquery in a single statement?

I am attempting to update a temp table from a source table: UPDATE #DETAIL SET EXCD_ID, CDOR_OR_AMT, …

sql sybase

Pivoting in Sybase SQL Query?

I am looking for a way to pivot the following results... ID | Group_Level | Group_Values 1 | Division | Value 1 2 | Department | Value 2 3 | …

sql sybase pivot