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 vote311 views1 answer
Mysql query with sql to get the next row
SQL
1 vote282 views1 answer
Get url of cpanel database hostname
SQL
0 vote244 views0 answer
How to connect to datbase in springboot
SQL
0 vote289 views1 answer
Pl sql search in all packages
SQL
2 votes322 views1 answer
Q operator in oracle
SQL
0 vote292 views1 answer
Import sql dump into postgresql database
SQL
0 vote293 views1 answer
Sql string contains case sensitive
SQL
1 vote328 views1 answer
Sql server if exists update else insert
SQL
42 votes371 views6 answers
Sql query duplicate rows
SQL
0 vote309 views1 answer
Const pool = mysql.createpool()
SQL