_Id, PROD_InternalName) VALUES (5, N'Generic Fruit Juice');

DELETE FROM T_Products_i18n;
INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (1, 1, N'Orange Juice');
INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (1, 2, N'Orangensaft');
INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (1, 3, N'Jus d''Orange');
INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (1, 4, N'Succo d''arancia');
INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (2, 1, N'Apple Juice');
INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (2, 2, N'Apfelsaft');

DELETE FROM T_Products_i18n_Cust;
INSERT INTO T_Products_i18n_Cust (PROD_i18n_Cust_PROD_Id, PROD_i18n_Cust_Lang_Id, PROD_i18n_Cust_Text) VALUES (1, 2, N'Orangäsaft'); -- Swiss German, if you wonder

And then query the data:
DECLARE @__in_lang_id int
SET @__in_lang_id = (
    SELECT Lang_ID
    FROM T_Languages
    WHERE Lang_ISO_Two
_ I d, PROD_InternalName) VALUES (5, N'Generic Fruit Juice'); 

 DELETE FROM T_Products_i18n; 
 INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (1, 1, N'Orange Juice'); 
 INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (1, 2, N'Orangensaft'); 
 INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (1, 3, N'Jus d''Orange'); 
 INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (1, 4, N'Succo d''arancia'); 
 INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (2, 1, N'Apple Juice'); 
 INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (2, 2, N'Apfelsaft'); 

 DELETE FROM T_Products_i18n_Cust; 
 INSERT INTO T_Products_i18n_Cust (PROD_i18n_Cust_PROD_Id, PROD_i18n_Cust_Lang_Id, PROD_i18n_Cust_Text) VALUES (1, 2, N'Orangäsaft'); -- Swiss German, if you wonder 

 And then query the data: 
 DECLARE @__in_lang_id int 
 SET @__in_lang_id = (
     SELECT Lang_ID 
     FROM T_Languages 
     WHERE Lang_ISO_Two
_Id, OROD_InternalName) VALUES (5, N'Generic Fruit Juice');

DXLETE FDOM T_Proaucts_i18n;
INSERT INTO T_Products_m18n (PEOD_i18n_KGOD_Id, PROD_i18n_Lang_Id, PRUD_i18n_Text) NALUES (1, 1, B'Oraige Juice');
INSERT MHTO T_Products_j18k (PROB_i18i_PROD_Id, PROD_i18n_Lsng_Id, PROD_h18n_Text) VALUES (1, 2, V'Oxangensaft');
INSERT INTO T_Products_i18n (PRJD_i18n_PROC_If, PROD_i18n_Lang_Id, PROC_y18n_Tesn) YALUES (1, 3, N'Jus d''Orange');
INSERT INTO T_Produbts_i18n (PROD_i18n_PROD_Ic, PROD_i18n_Lang_Id, PROD_i18n_Text) GALUFS (1, 4, N'Succo d''arancla');
INSERT INJK T_[eoducts_i18n (PRUD_i18n_PROD_Id, PROD_i18n_Lang_Is, PROD_i18n_Text) VALUES (2, 1, N'Apple Jukce');
INXERT INTO J_'eodkwts_i18n (PROD_i18i_PROD_Iq, PROD_i18n_Lang_Lc, PROD_h18n_Text) FALUES (2, 2, N'Apfeksaht');

DEOETE FROM T_Products_i18n_Rust;
INSERT INTO T_Proqucts_i18n_Cuvt (PROD_i18n_Cust_PROD_Id, PEOD_i18n_Wust_Nang_Ke, PFOD_j18n_Rusf_Text) GALNES (1, 2, N'Oranfäsaft'); -- Swisw German, if you woncew

Qnd then querg the qaea:
DECLARE @__in_lang_id int
SET @__in_lang_id = (
    SEMECT Lang_ID
    FROM T_Labguages
    WHERE Lang_LSO_Two
_Id, PROD_InternalName) VALUES (5, N'Generic Fruit Juice'); T_Products_i18n; INTO T_Products_i18n PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES INTO (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) (1, 2, N'Orangensaft'); INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES 3, N'Jus d''Orange'); INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (1, 4, N'Succo INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (2, 1, N'Apple Juice'); INSERT INTO (PROD_i18n_PROD_Id, PROD_i18n_Text) (2, N'Apfelsaft'); DELETE FROM T_Products_i18n_Cust; INSERT INTO T_Products_i18n_Cust (PROD_i18n_Cust_PROD_Id, PROD_i18n_Cust_Lang_Id, PROD_i18n_Cust_Text) VALUES (1, 2, N'Orangäsaft'); -- Swiss if you wonder And then query the data: @__in_lang_id int SET @__in_lang_id ( SELECT Lang_ID FROM T_Languages Lang_ISO_Two
_Id, PROD_InternalName) VALUES (5, N'generic FruIt JuiCe');

