Sql Dependable table Query

Posted on 2013-11-05
Last Modified: 2014-01-21
There are 3 Tables
I just want to know How to data enter Dependable table

01. Supplier Table (Primary key v_s_code)
02. Product table (Primary key v_P_code)
03. Supplier_Product table ( Dependable table and Foreign keys v_s_code(Supplier Table),v_P_code(Product table))

I wrote following Stored Procedure for insert data

ALTER procedure [dbo].[addSuppliers]
@v_s_code	nvarchar(50),
@v_Supplier_Company	nvarchar(100),
@v_S_Address1	nvarchar(100)	,
@v_S_Address2	nvarchar(100)	,

@v_S_City	nvarchar(50)	,

@v_S_Country	nvarchar(50)	,

@v_S_Telephone	nvarchar(100)	,
@v_S_Email	nvarchar(100)	,
@v_s_Description	nvarchar(MAX),	
@v_P_code nvarchar(50),

@Results int OUTPUT 
DECLARE @c_P_Active CHAR(1)
SET @c_P_Active='Y'
SET @EnterDate=GETDATE()

SELECT @Results=(CASE WHEN COUNT(v_s_code)=1 THEN 1 ELSE 0 END )  from  Supplier where v_s_code=@v_s_code

if @Results=0
INSERT INTO Supplier (v_s_code,v_Supplier_Company,v_S_Address1,v_S_Address2,v_S_City,

INSERT INTO Products_Supplier(v_s_code,v_P_code)VALUES(@v_s_code,@v_P_code)



Open in new window

I need to proper way to insert records into dependable table.this correct or if not can any one kindly show me what is the best way
Question by:ukerandi
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 11

Assisted Solution

HuaMinChen earned 250 total points
ID: 39626212
You have to insert record to both product and supplier tables first, then you can insert records into Supplier_Product table.
LVL 10

Accepted Solution

ukerandi earned 0 total points
ID: 39626740
yes i already inserted Data to Product Table.

I just want to know What is the best way to Insert data to Dependable table,
any example much appriciate

Assisted Solution

rajeevnandanmishra earned 250 total points
ID: 39627054

If you are getting all the given information together, then the approach used by you is good. But I suggest that you should be verifying the existence of @v_P_code in [Product Table] in similar way as you are checking in the [Supplier Table].
Once verified, then you should
1. Insert in Supplier Table (if not exists)
2. Insert in Product Table (if not exists)
3. Insert in Supplier_Product Table

I am not sure that what business logic you are following, but if there are possibility of calling the procedure with already entered record in [Supplier_Product] table, then you need to do a check before inserting in this table also.
LVL 66

Expert Comment

by:Jim Horn
ID: 39628453
Curiosity overwhelms me .. what's an 'un-Dependable table'?
LVL 10

Author Closing Comment

ID: 39796453

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question