How to Get SQL Server Data Conversion Horribly Wrong

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

以下SQL Server代码在你不能确定是否可以正常运行的话，建议您细读这篇文章，关于隐式数据转换。

• DECLARE @A CHAR(3) = 'DEF';
• SELECT CASE
•   WHEN @A = 'DEF' THEN 0
•   WHEN @A = 'GHI' THEN 1
•   ELSE 'DOES NOT APPLY'
• END;
• 
  
• GO
• DECLARE @A CHAR(3) = 'ABC';
• SELECT CASE
•   WHEN @A = 'DEF' THEN 0
•   WHEN @A = 'GHI' THEN 1
•   ELSE 'DOES NOT APPLY'
• END;
• 
  
• GO
• DECLARE
•   @A CHAR(3) = 'ABC',
•   @B CHAR(5) = 'DEFGH',
•   @C VARCHAR(10) = NULL,
•   @D INT = 1234;
• SELECT COALESCE(@C, @D, @A);
• 
  
• GO
• DECLARE
•   @A CHAR(3) = 'ABC',
•   @B CHAR(5) = 'DEFGH',
•   @C VARCHAR(10) = NULL,
•   @D INT = 1234;
• SELECT COALESCE(@C, @A, @D);
  

How to Get SQL Server Data-Conversion Horribly Wrong
One of the most certain ways of going wrong with any relational database is to get data conversion wrong. Implicit data conversion is a good feature for the expert but  can cause a lot of trouble to the unwary. These boil down to seven ways of  failing to get data conversion right. Rob Sheldon explains and gives sage advice on how to avoid the problems。


Failure #1: Not understanding data type precedence
Failure #2: Not taking performance into consideration
Failure #3: Assuming all numbers are created equal
Failure #4: Relying on the ISNUMERIC built-in function
Failure #5: Underestimating the world of silent truncation
Failure #6: Not understanding date/time data
Failure #7: Importing Excel data without thought to data types
Failure #8: Treating XML just like any other string
Failure #9: Failing to take portability into account

本帖隐藏的内容

How to Get SQL Server Data-Conversion Horribly Wrong.docx (168.42 KB)

2015-4-22 15:47:13 上传

信息来源：redgate

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：conversion Version Server Serve wrong

谢谢分享~~~

学习学习.

sunyiping 发表于 2015-4-23 14:25
学习学习.

How to Get SQL Server Data Conversion Horribly Wrong