Feeds:
Posts
Comments

Posts Tagged ‘Create Table If Not Exists Else Truncate’

IF
OBJECT_ID(‘Table_Name’,‘U’) is not null

 

TRUNCATE
TABLE Table_Name

 

ELSE

 

CREATE
TABLE Table_Name (

   
ID INT ,

   
Product_Name VARCHAR(100)

   

)

 

Advertisements

Read Full Post »

%d bloggers like this: