Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. select convert(nvarchar(255), 4343)
  2.  
  3. declare @MyNumber int
  4. set @MyNumber = 123
  5. select 'My number is ' + CAST(@MyNumber as nvarchar(20))
  6.  
  7. declare @MyNumber float
  8. set @MyNumber = 123.45
  9. select 'My number is ' + CAST(@MyNumber as nvarchar(max))
  10.  
  11. DECLARE @value DECIMAL(19,4) = 1505.5698
  12. SELECT CONVERT(NVARCHAR, @value) --> 1505.5698
  13. SELECT FORMAT(@value, 'N2', 'en-us') --> 1,505.57
  14. SELECT FORMAT(@value, 'N2', 'de-de') --> 1.505,57
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement