Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between Delete and Truncate command in SQL
- 0 Answers
- 1199 Views
- BirlaSoft, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Mention the differences between having and where clause.
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
How to execute stored procedure and set temp table in sql server?
Explain what are magic tables in sql server?
can you any body tell me why are go for the rebuild the master database.what is the reason?
How many triggers are possible per table?
Explain the difference between control flow and data flow?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is a print index?
In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
How to compare the top two records using sql?
what is the purpose of creating view is sql server 2000
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
