Insert from one table onto another in SQL Server using Query

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on Oct 23, 2012 03:29 AM
Forum: SQL Server
Answer: 1
Views: 3078

I have 2 Table in database

1-Estate_p

Id	Behcode	H_name	Tell	address
1	1111	house	1345668	Paris
2	1111	House2	56989898	Canada
3	4444	House3	568989885	india

2-Estate_s

Id	Behcode	H_name	Tell	Position

I have 1 button in edit.aspx page

now I want when users click on button in edit.aspx page according to users Id it insert behcoede and H_name and Tell columns value from Estate_p Tabel into Estate_s tabel How I can do it?

Best regards

Download FREE API for Word, Excel and PDF in ASP.Net

RkHirpar...

0 1

Reply
ANSWER
User: RkHirpara
Replied: on Oct 23, 2012 03:41 AM
Report

on button click call following stored Procedure

CREATE PROCEDURE [dbo].[InsertUserDetails] 
@UserId VARCHAR(50)
AS
BEGIN
	SET NOCOUNT ON;
	INSERT INTO Estate_s(Behcode,H_name,Tell)
	SELECT Behcode,H_name,Tell FROM Estate_p
	WHERE ID = @UserId 
END

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Insert from one table onto another in SQL Server using Query

Company

Explore

Follow us

Contact Us