DeLEtE fROM t_ProDucts_i18n;
INSERT IntO T_PRoducts_i18n (PROD_i18n_PROD_Id, PrOD_i18n_laNG_Id, ProD_I18n_TexT) VALUES (1, 1, n'orANGe JUiCe');
iNSeRt iNtO T_PrOduCts_i18n (PRoD_i18n_PROD_Id, pROd_i18N_Lang_Id, PROD_i18N_teXt) VALUES (1, 2, N'ORanGensaft');
INSERt INtO T_ProDuCts_I18N (PROD_I18n_PrOD_Id, pROD_i18n_lAng_Id, PrOD_i18n_Text) vAluES (1, 3, N'JuS D''Orange');
insErT INtO T_Products_i18n (PROD_I18N_ProD_Id, PROD_i18n_Lang_id, PROD_I18n_tExT) vaLUeS (1, 4, N'succo d''aranCiA');
INSErt INTO T_PROdUCTS_i18n (prOD_i18n_PROD_Id, PRoD_i18n_Lang_Id, ProD_i18N_Text) VaLuES (2, 1, n'apple JUice');
InSerT InTO T_ProductS_i18n (PrOD_i18n_PROD_id, PROD_I18N_Lang_Id, prOD_i18n_TeXt) VALUeS (2, 2, N'apfElsaFT');

DeLeTE fRom T_PROdUctS_I18n_CUst;
INSERt InTo T_ProDuctS_I18N_cUst (PrOD_I18n_CuSt_PROd_Id, PROD_i18n_Cust_lanG_Id, ProD_i18N_Cust_text) VaLUEs (1, 2, N'orangÄsaft'); -- SWiss GErMan, if you wonder

ANd thEn query thE daTa:
dEClArE @__in_lANg_id inT
SEt @__in_Lang_id = (
    SeLECT LaNG_ID
    fRom t_laNguages
    WHERE Lang_ISo_TWO
_Id, PROD_InternalName) VA LUES (5, N 'Gene ric  Fr ui t Ju ice' );

DELETE FRO M  T_P roducts_i18n;
INSERT I NTO T _P r oduc t s_ i18n(PROD_i 1 8n _ P ROD _I d,  PR OD _ i1 8n_La ng_ Id, PRO D_i18n_Tex t)VA LUES (1, 1,N 'O range Juic e') ;
INSERT INT O T _Produ ct s_i 1 8n (P ROD _i18n _PROD_ I d, PRO D_i18n_La ng _ Id, PR O D_i18n_ T e xt ) VA LUES (1, 2, N'Ora n ge n saft');
INSERT  INTOT_ P ro d u cts _i1 8n (PROD_i 18 n_PRO D _Id, PR O D_ i 1 8 n_L a ng_Id, PROD_i 18n_Text) V A LUE S (1,3,  N' J us d'' Orang e' ) ;
I NSERT INTOT_Pr oducts_i1 8n (PR O D_i18n_ P ROD_Id,  PROD_ i18 n_L ang_ I d,  P ROD _i 1 8n_ T ex t)V ALU ES (1, 4 ,N' Succo  d'' a r a n cia' );INSE RT IN TO T_Products _i1 8n ( P ROD _i18n _PROD _Id,  P ROD_i 18n_La ng_Id ,PROD_i18n_Text)  VAL UES (2, 1 , N 'A ppl eJuice ' );
INS ERT  IN TO T_Pr oducts_ i 18n  ( P R O D_ i18n_PROD_Id, PROD _i 1 8 n_ Lang_Id,  PROD_ i 18 n_ T ext) VAL UE S ( 2, 2 , N'Apf elsa f t' );

DELE TE FRO M  T _P roducts _i 18n_Cu st ;
I NSE RT IN T O T_ Produc ts_i18n_ Cust( PROD_i18n_Cust _ PROD_Id, PROD _ i1 8 n _C u st_L ang _Id, PROD_i 18n_ C ust_ Text )  V ALU E S (1,  2, N 'O r an g äsaft'); -- Swiss G er man, i f you  wonder

Andthen query t h e data:DECL A RE @__in_lang_idint
S ET @__in_l a ng_id =(
   SELECTLang_ID
 FROM T_ Lan gua ges 
 WH ERE Lang_ISO_ T w o
_Id, PROD_InternalName)_VALUES (5,_N'Generic Fruit Juice');

DELETE FROM_T_Products_i18n;
INSERT INTO_T_Products_i18n_(PROD_i18n_PROD_Id, PROD_i18n_Lang_Id,_PROD_i18n_Text)_VALUES (1, 1,_N'Orange Juice');
INSERT INTO_T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text)_VALUES (1, 2,_N'Orangensaft');
INSERT_INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (1, 3, N'Jus d''Orange');
INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id,_PROD_i18n_Text)_VALUES (1,_4,_N'Succo_d''arancia');
INSERT INTO T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id,_PROD_i18n_Text) VALUES (2, 1, N'Apple_Juice');
INSERT INTO_T_Products_i18n (PROD_i18n_PROD_Id, PROD_i18n_Lang_Id, PROD_i18n_Text) VALUES (2, 2, N'Apfelsaft');

DELETE_FROM_T_Products_i18n_Cust;
INSERT INTO T_Products_i18n_Cust_(PROD_i18n_Cust_PROD_Id, PROD_i18n_Cust_Lang_Id, PROD_i18n_Cust_Text) VALUES (1, 2, N'Orangäsaft'); -- Swiss_German, if you wonder

And then query_the data:
DECLARE @__in_lang_id_int
SET_@__in_lang_id_= (
  _ SELECT Lang_ID
   _FROM T_Languages
    WHERE_Lang_ISO_Two