explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

Can you use order by when defining a view?

0 Answers  

---

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

---

How do I find the query plan in sql server?

0 Answers  

---

What is the recommended total size of your memory optimized tables?

0 Answers  

---

How do you read transaction logs

1 Answers  

---

What is dirty read?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

what are the disadvantages of cursors? : Sql server database administration

0 Answers  

---

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

1 Answers   AllState,

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---