no

(select top 1 *from phone where phone=@phone) -- this is not a problem

tO ARTICLE

I corrected

topic is closed

thank you very much

I have not seen

sorry

I have changed procedure

this

(SELECT TOP 1 Kod FROM natiq.kateqor WHERE NAME = @kateqoriya )

And it worked

THANK YOU VERY MUCH

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[insyenicek11] @phone NVARCHAR(20)

, @SertiNom NVARCHAR(50)

, @ASA NVARCHAR(100)

, @telUnvan NVARCHAR(100)

, @kateqoriya NVARCHAR(100)

, @SHesab NVARCHAR(20)

, @Alam NVARCHAR(60)

, @TelTarix NVARCHAR(50)

, @MuqBasTar NVARCHAR(50)

, @MuqSonTar NVARCHAR(50)

, @Milliyet NVARCHAR(60)

, @Cinsi...

THANK YOU VERY MUCH

create procedure insert11

@kat nvarchar(50)

as

select * from kateqor where Name=@kat

exec insert11 N'M?nzild? qurum'

but the problem is that I need to send only @kat

without N '

how mak i create proc

execute only...

THANK YOU VERY MUCH VETERAN

but i created this

create procedure inserttable1

@phone int,

@n nvarchar(30),@f nvarchar(30),@c nvarchar (30),@t nvarchar(30)

as

insert table1

(phone,kod_name,kod_fname,kod_country,kod_auto)

select @phone,(select kod from table2 where name_=@n),(select kod from table3 where f_name=@f),

(select...

i created procedure

but this procedure inserted only phone

create procedure inserttable1

@phone int,

@n nvarchar(30),@f nvarchar(30),@c nvarchar (30),@t nvarchar(30)

as

insert table1 select @phone,(select kod from table2 where name_='@n'),(select kod from table3 where...

create table table1 (phone int,kod_name int ,kod_fname int,kod_country int,kod_auto int) --

create table table2 (name_ nvarchar(30),kod int)

insert into table2 values('james',1)

insert into table2 values('stivens',2)

insert into table2 values('carlos',3)

create table table3...

create table table1 (phone int,kod_name_d int ) --

create table table2 (nam_d nvarchar(30),kod int)

insert into table2 values('james',1)

insert into table2 values('stivens',2)

insert into table2 values('carlos',3)

create procedure inserttable1

@phone int,

@name varchar(30)

as

insert table1

select @phone,

kod

from...

create procedure inserttable1

@phone int,

@name varchar(30)

as

insert table1

select @phone,

kod

from table2

where nam_d = @name

go

i have a query for 2 tables

bur hier 6 tables

this is diffucult for me

but

for me this query very diffcult

how i make create procedure

insert