What is the difference between substr and charindex in the sql server?

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,

---

What is trigger explain with program?

0 Answers  

---

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

---

How to include text values in sql statements?

0 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

What is a sql join?

0 Answers  

---

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

0 Answers  

---

How many types of cursor type are there?

0 Answers  

---

What are the types of stored procedures in an sql server?

0 Answers  

---

How to create logins using windows Authentication mode?

2 Answers  

---

What are wait types?

0 Answers  

---