Interested to Buy Any Domain ? << Click Here >> for more details...
List the ways in which dynamic sql can be executed?
- 0 Answers
- 1057 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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 drop existing indexes in ms sql server?
Explain “@@rowcount” and “@@error” in sql server?
What is the difference between createstatement and preparedstatement?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
How to change the system date and time from SQL Plus Terminal ?
What is Trace flag?
Are connections to sql server encrypted?
Explain some DBCC commands?
How to skip remaining statements in a loop block using continue statements?
How to override dml statements with triggers?
Explain what are the different index configurations a table can have?
-
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)
