The login is for authentication, the user is for authorization. Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

Dynamic SQL are those SQL which gets the value at runtime. I am sharing one simple example and i hope this will help you. Declare @table Varchar(25), @Sql Varchar(25) BEGIN SELECT @table='TB_Emp' Select @Sql= 'SELECT Count(*) FROM' + @table exec (@sql) END For more details refer google or SQL Online Help. Amit

I think u r right we should avoid cursors as far as possible...I have a query of Dynamic sql how can I use it in a while loop?please help:confused:

functions return only one value.........sp can used to return more than one value.... function need to be complied each time u use....but sp ones complied u can use it...till if cant change any thing:)

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 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) 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 @Desc, @added_date, @Added_by, @ItemNo output execute dbo.Ks_Ins_Media_Item_content @ItemNo,@content, @textlength --EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters

Paste ur code here and we will solve problem

Hi, what do you want to exactly with this, or better how do you want to use it? I think for storing it into another variable you can something like: SELECT @@identity into @myVariable or using it within a query SELECT * FROM my_table where my_PK = @@identity Hope this helps, regards Sebastian

what you have to do is to first insert the record in the table. Then put @@IDENTITY in a local variable like this: @TempVar = @@IDENTITY this line will be there just after the insert statement. And then you can pass this local variable(@TempVar) to the second stored procedure. Best Regards, Apurva Kaushal

plz see sqlsetup.log for detail information in %windows% folder.

exec A quick google returns this example[^]. Michael CP Blog [^] Development Blog [^]

Sage wrote: You know that that post had been directed to Yazan dont you? I wondered about that. You replied to my message though (so I got the email notification), not Yazan's message. Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

Also, if you revoke access to the actual tables to the users and do everything through Stored Procedures then you increase the security of the application because then the the users can only do what is specified in the Stored Procedure and cannot do anything else. Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

Sorry, your question is....? Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

And also stored procedure are pre comiled thing so not compiling it everytime you execute that unlike normal sql queries. Best Regards, Apurva Kaushal

yazan_zahi wrote: why we shouled using the stored procedure vs asp.net ?? The two things are not the same. You cannot write database code in ASP.NET. Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog