Friday 21 June 2013

bulk insert from one table to another table

In this article we will see how to insert store procedure output to sql table.
example::
1)Create table::
A)

Create table emp (id int ,emp_name varchar(100))
Insert into emp (id,emp_name)values(1,'raj')
Insert into emp (id,emp_name)values(2,'sham')
Insert into emp (id,emp_name)values(3,'ram')
Insert into emp (id,emp_name)values(4,'ss')
Insert into emp (id,emp_name)values(5,'d.raj')
Insert into emp (id,emp_name)values(6,'pranav')
Insert into emp (id,emp_name)values(7,'pranav')
Insert into emp (id,emp_name)values(8,'aditya')
Insert into emp (id,emp_name)values(9,'aditya')

B)
Create table #temp (id int ,emp_name varchar(100))


2)insert bulk data from one table to another by using select .

insert into #temp (id,emp_name)select id,emp_name from emp
select * from #temp


3)insert bulk data from one table to another by using select with where clouse.

insert into #temp (id,emp_name)select id,emp_name from emp where emp_name='pranav'
select * from #temp


4)Create copy of table with data ,or create backup of table.
select id,emp_name into #temp1 from emp
select id,emp_name into #temp2 from emp where emp_name='pranav'

Related Posts

Column in comma separated strings
Pivot Unpivot data in sql server
Combine two or more column in one column in sql sever
rank fuctions in sql
Get month wise Number of working
Take Back up of table using select statement in sql server
Column data in comma seprated string
Delete duplicate records from table
Date function in sql server
Sql server::String with initial letter in uppercase.
Joins in Sql server
Dynamic Query in sql server
Basic About View
send sql table data via email using store procedure
How to use Store Procedure inside a store procedure
SET ANSI_NULLS in sql server
SET QUOTED_IDENTIFIER in sql
example of Cursor in sql server
basic of Cursor in sql.
delete duplicate records in sql server
select duplicate records in sql server
update duplicate records in sql server
comman table expression(CTE) in sql server
Split Funtions in sql server
Sql queries for sql server
Trigger on Update
Trigger on insert
trigger on delete
basic of trigger
insert into view with multiple tables
Insert into View in sql server
Interview queries in sql server
update data in view with multiple table
Update view with single table
Group by in sql server
pivot without aggregate function in sql
loop in sql server
get monthwise calender in sql server
temp table and temp variable in sql server

No comments:

Post a Comment

if you have any doubt any suggestions do comment