Without Book Interview Questions and Answers | Online Test | Moct Test
Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Institute Training Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

MSSQL Interview Questions and Answers

Ques 11. How to download and install Microsoft SQL Server Management Studio Express?

Ans. Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. If you want to download and install it to your system, follow this tutorial:

1. Go to SQL Server Management Studio Express home page.

2. Go to the "Files in This Download" section.

3. Click the Download button next to "SQLServer2005_SSMSEE.msi - 38.5 MB" And save it to c:temp directory.

4. Look at and compare the downloaded file properties with:

Name: SQLServer2005_SSMSEE.msi
Location: C:temp
Size: 40,364,032 bytes

5. Double click to install. The setup window shows up. Follow the instructions to finish the installation process.

6. When installation is done, you will see a new program menu entry as: Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express

Is it helpful? Add Comment View Comments
Ques 12. How to download and install SQL Server 2005 Books Online?
Ans. 1. Go to the SQL Server 2005 Books Online download page.

2. Click the download button, the File Download box shows up. Save the download file to c:temp.

3. Double click on the downloaded file: c:tempSqlServer2K5_BOL_Feb2007.msi. The installation setup window shows up. Follow the instructions to finish the installation.

4. When the installation is done. You will see a new entry in the Start menu: Start > Programs > Microsoft SQL Server 2005 > Documentation and Tutorials
Is it helpful? Add Comment View Comments
Ques 13. How to run Queries with SQL Server Management Studio Express?
Ans. 1. Launch and connect SQL Server Management Studio Express to the local SQL Server 2005 Express.

2. Click on the "New Query" button below the menu line. Enter the following SQL statement in the query window:

SELECT 'Welcome to GlobalGuideLine.com Tips on SQL Server!'

3. Click the Execute button in the toolbar area. You should get the following in the result window:

Welcome to GlobalGuideLine.com Tips on SQL Server!
Is it helpful? Add Comment View Comments
Ques 14. How to run SQL Server 2005 Books Online on your local system?
Ans. SQL Server 2005 Books Online can be accessed by a Web browser over the Internet. But you can also download it and read it on your local system. If you have downloaded and installed SQL Server 2005 Books Online package, you follow this tutorial to run it:

1. Click Start > Programs > Microsoft SQL Server 2005 > Documentation and Tutorials > Tutorials > SQL Server Tutorials. The SQL Server 2005 Books Online window shows up.

2. Click the plus sign (+) next to "SQL Server 2005 Tutorials in the Contents window".

3. Click the plus sign (+) next to "SQL Server Tools Tutorials".

4. Click "Lesson 1: Basic Navigation in SQL Server Management Studio". The book content shows up for you to read.
Is it helpful? Add Comment View Comments
Ques 15. How to use Transact-SQL statements to access the database engine?
Ans. Transact-SQL statements can be used to access the database engine directly. Here are some good tutorials provided by the SQL Server 2005 Books Online. See the SQL Server 2005 Tutorials > Database Engine Tutorials > Writing Transact-SQL Statements Tutorial section in the SQL Server 2005 Books Online document.

This SQL Questions Guide is intended for users who are new to writing SQL statements. It will help new users get started by reviewing some basic statements for creating tables and inserting data. This tutorial uses Transact-SQL, the Microsoft implementation of the SQL standard. This tutorial is intended as a brief introduction to the Transact-SQL language and not as a replacement for a Transact-SQL class. The statements in this tutorial are intentionally simple, and are not meant to represent the complexity found in a typical production database.
Is it helpful? Add Comment View Comments

Most helpful rated by users:

©2017 WithoutBook