| Author |
Topic |
|
azizrasul
Starting Member
3 Posts |
 Posted - 2012-05-21 : 12:06:16
|
| Hi, This is my first post.Is there a way of creating SQL statements using a Graphical User Interface? If so, where do I go to see this GUI?AzizSQL Server Newbie |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2012-05-21 : 13:05:33
|
| Which GUI?And what statements do you want to create? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-21 : 16:11:06
|
| do you mean template explore with query syntax stubs where you can replace place holders with actual objects and construct queries?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
azizrasul
Starting Member
3 Posts |
Posted - 2012-05-22 : 04:14:14
|
| I was told that there is a GUI where you can visually see tables and joins much as you can when you use MS Access. Since my SQL skills are limited at the moment and we live in a world where everything has to be done pronto, I thought it would make life easier for me to use such a GUI whilst I'm learning to write SQL without it.Aziz(Newbie) |
|
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-05-22 : 05:00:17
|
quote:
Originally posted by azizrasul
I was told that there is a GUI where you can visually see tables and joins much as you can when you use MS Access. Since my SQL skills are limited at the moment and we live in a world where everything has to be done pronto, I thought it would make life easier for me to use such a GUI whilst I'm learning to write SQL without it.Aziz(Newbie)
I think you are looking for third party graphical query building softwares. You can google and find a lot of them.N 28° 33' 11.93148"E 77° 14' 33.66384" |
|
|
|
azizrasul
Starting Member
3 Posts |
Posted - 2012-05-22 : 06:11:03
|
| I've been told that it's already in SQL server but that it's like an add-in that can be installed!Aziz(Newbie) |
|
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-05-23 : 03:33:36
|
quote:
Originally posted by azizrasul
I've been told that it's already in SQL server but that it's like an add-in that can be installed!Aziz(Newbie)
I think the person who told you this could be the best person to tell you which tool it was.I have a feeling that he could have been talking about Business Intelligence Development Studio(BIDS). This is used for ETL(Extract, Transform & Load) Tasks and creates SQL Server Integration Services(SSIS) packages.It graphically shows the tables being used while the packages are being created and executed.N 28° 33' 11.93148"E 77° 14' 33.66384" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-05-23 : 04:22:21
|
There is a way to design queries in a graphical way built in to sql server management studio, and it always has been: - LumbagoMy blog-> http://thefirstsql.com |
|
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-05-23 : 08:10:41
|
| Is it there in SQL Server 2008 as well??...EDIT: Sorry bout that....just checked it...it is and has been there always....just didn't come to my mind...Sorry again.N 28° 33' 11.93148"E 77° 14' 33.66384" |
|
|
|
|
GUI