Compiled objects
A compiled object is any object that requires entries in the sysprocedures table, these include Check constraints,Defaults,Rules,Stored Procedures,Triggers,Views, FunctionsString concatenation operator
The string operator + can concatenate two or more character or binary expressions. For example:
select Name = (au_lname + ", " + au_fname)
from authors
Quotation marks
There are two ways to specify literal quotes within a char or varchar entry.
The first method is to use an additional quote with a quote of the same type.
- 'I don''t understand.'
- 'George said, "There must be a better way."'
- "Isn't there a better way?"
A stored procedure is a collection of SQL statements and optional control-of-flow statements stored under a name.
A trigger is a stored procedure that instructs the system to take one or more actions when a specific change is attempted. Triggers can nest to a depth of 16 levels.
A default is a value linked to a particular column or datatype, and inserted by the system if no value is provided during data entry.
Rules are user-defined integrity constraints linked to a particular column or datatype, and enforced at data entry time.
parseonly, noexec, prefetch, showplan, rowcount, nocount, and tablecount control the way a query is executed. The statistics options display performance statistics after each query. flushmessage determines when Adaptive Server returns messages to the user.
Comments
Two types:
--comment
/* MultilineComment*/
isql utility
You can use Transact-SQL directly from the operating system with the standalone utility program isql.
isql -S server_name -D database_name -U user_name -P password
1>
You can now start issuing Transact-SQL commands.
Default databases
When your Adaptive Server account was created, you may have been assigned a default database to which you are connected when you log in. If you were not assigned a default database, you are connected to the master database. To change your default database, use sp_modifylogin.
Example 1
Changes the default database for “sarah” to pubs2:
sp_modifylogin sarah, defdb, "pubs2"
https://goodpress489.wordpress.com/2017/05/27/how-to-setup-table-level-replication-in-sap-sybase-ase-step-by-step-table-level-replication-sybase-ase-15-7/
ReplyDeletehow to install sybase database . can u please guide me. im new to sybase data base.
ReplyDelete