declare @a varchar (50) set @a= '8737.0*13.42/3.49' declare @b float(20) CREATE TABLE #t1 (a float) exec ('INSERT INTO #t1 VALUES (cast ('+@a+' as float))') set @b = (select a from #t1) drop table #t1 print @b
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionexec ('INSERT INTO #t1 VALUES (cast (1.0*'+@a+' as float))')