sql server stored procedure

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

i have two tables named detail

SQL

table and employee.detail table in which values are detailid,desigid,allowancename,createddate,createdby,updateddate,updatedby etc
 and
 employee table contains desigid,desigcode,designame etc.
I need to pass detail table values to a single parameter and at the same time i want to pass values to both these tables (using table valued parameters).Can you help me for completing my doubt please.

Posted 5-Dec-12 18:51pm

renjimaramanan mr

Updated 5-Dec-12 19:24pm

v3

Add a Solution

Comments

Patel Shailendra 6-Dec-12 1:04am

you want to create procedure to insert values in both the table.

renjimaramanan mr 6-Dec-12 1:10am

ya

Patel Shailendra 6-Dec-12 1:22am

i think you have to create designation table first and this table is inserted by admin and employee.details is other procedure for fast insertion and it is inserted by employee. its better to create two different procedure then creating single procedure.

renjimaramanan mr 6-Dec-12 1:35am

thanks...

2 solutions

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)

Anurag Sinha V · Answer 1 · 2012-12-05T19:38:00

Hi again,

I guess I understood your requirement.
You want to pass a table variable in stored procedure as a parameter... :)
Well first you will need to define the structure of the table.
ex:

SQL

create table A(
AId int primary key,
AName varchar(20))

Then create a Table type and declare its structure too.

SQL

create type AType as Table(
AId int,AName varchar(20));

Thn create a Stored Procedure having table type as parameter:

SQL

create procedure Test
 @x AType
 as
 insert into A(AId,AName)
 select * from @x;
go

Next step would be to declare a table type variable and refer it to the tabletype wch we have created:

SQL

declare @y as AType;

Then insert some values in the above parameter..which shud be the actual data wat u wana enter..
Then pass this parameter to the stored proc n execute the stored proc.

SQL

insert into @y(AId,AName)
 values(1,'Adidas')
 (2,'Nike');

SQL

exec Test @y ;

Here you go...you are done...Happy Coding... :)

Anurag Sinha V · Answer 2 · 2012-12-05T19:08:00

Solution 1

Hi,

The question which you have asked is unclear.
Can u rephrase it correctly,i.e what exactly you wana do?

Posted 5-Dec-12 19:08pm

Anurag Sinha V

Comments

renjimaramanan mr 6-Dec-12 1:13am

i want pass values of a table to a parameter