It has been a long time since we ran quiz. So let us get ready for a quiz. The quiz has two parts. You have to get both the parts correct to win Quadcopter with Camera (we will call it drone). We will be giving away a total of 2 Quadcopters.
The quiz is extremely easy and I will ship the Drone anywhere in the world where Amazon will ship it.
Let us jump directly to the quiz. Please complete both the parts the contest.
Contest Part 1: Brain Teasers
Please execute following script and answer the questions.
-- What will be the output of the following? and Why?
SELECT 28E3
-- What will be the output of the following? and Why?
SELECT 28F3
-- What will be the output of the following? and Why?
SELECT F328
Contest Part 2: Download and Activate Rapid SQL
Question: Download and Activate Rapid SQL.
Hint: You have to download and activate Rapid SQL. If you do not activate Rapid SQL, you will be disqualified for the contest. Why take risk, let us start!
That’s it!
Just answer above questions in the following comments area, in following format.
Remember:
- Download RapidSQL from this link.
- Use comments area right below the blog to take participation in the contest
- Answer before November 21, 2014 midnight GMT.
- The winner will be announced on December 8.
- The winner will be selected randomly from all the valid answers.
- All the valid answers will be kept hidden till December 24, 2014.
- There will be a total of two winners.
- The contest is open for any country of the world where Amazon ships products.
Reference: Pinal Dave https://blog.sqlauthority.com/ )
21 Comments. Leave new
— What will be the output of the following? and Why?
SELECT 28E3
Output: because Here E means exponent with base 10
———————-
28000
(1 row(s) affected)
— What will be the output of the following? and Why?
SELECT 28F3
Output: because this will take F2 as column alias and 28 as static value.
F3
———–
28
(1 row(s) affected)
— What will be the output of the following? and Why?
SELECT F328
Output: because F328 is not numeric so this is not static value & It will assume F328 as column name which is invalid.
Msg 207, Level 16, State 1, Line 1
Invalid column name ‘F328’.
Hello
1) SELECT 28E3
Show 2800 because e3 is exponent
2) SELECT 28F3
Sshow 28 with column name f3
3) SELECT F328
Show error message “Invalid column name F328”
28E3 is notation for 28 * 10^3 which equals 28 * 1000 = 28000
28F3 will act the same as 28 F3 or 28 AS F3 since F is a letter and there are no single quotes it assumes that is the start of the column name
E328 will throw Msg 207, Level 16, State 1, Line 5 because SQL Server sees it as a column name but no value
Part 1
SELECT 28E3
This selects the number in scientific notation so it’s selecting the expression 28 x 10^3 (so it selects 28000 under column undefined)
SELECT 28F3
This selects the number 28 and then aliases it as F3 (so it selects the data 28 under column F3)
SELECT F328 or E328
This errors out because it tries to select the literal F328 or E328 which is not a thing. If it was it would select what ever that name represents. I suppose if you had a function or stored procedure with no parameters called F328 or E328 it would output whatever that was defined as)
Pat 2
Done? I’m not sure how to respond to this part aside from I promise I really did the thing.
Part 1
1) 28000 — scientific notation; 28E3 = 28 x 10^3 = 28,000
2) Query Error — unrecognized token: “28F3”
3) Query Error — no such column: F328
Part 2
registered; Trial License (Expires 2014-11-24)
The answer of SELECT 28E3
is 28000 E means 28 multiplied by the ten to the power 3(i.e. 1000) because sql server treat it as floating point
the answer of SELECT 28F3 is 28 because SQL treats 28 as number(i.e. numeric) and F3 as column name (i.e.t- sql syntax)
the answer of SELECT F328 is an error i.e. invalid column name as there is no value(i.e. neither integer nor character string placed inside ‘ ‘) because SQL server try to read it as the value in a column
with regards
SELECT 28E3
Out Put :28000
SELECT 28F3
Out Put :28 with Column Name F3
SELECT F328
Out Put:Invalid column name ‘F328’
SELECT 28E3 returns 28000 w/o column name. It is a scientific format of representing numbers with floating decimal point. xEn = x*power(10, N), in this particular case 28E3 = 28*10^3 = 28000.
SELECT 28F3 returns 28 with column name F3. Column names in SQL Server can not start from numbers therefore SQL Server treats 28 as a value and F3 as column alias, space and “as” are optional. More verbose format of writing the same is 28 as F3.
SELECT F328 return an error “Invalid column name ‘F328′” because SQL Server treats it as column name because it starts as with letter and it can not find it in any part of the query. Strings suppose to start with ‘.
ANSWER:
1. SELECT 28E3 -> 28000 (E stands for exponents, so SELECT 28E4 -> 280000)
2. SELECT 28F3 -> F3 (column alias), 28 (value) (so SELECT 30G9 -> G9 column alias, 30 value)
3. SELECT F328 -> Invalid column name
1. Fixed defined float value in exponential writing; 28E3 = 28^3 = 28000
No column name
———————
28000
(SELECT 28 will return the value ’28’. E is the exponential function.)
2. Object qualifier must start with a letter or underscore; therefore the engine interprets the first numeric part as the value and the letters as the qualifier aka column alias
Value = 28, alias = F3
F3
————
28
3. Object qualifier must start with a letter or underscore, and ours starts with ‘F’ but no such object exists
Msg 207, Level 16, State 1, Line 1
Invalid column name ‘F328’.
28000 — this is treated as Exponential
28 and Column Name as F3…Becasue first nonmumeric will consider as Alias
It throws an error as tries to find Column
Hi,
1. SELECT 28e3
Output:
28000 with header (no column name)
Reason : when execute we execute above select then 28e3 considering as as Float number because “e” use for float number
2.SELECT 28S3
Output:
28 with header S3
Reason :showing S3 as column header because “S” is not any reserve alphabet in sql and if we write any alphabet except “e” in select statement with number then it treating that alphabet as column Alias name.
3.SELECT F328
Output:
Msg 207, Level 16, State 1, Line 1
Invalid column name ‘F328’.
Reason : ‘F328’ is not any reserve key word for any function ,stored procedure or any other sql object
— What will be the output of the following? and Why?
SELECT 28E3
— 28000. It is a number in scientific notation (28E+3)
— What will be the output of the following? and Why?
SELECT 28F3
— 28. F3 is understood as column name (28 as F3)
— What will be the output of the following? and Why?
SELECT F328
— Syntax error: could not be resolved to a number
SELECT 28E3 yields 28,000 because 28E3 is a number with 3 zeros to the right of the number before the E
SELECT 28F3 yields 28. F3 is considered an alias.
SELECT F328 bombs because F3 is not a number
— What will be the output of the following? and Why?
SELECT 28E3
value 28000 with no filed name – this is Scientific notation
— What will be the output of the following? and Why?
SELECT 28F3
value 28, F3 filed name soon as you stopped doing numbers you are in field name description
— What will be the output of the following? and Why?
SELECT F328
Error, filed name does not exist
SELECT 28E3 — Output = 28000. This is called floating point notation or scientific notation. It is 8×10³, which is 8000. The e stands for 10th exponent. So contactenate 2 and 8000 equals 28000.
SELECT 28F3 — Output = 28. F3 acts as an alias that leaves the value 28.
SELECT F328 /* This sql statement will fail (Msg 207, Level 16, State 1
Line 1 Invalid column name ‘F328’.) as it is not string and it needs to be in single quotes e.g SELECT ‘F328’ */
unable to download rapid sql
28000 – interpreted as scientific notation (28 * 10^3)
28 (Column name = F3. 28 interpreted as an int, the other nonnumeric interpreted as the column name)
F328 – not parseable at all, could be if quoted
— What will be the output of the following? and Why?
SELECT 28E3
Output: 28000 (no column name)
Reason: 28E3 reads “25 times (10 to the power of 3)”
— What will be the output of the following? and Why?
SELECT 28F3
Output: 28 (column “F3”)
Reason: 28E3 reads “25 with column alias F3”
— What will be the output of the following? and Why?
SELECT F328
Output: “Invalid column name ‘F328’.”
Reason: It doesn’t match any constant or predefined variable and as no table is referenced it cannot be any column name.
* I have installed and registered Rapid SQL XE6. Now for solving the questions.
SELECT 28E3
/*
The query “SELECT 28E3” will return 28000. The “28e3” is the same as 28 * 103 or 28 times 3 to the Power of Ten.
In scientific notation, this is sometimes used to make large numbers more readable, but it is a real number and SQL Server sees it as a number.
In this example the scientific notation has 28 multiplied by the product of the significant of 3 multiplied by the power of ten.
*/
SELECT 28F3
/*
The query “SELECT 28F3” will return 28 with the alias “F3.” Once the number is complete, the next valid character is the alias of the value.
We’ve probably all seen this before at work where poor coding standards and format sometimes leaves us with queries in similar shape.
*/
SELECT F328
/*
The query will return an error as the first item in the statement “F” is a non-numerical character, so it must have apostrophes around it.
*/