Sql sever GUI query tool

FAQ

Profile

Sql sever GUI query tool

Database Forums (Home) -> Programming

Next: Archieve Tables (Purging)

Author

Message

Jack

External

Since: Mar 23, 2006
Posts: 122

(Msg. 1) Posted: Thu Jun 12, 2008 9:43 am
Post subject: Sql sever GUI query tool
Archived from groups: microsoft>public>sqlserver>programming (more info?)

I was wondering if there is any free sql server GUI query tool that can help
to do quick joined queries without wiring code. Thanks.

>> Stay informed about: Sql sever GUI query tool

Aaron Bertrand [SQL Serve

External

Since: Jun 15, 2005
Posts: 632

(Msg. 2) Posted: Thu Jun 12, 2008 12:50 pm Post subject: Re: Sql sever GUI query tool [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

You don't have SSMS? Are you only using Express Edition? If so, have you tried SSMS Express? http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1...3D-94B8 "Jack" wrote in message >I was wondering if there is any free sql server GUI query tool that can >help > to do quick joined queries without wiring code. Thanks. >> Stay informed about: Sql sever GUI query tool

Jack

External

Since: Mar 23, 2006
Posts: 122

(Msg. 3) Posted: Thu Jun 12, 2008 12:50 pm Post subject: Re: Sql sever GUI query tool [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Aaron, I do have the SSMS Express. What I was looking for is something like Access GUI Query tool where you can drag and drop and define joins (outer or inner) without writing any code and save it for later use. Does SSMS Express allow one to do so. Please let me know. Thanks . "Aaron Bertrand [SQL Server MVP]" wrote: > You don't have SSMS? Are you only using Express Edition? If so, have you > tried SSMS Express? > > http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1...3D-94B8 > > > > > > > "Jack" wrote in message > > >I was wondering if there is any free sql server GUI query tool that can > >help > > to do quick joined queries without wiring code. Thanks. > > > >> Stay informed about: Sql sever GUI query tool

rsocol

External

Since: Jan 13, 2005
Posts: 63

(Msg. 4) Posted: Thu Jun 12, 2008 12:50 pm Post subject: Re: Sql sever GUI query tool [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Jack wrote: > I do have the SSMS Express. What I was looking for is something like > Access GUI Query tool where you can drag and drop and define joins > (outer or inner) without writing any code and save it for later use. > Does SSMS Express allow one to do so ? Yes. In a query window, choose Query / Design Query in Editor. It's not very smart, but it's a good start. -- Razvan Socol SQL Server MVP >> Stay informed about: Sql sever GUI query tool

Jack

External

Since: Mar 23, 2006
Posts: 122

(Msg. 5) Posted: Thu Jun 12, 2008 12:50 pm Post subject: Re: Sql sever GUI query tool [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Thanks Razvan. This is kind of very basic tool. "Razvan Socol" wrote: > Jack wrote: > > I do have the SSMS Express. What I was looking for is something like > > Access GUI Query tool where you can drag and drop and define joins > > (outer or inner) without writing any code and save it for later use. > > Does SSMS Express allow one to do so ? > > Yes. In a query window, choose Query / Design Query in Editor. > It's not very smart, but it's a good start. > > -- > Razvan Socol > SQL Server MVP > >> Stay informed about: Sql sever GUI query tool

Aaron Bertrand [SQL Serve

External

Since: Jun 15, 2005
Posts: 632

(Msg. 6) Posted: Thu Jun 12, 2008 10:50 pm Post subject: Re: Sql sever GUI query tool [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

> Thanks Razvan. This is kind of very basic tool. Well, what do you want for free? There are some other editors out there, but I don't know of any free graphical drag'n'drop query editors that are likely to be better... >> Stay informed about: Sql sever GUI query tool

John K

External

Since: Dec 17, 2010
Posts: 1

(Msg. 7) Posted: Fri Dec 17, 2010 6:25 am Post subject: Re: Sql sever GUI query tool [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

how about Navicat Lite? it is free and support 5 databases. > On Thursday, June 12, 2008 12:43 PM Jac wrote: > I was wondering if there is any free sql server GUI query tool that can help > to do quick joined queries without wiring code. Thanks. >> On Thursday, June 12, 2008 12:50 PM Aaron Bertrand [SQL Server MVP] wrote: >> You do not have SSMS? Are you only using Express Edition? If so, have you >> tried SSMS Express? >> >> http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1...3D-94B8 >>> On Thursday, June 12, 2008 1:13 PM Jac wrote: >>> Aaron, >>> I do have the SSMS Express. What I was looking for is something like Access >>> GUI Query tool where you can drag and drop and define joins (outer or inner) >>> without writing any code and save it for later use. Does SSMS Express allow >>> one to do so. Please let me know. Thanks . >>> >>> "Aaron Bertrand [SQL Server MVP]" wrote: >>>> On Thursday, June 12, 2008 1:24 PM Razvan Socol wrote: >>>> Jack wrote: >>>> >>>> Yes. In a query window, choose Query / Design Query in Editor. >>>> it is not very smart, but it is a good start. >>>> >>>> -- >>>> Razvan Socol >>>> SQL Server MVP >>>>> On Thursday, June 12, 2008 3:15 PM Jac wrote: >>>>> Thanks Razvan. This is kind of very basic tool. >>>>> >>>>> "Razvan Socol" wrote: >>>>>> On Thursday, June 12, 2008 10:50 PM Aaron Bertrand [SQL Server MVP] wrote: >>>>>> Well, what do you want for free? >>>>>> >>>>>> There are some other editors out there, but I do not know of any free >>>>>> graphical drag'n'drop query editors that are likely to be better... >>>>>> Submitted via EggHeadCafe >>>>>> Oracle Developer For Beginners >>>>>> http://www.eggheadcafe.com/training-topic-area/Oracle-SQL-Developer/2/...cle-SQL >> Stay informed about: Sql sever GUI query tool

Display posts from previous:

Related Topics:

sql sever srcipts and .net - Hello All, I have an automated tester, the architecture is built on .net 1.1, and it works just fine. There is a new requirement to run some scripts automatically that could test our MS SQL sever database, and I would like to extend my tester to..

Any Program or Tool that helps in convertion ???! - Hi, I need a tool or a program that helps me to convert an MS SQL backup database file with the ( .bak) extension into ( .sql) , I need that urgently please. Many Thanks in advance. Alabdulelah

Free tool to compare two databases - Hi, Is there any free tool that compares the schema and the data of two SQL Server databases ? Thank you

sql query - hi i can get the result mentioned below using a cursor but want to have a single query to do it. can any one help. drop table #cost1 create table #cost1 ( prod_id int , cost decimal(9) ) insert into #cost1 values (1,10000) insert into #cost1 values....

A SQL query. Can you do that?? - Hi, I have a table with only 1 colum. Is it possible to tansform it into a multi-colums tabel using a SQL SELECT query? Col ------- 1 2 3 4 5 Cols in new table -------------------- 1,2,3 4,5, Nul Any assistance is highly appreceiated Larry..

	Database Forums (Home) -> Programming	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum