Answer / candorz

BEGIN TRANSACTION
GO
BEGIN TRANSACTION
INSERT INTO [JSSKDB].[dbo].[JobsDb_Countries]
([CountryName])
VALUES
('something')
GO
COMMIT
GO
BEGIN TRANSACTION
INSERT INTO [JSSKDB].[dbo].[JobsDb_Countries]
([CountryName])
VALUES
('something1')
ROLLBACK
GO


For the above transaction the rollback will undo any changes made by the previous sub-transaction i.e. no change will be seen in the DB

How to execute the cursor queries with "open" statements?

0 Answers  

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

What do you mean by normalisation?

0 Answers  

---

What is the difference between char and varchar2 datatype in sql?

0 Answers  

---

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

---

How to get a list of columns in a view using the "sp_help" stored procedure?

0 Answers  

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

What is a transaction and why is it important?

0 Answers  

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

What is merge?

0 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---