TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
SQL Server SP to Clone a Table
Sateesh Arveti
Feb 24
2016
Code
1.1
k
0
0
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
expand
SP_To_Clone_SQL_Tabl
--exec sp_clone_table 'TESTDB','emptable','emptable_1'
--drop PROCEDURE sp_clone_table
create
PROCEDURE
sp_clone_table
@dbName
varchar
(100), @sourcetable
varchar
(200), @desttable
varchar
(200)
as
DECLARE
@SQL NVARCHAR(
MAX
)
BEGIN
IF OBJECT_ID(@dbName +
'.dbo.'
+ @desttable, N
'U'
)
IS
NULL
SET
@SQL =
('
SELECT
*
INTO
' + @dbName +'
.dbo.'+ @desttable +
'
FROM
' + @sourcetable)
ELSE
SET
@SQL=
' INSERT '
+ @dbName +
'.dbo.'
+ @desttable +
' SELECT * FROM '
+ @sourcetable
EXEC
(@SQL)
end
SQL Server
clone table