Thursday, February 2, 2017

Basics SQL 3


        



                        
                              

Tuesday, November 29, 2016

CHILD_RECORD_FOUND Equivalent in SQL Server

HI All..,,

for CHILD_RECORD_FOUND in Oracle , in SQL Server is Error_number = 547


begin try
---------
----------
end try
 begin catch 

     if @errornumber = 547
     print 'Unable to delete Parent , as child record exists'
 end catch



for 547 ===> delete statement conflicted with the reference constraint

Wednesday, November 23, 2016

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.