Interview Questions and Answers
SQL SERVER – 2008 – Interview Questions and Answers – Part 5
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download What command do we use to rename a db, a table and a column? To rename db sp_renamedb 'oldname' , 'newname' If someone is using db it will…
Read MoreSQL SERVER – 2008 – Interview Questions and Answers – Part 4
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 1) General Questions of SQL SERVER Which command using Query Analyzer will give you the version of SQL server and operating system? SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY…
Read MoreSQL SERVER – 2008 – Interview Questions and Answers – Part 3
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 1) General Questions of SQL SERVER 2) Common Questions Asked Which TCP/IP port does SQL Server run on? How can it be changed? SQL Server runs on port…
Read More
SQL SERVER – Interview Questions and Answers – Part 2
This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox
SQL SERVER – 2008 – Interview Questions and Answers – Part 1
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 1) General Questions of SQL SERVER What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships…
Read More
SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint
Primary key, Foreign Key and Default constraint are the 3 main constraints that need to be considered while creating tables or even after that. It seems very easy to apply these constraints but still we have some confusions and problems while implementing it. So I tried to write about these…
Read More