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 vote173 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
22 votes150 views3 answers
Join three tables sql
SQL
14 votes164 views6 answers
Auto_increment mysql
SQL
-1 vote169 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
8 votes203 views2 answers
Default sql server port
SQL
29 votes152 views5 answers
Mysql show table structure
SQL
1 vote156 views1 answer
Oracle sql create or replace view
SQL
1 vote148 views1 answer
Postgres killing connections on db
SQL
1 vote180 views1 answer
Limit offset order by mysql
SQL
0 vote159 views1 answer
Excel export from sql using python
SQL