What is 1=2 in sql

Number(10 2) in sql means

-- Precision of 10 and a scale of 2
SELECT CONVERT(DECIMAL(10, 2), col_name)

SELECT CONVERT(DECIMAL(10, 2), 2.999999)			-- 3.00
SELECT CONVERT(DECIMAL(10, 2), 12352.334)			-- 12352.33
SELECT CONVERT(DECIMAL(10, 2), 12564258524132.336)	-- Error: data truncation

What is 1=2 in sql

This type of command is usually used to copy the structure of one table 
to another. In this case, EMPL_DEMO will have the same column structure 
of employees , except for the keys or constraints. The 1=2 always 
evaluates to False which prevents you from copying any of the rows.

Similar codes

0 vote200 views1 answer
Replace sqlalchemy
SQL
0 vote212 views1 answer
Can't connect to postgresql mac os
SQL
5 votes204 views2 answers
To date oracle
SQL
4 votes211 views2 answers
Oracle sql group by date year
SQL
0 vote196 views1 answer
Mod in sql
SQL
7 votes201 views2 answers
Get database size mysql
SQL
1 vote209 views2 answers
Mysql insert generate serie
SQL
0 vote198 views1 answer
Why mysql is used?
SQL
1 vote198 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote204 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL