Amit Kumar

Amit Kumar

  • NA
  • 140
  • 40.9k

how to call sql function from asp page

Nov 28 2013 12:23 PM
this is my sql function 
create fuction [dbo].[Book_id](@id int)
returns char(12)
as begin
return 'BK00ID' + right('00000' + covert (varchar(10), @id),5)
end

i have created this function because i want when ever i enter others column of table Book_id column will automatically filled .

Answers (1)