We write SQL queries manually in query window. Most of the time it’s hard to remember all the objects name and syntax. As a result it’s takes time to writes statement correctly. We can easily create the SQL query by using QUERY DESIGNER.
To create the new query, do the following steps:
1. Open query window.
2. Go to query menu and click on Design Query in Editor… or press Ctrl+Shift+Q. A Query Designer window will open as like following image.
3. Now create your required query from Query Designer. When complete click OK. See Query that you created from Query Designer will paste into query window.
To change the existing query, do the following steps:
(Existing query’s syntax should be correct. Otherwise it will give error.)
1. Select the whole query from query window.
2. Go to query menu and click on Design Query in Editor… or press Ctrl+Shift+Q. A Query Designer window will open.
3. Now create your required query from Query Designer. When complete click OK. See Query that you create from Query Designer will overwrites the existing query into query window.
Filed under: CodeProject, MS SQL SERVER | Leave a Comment
Tags: Query Designer, Query Designer in SQL server 2005, Query in SQL server 2005
getafreelancer- Mobile phone numbers wanted worldwide by spike1968
- 3D human icon for still use by Dendre
- Joomla migration needs completion by deanjoomla
- 50 PLR Rewrite $1.00 Per Article by Muser1
- Forum advertising/posting - video game sites by JoeDigital
- C++ dialog dll by EasyEC
- Three Product test pages. by eugenewu14
- I need a contact form added to a site. by workerbee123
- Writer-Journalist Needed by vplatania
- Creating a podcast by symphonicdist
No Responses Yet to “Quickly create SQL query in SQL server 2005 with query designer”