Use Convert to transform any value into a particular datatype
SQL SQLPosted by admin on 2023-01-29 09:51:45 |
Share: Facebook | Twitter | Whatsapp | Linkedin Visits: 604
This is used to convert a value into a defined datatype. For example, if you want to convert a particular value into int datatype then a convert function can be used to achieve this. For example,
Syntax
1 | SELECT CONVERT(int, 27.64) |
Search
Recent Blogs
- How to Restrict Multiple Instance of VBA?
- Important Shortcuts for Excel VBA
- VBA Code to Highlight Named Ranges
- VBA Code to Highlight Cells with Misspelled Words
- VBA code to Highlight all the Blank Cells Invisible Space
- VBA code to Highlight Unique Values
- VBA Code to Hide all but the Active Worksheet
- VBA Code to Unhide all Hidden Worksheets