Exercise: 3 "failed test on second"

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

Exercise: 3 "failed test on second"

Author

Topic

fullypaglot
Starting Member

6 Posts

Posted - 2013-08-06 : 08:13:34

I am very new with SQL and I am doing practice questions from http://www.sql-ex.ru I am on,
Exercise: 3
Add the model 4444 with code=22, speed=1200 and price=1350 into the PC table.

The absent features should be supplied with the default values for corresponding columns.

I wrote the syntex
insert into Pc values
(22,4444,1200,128,40,'40X','1350.0000')

but now I am getting "Your query produced correct result set on main database, but it failed test on second, checking database.
* Data mismatch (3)"

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-08-06 : 08:26:08

>>but it failed test on second, checking database
I think you should use fully qualified name of table
insert into DatabaseName..Pc values
(22,4444,1200,128,40,'40X','1350.0000')
I'm not able to access this website http://www.sql-ex.ru

--
Chandu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-06 : 09:23:42

Data mismatch (3)
I think issue is you're either not passing values in correct order or you're missing some columns in between.

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

fullypaglot
Starting Member

6 Posts

Posted - 2013-08-06 : 09:39:02

The database scheme consists of four tables:
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)

Exercise: 3
Add the model 4444 with code=22, speed=1200 and price=1350 into the PC table.
The absent features should be supplied with the default values for corresponding columns.

My syntex
insert into Pc values
(22,4444,1200,128,40,'40X','1350.0000')

system response
Your query produced correct result set on main database, but it failed test on second, checking database.
* Data mismatch (3)

again the web address is http://www.sql-ex.ru/learn_exercises.php?LN=3

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-07 : 00:25:46

Are you using SQL server? the error message doesnt look like SQL Server error to me

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources