sybase
Can I use MS SQL syntax in Sybase?
I have worked on SQL Server dat开发者_StackOverflow中文版abase. Now I have to work on a Sybase database (using a Squirrel client). This query is not working :[详细]
2023-02-13 15:56 分类:问答Sybase GUI Client
What are the available Sybase GUI 开发者_如何学Goclients for Windows. I have tried DBVisualizer and RazorSQL any other recommendations. Free preferredu can try \"Interactive SQL\" which shipped with[详细]
2023-02-11 01:53 分类:问答Oracle and Sybase compatibility for create table new_table as
I am trying to write an SQL query which needs to be compatible on both a Sybase and Oracle database. The query looks like the following :[详细]
2023-02-10 21:41 分类:问答How to update group records for one field with increment number in Sybase?
I have a temp table which has two columns: one is Name and another RecordNumber. They looks like below:[详细]
2023-02-10 17:45 分类:问答How is "select *" inside a stored procedure executed?
If you have a (Sybase) stored procedure that does \"select * from ... where ...\" how does that work? When is the * expanded to all the columns? At sproc creation time, at sproc compilation time, exec[详细]
2023-02-09 19:50 分类:问答Foreign Key from tables that exists in two different DBs on the same server
In Sybase, is it possible to create a a foreign key from a table in my ARCHIVE database to a Reference Table in my main Database?You can assum开发者_JAVA技巧e that the databases are both running on th[详细]
2023-02-09 06:55 分类:问答is there a way in sybase ase15 to set a value of a column when the row is updated
Basically what i want is a last_modified_datestamp 开发者_运维知识库column which is set to the date when the row was either inserted or updated.[详细]
2023-02-08 01:11 分类:问答How can I connect to Sybase using FreeTDS?
My freetds.conf # /usr/local/etc/freetds.conf #$Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $[详细]
2023-02-07 12:01 分类:问答Is there a way to communicate application context to a DB connection in non-Sybase DB servers (similar to set_appcontext in Sybase)?
Sybase has a way for the application to communicate \"context\" data - such as application\'s end-user name, etc.. - to the database connection session. Context data isbasically just a set of key-valu[详细]
2023-02-06 23:55 分类:问答Sybase 12: REGEXP search condition not understood
I\'m using Sybase 12.5.3, and want/need to do regex pattern matching. The Sybase help says that regex features have been there since version 11, but I cannot get anything to work.[详细]
2023-02-06 17:00 分类:问答