How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

---

Does a sql server 2005 select statement require a from?

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,

---

Can you get second highest salary from the table?

0 Answers   QuestPond,

---

How to loop through result set objects using mssql_fetch_array()?

0 Answers  

---

---

What are the different authentication modes in sql server?

0 Answers  

---

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

---

How do I create a partition table in sql server?

0 Answers  

---

Which is faster statement or preparedstatement?

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

how to rename the table

3 Answers  

---

What are the differences between stored procedure and view in sql server?

0 Answers  

---