SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Fetch Table data
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SKR
Starting Member

Kenya
6 Posts

Posted - 02/05/2013 :  02:18:48  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 02/05/2013 :  02:24:52  Show Profile  Reply with Quote
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/

Go to Top of Page

SKR
Starting Member

Kenya
6 Posts

Posted - 02/05/2013 :  02:30:04  Show Profile  Reply with Quote
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...
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 02/05/2013 :  02:33:43  Show Profile  Reply with Quote
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/

Go to Top of Page

SKR
Starting Member

Kenya
6 Posts

Posted - 02/05/2013 :  02:39:53  Show Profile  Reply with Quote
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...
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000