Backup Tables by Date

 

declare @sql varchar(max);

DECLARE @DateName nvarchar(100)

SET @DateName=  'NXTRPTEmployeeProfile' + CAST( GetDate()  as NVARCHAR(12) );

SELECT @DateName = REPLACE(@DateName, ' ', '')

 

 Set @sql = 'SELECT * INTO ' +  @DateName +' FROM NXTRPTEmployeeProfile ';

 EXECUTE(@sql)