Welcome, Guest Ohm namah shivoy
www.faqpanel.com
Home | ASP.Net | C-Sharp | Winforms | MS SQL | AJAX | XML | .Net Training*** | Search
Invite friends 
Extras 
VS Tips & Tricks
Top 10 .Net Tools
Special folders in ASP.Net
VS Find Combobox
 ASP.Net Interview Questions and Answers
What is a View in SQL Server?
A View is something like a virtual table in SQL Server. A view is used just like a table, except that it does not contains any data of its own. Instead, a view is merely a preplanned mapping and representations of the data stored in tables. The plan is stored in the database in the form of query. This query calls for data from some, but not necessarily all, columns to be retrieved from one or more tables.
What are the benefits of using Stored Procedures in SQL Server?
OR
Why should we use Stored Procedures?
What are the Stored procedures (sprocs) in SQL Server?
Explain an outer join?
Which operator tests column for the absence of data in SQL Server?
Define candidate key, alternate key, composite key.
Is it possible to create only structure of the table without copying data in SQL Server?
What is an execution plan? When would you use it? How would you view the execution plan?
What is DTS (Data Transformation Services) in SQL Server?
Which command is used to get back the privileges offered by the GRANT command in SQL Server?
TRUNCATE TABLE EMP;, DELETE FROM EMP; -What Will the outputs of the above two commands (Queries) in SQL Server?