Very new to SQL - 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 Programming

Very new to SQL

Author

Topic

bill1971
Starting Member

3 Posts

Posted - 2014-09-13 : 12:17:38

I'm happy to see this place exists. I've been working on sqlcourse.com which is very helpful. One thing I cant figure out is when I insert into a table like this

insert into table
(firstname, lastname, title, age, salary)
values ('Luke', 'Duke', 'Janitor', 45, 45000);

then type select * from table

I get

firstname lastname title age salary
Jonie Weber Secretary 28 19500.00
jonie weber secretary 28 19500.00
Jonie Weber Secretary 28 19500.00
Luke Duke Janitor 45 45000
luke duke janitor 45 45000
Luke Duke Janitor 45 45000

I shows upper and lower case Luke and luke and duke and Duke

Is that normal? The website doesnt explain.

Thank you.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-09-13 : 15:35:18

sql will only show data that has been stored in the table. That means that, at some point, you actually entered lowercase 'luke' and 'duke'

bill1971
Starting Member

3 Posts

Posted - 2014-09-13 : 16:55:29

This is a brand new table, I just created it today and only inputted what I pasted here. Maybe a problem with the Web page? I appreciate the response.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-09-14 : 02:12:09

If the recordset you returned is : select * from table , then those records , were added at some point.
To verify - open sql server management studio, connect to the server and database, execute the query , what is the result?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

bill1971
Starting Member

3 Posts

Posted - 2014-09-14 : 13:07:48

I dont think I can, this is off a practice website.

http://www.sqlcourse.com/insert.html

The first step had me create table
Step two was to input names, so there is no existing history for this table. Based on what you two are saying, I would say that there may be an issue with the practice software.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources