Can a grid be created using SQL?

[shaleen7]

Can a grid be created using SQL?

I want to create a grid around some data.

Name Address
John 3 Hunter Drive
Mary 4 Donald Ave
Ken 12 Kendall Road

The above data would appear in a grid/table ( 2 Columns by 4 Rows) . Can that be accomplished using SQL? If so, where can I find sample scripts.

Thanks

 

[kishleo]

what do you mean by grid? you mean you want to see the data in a table formate (something like in html) in query analyzer?

Kishore

 

[gvphubli]

Create a table with 2 columns, and just insert the data and query the table using Query Analyser...u will c the data in grid form.


Cracky -= Developer/DBA =-
visti:

http://www.geocities.com/gvphubli

 

[SQLBill]

By grid table, do you mean a nice form with the lines around the entries? If so, no SQL Server will not do that. It's not a 'front-end' application.

Having said that, Query Analyzer can DISPLAY the results of a query in a grid. But that grid format is not 'saveable' to my knowledge.

-SQLBill

 

[Windy77]

If you need it to be in a "front end" application, you could create a Table as mentioned above, then export it to Excel using SQL's Data Transformation Services.

 

[bassguy]

you could also connect to the database with excel and call the query from excel...then store a DQY file and it will be current data everytime you run it

bassguy