Mahmoud ElMansy: knowledge meant to be free

Sql Server 2008 Query Designer Toolbar-Edit Data Without Update Statement

In this post i will talk about “Query Designer Toolbar“.
It is one of the coolest feature that i see on SQL.

First :  we will talk about how to show it.

showing toolBar

Second :    how to use it .

QueryDesigner2

This will show the result grid Editable (can edit the data on the flay).

QueryDesigner3

Now to start using the Cool features of the “Query Designer Toolbar“.

Let’s Get Started

1 ) We will activate the “The Show SQL Pane”

and the result as shown.

QueryDesigner4

This pane can make write my own query with any Condition i want.

QueryDesigner5

Means that i can write any query that i want and it will show in the result pane and i can edit The result data with out need to write additional update Queries 

2 ) The Change Type  “DropDownList” 

Contains a very nice tools that can speed up the developer to perform many tasks that takes a lot of time from home .

1) Insert Results…

QueryDesigner6

Just choose the table that you want to insert the data into.

QueryDesigner7

And we can the that the Insert statement Created automatic with my where condition.

QueryDesigner8

2 ) Update

QueryDesigner9

3 ) Insert Values

QueryDesigner11

4 ) Make Table

QueryDesigner12