Showing posts with label SQL Server. Show all posts

SQL Server

SQL Server interview questions & Answers Set 11

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 ...