Click here to Skip to main content
15,867,330 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
In SQL server, i want to creat a Table Valued parameter.In my Table Valued parameters are EmpID,RecData,insurID and also one Table Valued Parameters.
In sql server is it possible? can i create TVP inside another TVP?
please help me.
Posted
Updated 11-Apr-13 19:15pm
v5
Comments
Mehdi Gholam 12-Apr-13 1:09am    
What is TVP?
Prasad Khandekar 12-Apr-13 1:29am    
Nope. best way is to create two tables and set a foreign key between them. You can then use JOIN to read data from these tables. I presume that you have one to many relation between these two so called TVP.
renjimaramanan mr 12-Apr-13 1:34am    
thanks

 
Share this answer
 
Are you talking about primary and foreign keys?

See this: Primary and Foreign Key Constraints[^]
Create Foreign Key Relationships[^]
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900