what is the deferunt between login and user

what do we mene by daynamic sql in sql server 2000 and how can iuse them

what are advantige and disAdvantige of using the cursor

when we use function ? when we use stored procedure ? how can i defin a function (syntax)? Witch better to use function or sp ? can you be fast pls ??? thank you ?

--1fst sp CREATE PROCEDURE Ks_Ins_Media_Item @Desc nvarchar(200), @added_date datetime, @Added_by nvarchar(100), @item int output As insert into Ks_Media_Item ([Description],Added_Date,Added_By) values(@Desc,@added_date,@Added_by) set @item = @@identity ============================ --2sd sp CREATE PROCEDURE Ks_Ins_Media_Item_content @Item_No int, @content ntext, @textlength int As insert into Ks_Media_Item_content(Item_no,content,text_length) values(@item_no,@content,@textlength) ======================================== --3rd sp CREATE procedure ks_media_item_full_data @Desc nvarchar(200), @added_date datetime, @Added_by nvarchar(100), @content ntext, @textlength int as declare @ItemNo int execute dbo.Ks_Ins_Media_Item @item output,@Desc, @added_date, @Added_by execute dbo.Ks_Ins_Media_Item_content @ItemNo output,@content, @textlength =================================== can you help me i want to pass yhe output parameter to 3rd sp becuse 1st the Item_no is identity yes and in 2sd sp identity false how can i do it pls

it's cannat run can i pass the code to you yo see the error thank you

i have procedure with output parametr i have to pass it to another procedure in execution what is the syntax of it pls

how to use the @@identity function in stored procedure pls

my DBA wants that sorry i do not undrstand can you send the sentax to me pls and thank you alot

i have tow stored procedure i put them in one procedure the 1fst have the primary key idntity value the seconed have the forign key how ican solve the problem by passing the value to the 2nd procedure ================================= i will pass th procedure to u : create procedure ks_media_item_full_data @Item_No int, @Desc nvarchar(200), @added_date datetime, @Added_by nvarchar(100), @content ntext, @textlength int as execute dbo.Ks_Ins_Media_Item @Item_No, @Desc, @added_date, @Added_by execute dbo.Ks_Ins_Media_Item_content @Item_no,@content, @textlength ======================================== can you help me pls fast yazan

a service control operation failed for the mssqlserver service :2 the system cannot find the file specified can you help fast pls

how to execute tow procedure in one procedure his job is to add data

i need to wirte these stored procedures 1- Add recored to the table 2- use the above sp's to add the full data for the item in the tables(ks_media_item ,ks_media_item_content) 3- update the data in the table ks_media_item -if the value of item_no not found print msg "record not found " -the columns (update_By , Udated_Date)willfill 4- Rturn the all data Based on the Item_No from the tow tables the tables are : Ks_Media_Item(Item_no,Description,Added_Date, Added_By,Update_By,Updated_Date) 2- Ks_Media_Item_Content(Item_no,content,Text_Length) i hope to answer me thank you all yazan_shalabi

add recored to the table ks_Media_item -if the same Item_no Value Found in the table Print msg"Record found"and exit the procedure -the columns (Updated_by,Updated_Date)will be null the tabel columns (Item_no,Decription,Added_Date, Added_By,Updated_by,Updated_Date) thank you;

we write the stored procedure in sqlserver2000 (update,insert,select)that better than write the statment it in asp.net code why ???

add recored to the table ks_Media_item -if the same Item_no Value Found in the table Print msg"Record found"and exit the procedure -the columns (Updated_by,Updated_Date)will be null the tabel columns (Item_no,Decription,Added_Date, Added_By,Updated_by,Updated_Date) thank you; yazan_shalabi

we write the stored procedure in sqlserver2000 (update,insert,select)that better than write the statment it in asp.net code why ??? yazan_shalabi

why we shouled using the stored procedure vs asp.net ?? yazan_shalabi

why we shouled using the stored procedure vs asp.net ??

why we should using the stored procedure vs asp??