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

6 votes175 views1 answer
Oracle list primary key
SQL
0 vote191 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
19 votes196 views3 answers
Grant mysql
SQL
11 votes203 views1 answer
How to get ddl for materialized view
SQL
3 votes200 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote230 views1 answer
Add week ending date sql server
SQL
0 vote221 views1 answer
Reset postgresql password windows
SQL
0 vote211 views3 answers
Sql select statements
SQL
0 vote250 views1 answer
SQL Server Enterprise
SQL
0 vote226 views1 answer
How to check rollback status in oracle
SQL