SYBASE: sybase Basics
(1) Historical versions of sybase;
Sybase server 1.0 2.0, Sybase openclient/openserver, Sybase system 10, sybase replication server, Sybase SQL server 11.0, Sybase ase 11.5, Sybase ase 11.9.2, ase 11.9.3, ase 12.0, ase 12.5,
(1) The historical version of Sybase;Sybase Server 1.0 2.0, Sybase openclient/openserver, Sybase system, Sybase replication Server,sybase SQL Server 11.0, S Ybase ASE 11.5, Sybase ASE 11.9.2, ASE 11.9.3, ASE 12.0, ASE 12.5, ASE 15.5, ASE 15.7.(2)
Sybase configuration Parameters sp_configure ' max online engines ', 4
Go
--Configure the number of boot CPUs
sp_configure ' number of engines at startup ', 4
Go
--Configure Maximum memory count
sp_configure ' max memory ', 2097151
Go
--Allocating
Abstr]
"Sybase database does not support subqueries, so ......", We often hear this in database development. Is Sybase really true? Let's go to the sybase database to see which subquery statements are supported and not supported respectively. Hope
Q: How does SQL server access the table of the sybase database?
A: The specific method is as follows:
1: Install the Sybase Client
Version requirements:
Sybase client 11.9.2 for NT
1.1: After the installation is complete, start
The first lecture on Sybase basic knowledge
First, customer/server architecture
Second, the basic process of accessing Sybase server
Three, Sybase product overview
Iv. main contents of Sybase SQL Server
V. Sybase installation and Configuration
Q: How should SQL Server access the tables of the Sybase database?
Answer: The specific method is as follows:
1: Install Sybase client
Requirements for version:
Sybase Client 11.9.2 for NT
1.1: After the installation completes, runs starts->
Sybase basic Knowledge
Client/server architecture: Sybase is a database management system built on a client/server architecture.
From a hardware standpoint, a client/server architecture is the allocation of a task between two or more machines,
Q: There is a question about Sybase: I open the database always remind: Cannot open transaction log file-----cannot use log file "Hms2000.log" since it is shorter than experted. I directly deleted the log, also can not start normally, said the file
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.