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 vote352 views1 answer
Mysql subdate
SQL
0 vote359 views2 answers
Mysql decimal remove trailing zeros
SQL
3 votes362 views1 answer
Postgresql today - 1 year
SQL
0 vote354 views2 answers
Functions with parameters SQL
SQL
2 votes334 views2 answers
Checking data type in sql server
SQL
0 vote288 views1 answer
Mysql select top 2
SQL
0 vote358 views1 answer
Close sql query vb.net
SQL
0 vote339 views1 answer
Drop column from table if exist on live server mysql
SQL
2 votes367 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote369 views2 answers
Start mysql server using docker
SQL