Monday, October 24, 2016

Equivalent of TO_NUMBER of Oracle in SQL Server

Hi all...

Here is the equivalent of TO_NUMBER of Oracle in SQL Server is...



Oracle
SQL Server
Select TO_NUMBER('123') from dual;
Select CONVERT(INT,'123') 
        OR
Select CAST('123' as INT) 

No comments:

Read data from csv in R Programming

Read a data set from csv file.. x <- read.csv(file.choose(),header=TRUE) here x is the R data set vaiable.