Super noob help with MSSQL - 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

Super noob help with MSSQL

Author

Topic

wmosconi
Starting Member

3 Posts

Posted - 2013-12-01 : 22:30:27

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

52326 Posts

Posted - 2013-12-02 : 04:31:31

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

wmosconi
Starting Member

3 Posts

Posted - 2013-12-02 : 19:35:26

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.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-03 : 00:22:25

Ok..cool

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2013-12-03 : 13:19:04

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.

wmosconi
Starting Member

3 Posts

Posted - 2013-12-04 : 02:22:15

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.

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2013-12-04 : 14:58:38

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources