Question: I am developing a quiz app in it I retrieve one question per day date wise and the user has to answer only this retrieved question. I want to disable my button after user submitted his answer and it remains disabled until next day.

Answer: 
You can try 

```
INSERT INTO <database>.<schema>.<table>
SELECT * FROM <source_database>.<schema>.<source_table>

```

After your modification, you need specify columns which you want the insert to the new table. 

So your query could be 

```
INSERT INTO <database>.<schema>.<table>([Column1], [Column1], [Column1])
SELECT [Column1],[Column2],[Column3] FROM <source_database>.<schema>.source_table>

```

As I can see from the error message, you need implicitly define a column type. 

For example: If your column has type DATE you need use CAST(Column AS DATE) AS [Column\_Name].
Try this:

```
Select * into SQLShackDemo.HumanResources.Department 
from AdventureWorks2012.HumanResources.Department 

```