Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SKR
Starting Member
6 Posts |
 Posted - 2013-02-05 : 02:18:48
|
| I am new in SQL server database, I want to know how to fetch table data like in oracle I login through SQL , connect to the schema and run select statement. Can someone provide me any link to learn this.ThanksSkr... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-05 : 02:24:52
|
| same here tostart sql server management studio which is client program for sql server (accessed from start->programs-> microsoft sql server -> Sql server management studio)Connect to your server (click on connect button on left side bar and type your servername)click new querythen type and run your select statement------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
SKR
Starting Member
6 Posts |
Posted - 2013-02-05 : 02:30:04
|
| Hi Visakh,Thanks for your prompt reply. SO sql server management studio is needed to be installed on the server or in the client PCs to connect to the database. Am I right? Another silly question, is there any schema concept here in SQl server? or if I connect to the server then I can access any data?ThanksSkr... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-05 : 02:33:43
|
| yep..Ideally it will installed in client PCs. you dont require it to be installed on the server unless you want to remote onto server and use it for creating queries,monitor etc.Yes. there's schema concept in sql server from 2005 onwards. When you connect to server you'll be mapped to default schema which your login corresponds to. You will not be able to access other schema data unless GRANT permission is given on them or you've admin privileges.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
SKR
Starting Member
6 Posts |
Posted - 2013-02-05 : 02:39:53
|
| Thanks Visakh, So it is more or less same like oracle, I guess, Actually I am an Oracle DBA and in the process to have knowledge on SQL server as well. I appreciate if you can provide me with some good links/books on SQL server Admin, Concepts guide.ThanksSkr... |
|
|
|
|
|
|
Fetch Table data