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
 Super noob help with MSSQL
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

wmosconi
Starting Member

3 Posts

Posted - 12/01/2013 :  22:30:27  Show Profile  Reply with Quote
Dear forum,
I'm beyond brand new to MSSQL and started playing around with a demo database to get comfortable and all that good stuff. I'm connecting to the virtual machine through another linux vm using sqsh. Navigating around ok, but where I'm getting a bit stumped is how to view the contents of a certain column. So for example,
DB = SportsTeam
Table = Starters
Column Name = goalies

So I want to view in the linux sessions shell, the entries of that column. There's pre-made entries like mark, john, david etc., but as I tinker around, I want to ensure that my edits actually went in. How do I view the entries?
Thanks a bunch in advance.

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/02/2013 :  04:31:31  Show Profile  Reply with Quote
Do you've a client program installed for accesing MSSQL like TOAD,SSMS etc? If yes you can uopen a new window and connect to your SQL DB instance and use a query like

SELECT goalies FROM SportsTeam.dbo.Starters


and it will show you all entries saved so far in the column

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

wmosconi
Starting Member

3 Posts

Posted - 12/02/2013 :  19:35:26  Show Profile  Reply with Quote
hey visakh16,
Thanks for the response. I don't unfortunately as I'm mainly a Linux user, but I get the feeling I will have to :) . I'll try what you posted from sqsh and see if that works.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/03/2013 :  00:22:25  Show Profile  Reply with Quote
Ok..cool

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
792 Posts

Posted - 12/03/2013 :  13:19:04  Show Profile  Reply with Quote
Are you sure you are using Microsoft SQL Server (MSSQL) and not MySQL?

Since you are using Linux I would guess you are using MySQL and not MSSQL. If so, then you want to download and install the MySQL WorkBench which will give you the utilities you need to query the database.
Go to Top of Page

wmosconi
Starting Member

3 Posts

Posted - 12/04/2013 :  02:22:15  Show Profile  Reply with Quote
Hey Jeff,
Ya I'm sure. I'ts a vm instance running MSSQL. MySql I'm relatively comfy with, but where I was having issues was the connectivity from a Linux box to the MSSQL instance, hence using sqsh.
Never had to run 'go' after a query before lol.
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
792 Posts

Posted - 12/04/2013 :  14:58:38  Show Profile  Reply with Quote
So, you have a Windows virtual machine setup with MSSQL running on it. You can RDP to the virtual machine and run SSMS on that machine to query the database.
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