Answer / Babita Tiwari

A LEFT OUTER JOIN retrieves all records from the left table (the table listed first in the SQL statement), and matches them with records in the right table based on a specified column. If no match is found, NULL values are returned for the columns of the right table.

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1 Answers  

---

Which are new data types introduced in sql server 2008?

1 Answers  

---

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1 Answers  

---

How to configure and test odbc dsn settings?

1 Answers  

---

Please illustrate physical database architecture? : SQL Server Architecture

1 Answers  

---

How many types of functions are there in sql server?

1 Answers  

---

How many levels of sp nesting is possible?

1 Answers  

---

How do you simulate a deadlock for testing purposes

1 Answers  

---

Explain the truncate command? : SQL Server Architecture

1 Answers  

---

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

1 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

1 Answers   IGT,

---