Fetch Table data - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

Fetch Table data

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.

Thanks

Skr...

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-05 : 02:24:52

same here to

start 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 query
then type and run your select statement

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://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?

Thanks

Skr...

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 MVP
http://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.

Thanks

Skr...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources