What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

What is local temp table?

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

What is the difference between cartesian product and cross join?

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---

Explain “not null constraint” in sql server?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

How can you append an identity column to a temporary table?

0 Answers  

---

can any one please send sql quries most used in applications.

2 Answers  

---

What is the use of floor function in sql server?

0 Answers  

---

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

0 Answers  

---