This is basically used for drop table using if exists in sql server. The example as given below.
IF OBJECT_ID('TEMPDB..#SPLETEDTEMPTABLE') IS NOT NULL
DROP TABLE #SPLETEDTEMPTABLE
CREATE TABLE #SPLETEDTEMPTABLE(ID INT, SERVICES VARCHAR(300))
INSERT INTO #SPLETEDTEMPTABLE EXEC GET_SPLITED_TABLE 'Anil Singh India', '-'
|
Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
|