SQL

Tuesday, August 15, 2017

SQL - Rounding off to 2 decimal places

select 
    round(630/60.0,2), 
    cast(round(630/60.0,2) as numeric(36,2))
Posted by Tecknovice at 1:36 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, August 3, 2017

Sử dụng để thay đổi string

Substring()


STUFF

STUFF ( character_expression , start , length , replaceWith_expression )  
Posted by Tecknovice at 2:06 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

About Me

Tecknovice
View my complete profile

Blog Archive

  • ►  2021 (1)
    • ►  January (1)
  • ►  2020 (3)
    • ►  December (3)
  • ▼  2017 (28)
    • ▼  August (2)
      • SQL - Rounding off to 2 decimal places
      • Sử dụng để thay đổi string
    • ►  May (24)
    • ►  April (2)
  • ►  2016 (8)
    • ►  December (6)
    • ►  November (2)
Simple theme. Powered by Blogger.