随笔分类 - sqlserver

sqlserver 数据类型转换报错

摘要：IF @ldPropertyValue ='' BEGIN IF EXISTS( SELECT 1 FROM dbo.table1 WHERE DataType IN('decimal','int') AND PropertyItemNo = @ldColumnName) BEGIN SET @ld 阅读全文

posted @ 2021-11-11 19:33 ningmou 阅读(120) 评论(0) 推荐(0)

sqlserver 数字转金额

摘要：declare @num decimal(20);set @num = 123456789; SELECT @num, FORMAT(@num, 'N', 'en-us') AS 'Number Format' , FORMAT(@num, 'G', 'en-us') AS 'General For 阅读全文

posted @ 2021-10-15 17:52 ningmou 阅读(492) 评论(0) 推荐(0)