Sending the same serial number in two tables

Question

0.00/5 (No votes)

See more:

SQL-server-2000

Hi my name is faiz I have been facing a problem in my codes please help me
Problem is I have two tables and fields are

Table1

1          2     3                          4         
Id(guid)   Name  serial No(guid or string)  Price

Table2
1          2     3             4
Id(guid)   name  serial No     location

When i insert data in table1 so I want the same serial number would go in table2 serial number.
How will be the SQL Query and how i will implement in our code .please help me

Posted 20-Jan-12 21:53pm

faizyab 2009

Updated 20-Jan-12 21:57pm

OriginalGriff

v2

Add a Solution

2 solutions

Solution 2

Write stored procedure as below

SQL

CREATE PROCEDURE sp_InsertSerialNumber
(
   @Id UniqueIdentifier ,
   @Name NVARCHAR(255),
   @SerialNo NVARCHAR(255),
   @Price BigInt ,
   @Location NVARCHAR(255)
)
AS
BEGIN
 INSERT INTO Table1
 SELECT @Id,@Name,@SerialNo,@Price

 INSERT INTO Table2
 SELECT @Id,@Name, @SerialNo,@Location
END

Hope this help
--Rahul

Posted 20-Jan-12 22:04pm

RDBurmon

Comments

faizyab 2009 21-Jan-12 14:59pm

Thank you sir .if i don't use store procedure so how i can do it ?

RDBurmon 23-Jan-12 1:06am

Ok Can you post little bit portion of your C# Code so that I will debug and update that code as well.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Catalin Serafimescu · Accepted Answer · 2012-01-20T21:59:00

Solution 1

This[^] should help you

Posted 20-Jan-12 21:59pm

Catalin Serafimescu