SQL Server

Which TCP/IP port does SQL Server run on? SQL Server runs on port 1433 but we can also change it for better security   From where c...

What is a view? In view, we can create virtual table with the columns from different tables by relation between them, we can use this vi...

What's the purpose of Stored Procedure? Stored Procedures has some advantages that’s why we use SP. some advantages are: (1) Stored...

                                         Is it possible to create tables in stored procedures using a variable for the table name? create...

What is the Difference between 'Count' and ‘Count(*)'? 'Count': Counts the number of non-null values. ‘Count (*)...

How do SQL server 2000 and XML linked? It’s linked in so many ways. To generate the output in xml format to load the XML data into SQL Ser...

SQL Server interview questions & Answers What is data integrity? Explain constraints? A constraint is a property assigned to a column ...

What is De-normalization and when do you do it? As the name indicates, de-normalization is the reverse process of normalization. It's...

What is the STUFF function and how does it differ from the REPLACE function? STUFF - Delete a specified length of characters and insert ...

How to get the automatic backu p of the database in the SQL   server? This how to will show you to how to   create a maintenance plan that ...

SQL Server Interview Question and Answer Set1 What are the four main query statements? The main four query statements are:- (a) SELECT  (...