advantage-database-server
What is the role of the ADSSYS user automatically created in an Advantage data dictionary?
When creating a data dictionary in Advantage Database Server (Sybase), the system automatically creates a user named ADSSYS开发者_高级运维. What\'s the role of this user, and can we remove it from our[详细]
2023-03-03 05:27 分类:问答Advantage .NET Data Provider fails in an SSIS package?
I have installed the Advant开发者_StackOverflow社区age .NET Data Provider Release 9.0 for Windows[详细]
2023-02-27 10:33 分类:问答How can I join an Advantage ADT table to a DBF table in a single query?
How can I join an Advantage ADT table to a DBF table in a single query? 开发者_如何转开发Create and use data dictionary.If the tables are both in a data dictionary, then you can join them just fine.[详细]
2023-02-23 17:51 分类:问答Create ERD for Advantage Database Server 10
I need to create 开发者_StackOverflowan ERD for an ADS 10 database. Reverese Engineering would be nice, since the database already exists.[详细]
2023-02-22 16:01 分类:问答Sql trigger to save changes to an audit trail table
I started on an ADS sql table trigger to store changes done on one particular table.Here is the idea:[详细]
2023-02-21 18:35 分类:问答Splitting a String into rows
I have a table with a field consisting of multiple strings seperated by a \'+\'. Each part of the string has a length of either 2 or 3 chars. Example: \'ab+cde+fg\'.[详细]
2023-02-18 04:07 分类:问答invalid date dd/mm/ccyy
I want to use dd/MM/yyyy throughout my .net application, but when i pass the sql to the .net provider it throughs invalid date error.[详细]
2023-02-16 04:54 分类:问答Problems in backups after changed the passwords
Here I am with another problem with the backups. Since my company decided to change the passwords of all of our clients[详细]
2023-02-14 20:35 分类:问答Problem making a Data Base Backup with the sp_BackupDataBase procedure
hope you all are O.k! I have this problem with the sp_BackupDateBase procedure. According with the Advantage documentation, I can make a Backup of my Data base,[详细]
2023-02-12 22:40 分类:问答What is the most efficient SQL statement to create running totals in Advantage SQL
I would like to create a running total query statement in Advantage SQL and wonder what is the most efficient way.I am able to get the data with a query like this:[详细]
2023-02-11 22:05 分类:问答
加载中,请稍侯......