| Author |
Topic |
|
spinoza
Starting Member
49 Posts |
 Posted - 2006-01-05 : 17:17:11
|
| I noticed that query analyser is much more quicker than EManager when I access my database from my hosting provider... is there any way to see the properties of the table X for example as one can do with EM...I would be grateful if you could provide me with any query sample conserning this issue...Thanks |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-01-05 : 17:38:34
|
| Try:exec sp_help 'tablename'it will show most of the info you need for a table.Have you used the object browser tree in QA? (press F8 to show/hide it)rockmoose |
 |
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-01-05 : 17:55:26
|
| Gracias rockmoose...I am making my first steps to SQL...I have bought some books to help me as well...I have seen the object browser tree but i do not know yet how to use it...Thank you |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-05 : 18:10:56
|
| In Object browserU can c the objects as Tables, Views, Stored proceduresIf u want to find the column names / properties of a table u can use itIf u want to view data in a table u can do it (right click on required table )If u want to Change a stored procedure, go to the Stored Proc & right click select the Edit optionPlay with it.Other than Object browser there is a search (F4)Most powerful feature in QA is that u can write queries and run it and c the results.For that Go to File, Connect, --> Connect to the server with proper username/pwd or windows authenticationSelect a database from the list shown (eg Pubs database)Write a query like Select * from Authors and using the F5 key run itPlay with it & Enjoy |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-06 : 00:14:19
|
| >>exec sp_help 'tablename'or type tablename and highlight it and press Alt+F1MadhivananFailing to plan is Planning to fail |
|
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-01-06 : 02:26:05
|
| Another nice feature that QA has is the ability to tell you what errors you have in your code (if you run a query and it fails) - Double click the Error Message in the Results Pane (at the bottom) and it will highlight the line that contains your error.If you want to verity that your query doesn't have any errors (parse it) then simply press Ctrl+F5 and it will tell if you if you have any syntax errorsEnjoy SQLRegardsNIf you want your computer to be faster then throw it out of the window. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-06 : 05:07:22
|
| And another ...With the object browser open you can "drag" names from it into your code - the spacing is a little iffy, and for some objects it brinks in all the [bracketry]Right click a Table/View/Sproc will give options to generate the SQL for it (on clipboard / new windows / whatever)Kristen |
|
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-01-06 : 06:01:35
|
| and another...If you press Ctrl+Shift+F and run your query then the results of the query will be saved to your drive - The "Save As" dialog will come up and you can choose the location.Ctrl+D will process the results into a Grid on the Results PaneCtrl+T will process the results into Text format on the Results PaneNIf you want your computer to be faster then throw it out of the window. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-06 : 09:08:09
|
| .. and if you can;t remember the shortcuts just Right Click the Query Pane.Also, QA supports templates - so when you get to the stage of wanting "canned code" you can set up a template (e.g. of your favorite layout and Bits&Bobs for a Stored Procedure), "insert" your template into your code, and it will pop up a Question&Answer window for any parameters you have declared - like Name of SProc, Version number, Author name ...Kristen |
|
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-01-06 : 15:33:25
|
| Thank you very much all of you indeed... |
|
|
|
|
Using Query Analyser