1.
declare @je varchar(64),@sql nvarchar(4000),@NewFormatCode Varchar(20)
set @je= '1,200.00元'
set @sql=N'select @NewFormatCode = left(replace('''+@je+N''','','',''''),len(replace('''+@je+N''','','',''''))-1)'
select @sql
EXEC sp_executesql @Sql ,N'@NewFormatCode varchar(20) Output',@NewFormatCode Output
Select @NewFormatCode as '123456'
2.
declare @je varchar(64),@sql nvarchar(4000),@NewFormatCode Varchar(20),@VALUE VARCHAR(1000)
set @je= '1,200.00元'
SELECT @VALUE = 'left(replace('''+@je+N''','','',''''),len(replace('''+@je+N''','','',''''))-1)'
set @sql=N'select @NewFormatCode = ' + @VALUE
select @sql
EXEC sp_executesql @Sql ,N'@NewFormatCode varchar(20) Output',@NewFormatCode Output
Select @NewFormatCode as '123456'
declare @je varchar(64),@sql nvarchar(4000),@NewFormatCode Varchar(20)
set @je= '1,200.00元'
set @sql=N'select @NewFormatCode = left(replace('''+@je+N''','','',''''),len(replace('''+@je+N''','','',''''))-1)'
select @sql
EXEC sp_executesql @Sql ,N'@NewFormatCode varchar(20) Output',@NewFormatCode Output
Select @NewFormatCode as '123456'
2.
declare @je varchar(64),@sql nvarchar(4000),@NewFormatCode Varchar(20),@VALUE VARCHAR(1000)
set @je= '1,200.00元'
SELECT @VALUE = 'left(replace('''+@je+N''','','',''''),len(replace('''+@je+N''','','',''''))-1)'
set @sql=N'select @NewFormatCode = ' + @VALUE
select @sql
EXEC sp_executesql @Sql ,N'@NewFormatCode varchar(20) Output',@NewFormatCode Output
Select @NewFormatCode as '123456'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/20854791/viewspace-591137/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
关于oracle中rownum的使用探讨
下一篇：
SQL写的9×9乘法表 【转载修改】
请登录后发表评论
登录
全部评论
