INSERT – Basic

Insert one row with default values for all table columns:

INSERT INTO [dbo].[SampleTable] DEFAULT VALUES

SELECT INTO and specify a filegroup (2016 SP2+):

SELECT * 
    INTO [dbo].[SampleTable_Copy] ON [OtherFilegoup]
FROM [dbo].[SampleTable]