Answer / Vicky Jaiswal

"In SQL Server, a transaction goes through four distinct phases: 1) Beginning Transaction: The transaction is initiated. 2) Execution: The database operations are executed within the transaction. 3) Commit: The transaction is completed and the changes are made permanent in the database. 4) Rollback: If an error occurs during the transaction, it can be rolled back to restore the database to its previous state."

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1 Answers  

---

How to use group functions in the select clause in ms sql server?

1 Answers  

---

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

---

How to select some specific rows from a table in ms sql server?

1 Answers  

---

How to change the ownership of a schema in ms sql server?

1 Answers  

---

Can we write trigger for view?

1 Answers  

---

What is the query and subquery?

1 Answers  

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1 Answers  

---

What are 3 ways to get a count of the number of records in a table?

1 Answers  

---

Explain the concepts and capabilities of sql server?

1 Answers  

---

Can we use custom code in ssrs?

1 Answers  

---

Define outer join in sql server joins?

1 Answers  

---