sybase

相关标签：javascript jquery android 多少钱 iPhone

Performance of different approaches to time-based data

I\'m asking this in the context of PerformanceDBA\'s claim in this answer to another question that this query:[详细]

2023-01-29 01:03 分类：问答
sybase sql update where record equal to another record

I have a table that looks like the following: userId | level| ------------------- snoop| 10| foo| 0|[详细]

2023-01-28 22:48 分类：问答
Simple query for generating database metrics?

Give a database (Sybase) with many tables, I would like to write a SQL query that will c开发者_JS百科alculate, for each table, the number of rows and the number of columns.[详细]

2023-01-27 00:03 分类：问答
Foreign Key constraint violation with bidirectional one-to-one relationship with shared primary key

I am trying to create with JPA a one-to-one association between two classes, one being the parent, and the other the child, with a generator to make sure they have the same primary key:[详细]

2023-01-26 21:56 分类：问答
Suppress reorg rebuild sysmessages in sybase stored proc

I have a stored procedure in Sybase that uses reorg rebuild statement in a loop for all the tables in my database. What I want to do is to suppress the reorg rebuild sysmessages for tables that succed[详细]

2023-01-26 16:53 分类：问答
Forcing multiple tables to have the same columns in a database

Brief: I\'m fairly new to databases and currently have one with two tables for a checker type script. Is there a way to ensure that both tables use the same types of columns? This database is in Sybas[详细]

2023-01-25 13:42 分类：问答
counting number of lines of a text file in a stored procedure

I need to open and count the number of lines in a text file using a stored 开发者_开发技巧procedure. The stored procedure should return a value whenever executed. Can you help me?In Sybase it is simpl[详细]

2023-01-24 17:58 分类：问答
MS Access hangs when comparing 2 link tables

I have 2 link tables in a MS Access database. One of the link tables links to a table in a Sybase database and the other links to a SQL Server database.[详细]

2023-01-24 05:43 分类：问答
c# and Sybase. Error when creating many tables

In C# I run a massive create table script in Sybase and my program hangs after around 47 create table statements run. I send the statements开发者_JS百科 to the database one at a time and dispose of my[详细]

2023-01-23 21:12 分类：问答
Limiting results in a SQL query based on distinctness in an arbitrary column

I need to write a SQL query that pulls from a table that stores records for each time one of our salespeople speaks to a client. The relevant columns are: (1) the salesperson\'s employee ID, (2) the c[详细]

2023-01-23 20:39 分类：问答