How to Create a Table Name With the Date in T-SQL : Tech Tasks

Subscribe Now:

Watch More:

T-SQL is usually first a transactional sequel, which is what is called when you use SQL Server Management Console. Create a table name with the date in T-SQL with help from an experienced tech professional in this free video clip.

Expert: Jennifer Shin
Bio: Jennifer Shin is the Founder and Principal Consultant at 8 Path Solutions LLC.
Filmmaker: Brandon Gonzales

Series Description: When it comes to technology, it is evolving at such a rapid pace that it can be easy to feel left behind. Learn all about the latest and greatest advancements that technology has to offer with help from an experienced tech professional in this free video series.

[jenniemorel]

I tried this
DECLARE @date varchar(10) = (SELECT CONVERT(date, GETDATE()) )
DECLARE @value NVARCHAR(500) = N'select * into + @date + ' from
EXEC sp_executesql @value

I get the error on line 1: Incorrect syntax near '-'.