Collections:
Running Queries with SQL Server Management Studio Express in SQL Server
How to run Queries with SQL Server Management Studio Express in SQL Server?
✍: FYIcenter.com
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 FYIcenter.com SQL Server!'
3. Click the Execute button in the toolbar area. You should get the following in the result window:
Welcome to FYIcenter.com SQL Server!
See the following picture to know where the query and result windows are:
.
⇒ Running Queries with 'sqlcmd' Tool in SQL Server
⇐ Connecting SQL Server Management Studio Express To a SQL Server in SQL Server
⇑ Downloading and Installing SQL Server 2005 Express Edition
2016-12-04, 2765👍, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...