Latest Answer: Live table will be created using:
1.
Create table
(
column name datatype
)
2.
Select * into from
e-x: select * into new_emp from emp
Temp Table will be created using:
1.
Create table <#table name>
(
column name datatype
) ...
Latest Answer: 1. Select * from <database name>..<Table name> 2. Use <database name>
go ...
Latest Answer: Before knowing about Sybase transaction commit it is first essential to know about Sybase transaction. Sybase transaction is nothing but a number of SQL statements paced and handled between Sybase BEGIN TRANSACTION and Sybase COMMIT or ROLLBACK statement. ...
What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and In real time when we go to truncate the log?
Copies definitions for specified views, rules, defaults, triggers, procedures, or reports from a database to an operating system file or from an operating system file to a database.
Latest Answer: Defncopy is a sybase tool that defines the objective statements such views, triggers, defaults,rules and so on ...
Latest Answer: Let me clarify that while Sybase does not have "Object Tables" it can hold BLOBS in columns in tables. These can be of datatype TEXT or IMAGE.Sybase has the concept of Temporary tables in the form of #temp_tables or tables residing in the tempdb database.A ...
Latest Answer: Oracle has PL/SQL for stored procedures whereas Sybase uses T-SQL ...
How many defaults can be placed on one column of a able.If this col had an existing default, what will happen if one more is added?
Latest Answer: natural join is basically a form of equi join where one of the join fields is projected out. i.e. it avoids repeatition of the join column. ex:select pub.id,pub.name,au.*from publisher pub, author auwhere pub.id = au.id --- this query depicts a natural ...
View page << Previous 2 3 4 5 [6] 7 Next >>
Go Top
