|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : Oracle has PL/SQL for stored procedures whereas Sybase uses T-SQL ... Read Answers (2) | Asked by : ramesh 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 ... Read Answers (2) | Asked by : Senthil 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. ... Latest Answer : 1. Select * from <database name>..<Table name> 2. Use <database name>
go ... 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 : Absolutely there are numerous features but most important are as follows1. Manages User Connection2. Enforces Business Rules3. Provide Recovery and BackUps4. Understand T-SQL5. Optimize Query Execution6. Maintain Databases with NO Redundancy7. Supports ... Latest Answer : Reports on permissions for database objects, users, groups, or roles. ... Latest Answer : Shutdown with wait - wait from other processes to be completed and then shutdown happens.if "shutdown with nowait" - is used then SQL Server immediately shutdown and back to OS promptHope this will help ... Latest Answer : Adaptive Server Enterprise is the relational database management software manufactured and sold by Sybase. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
