Copy one data from another table in SQL Server

select * into newTable from OldTable
where newtable is ur new table name
and old table signify ur old table name from
ex.
Select * into tbluser_login from tblAdmin_login

Hope this will help you
Thanks
ROHIT SRIVASTAVA