sql server: passing the parameter to the view -
how can pass parameter view in sql server.i have stok contain stok info including quantity.i have form , via form added quatitiy stok . need form value of quatitiy , add the stok quantity available values.for need pass parameter view automatically add value current value in stok, thank help
you can use table function such as:
create function [dbo].[tblfunc_aaa] ( @id bigint ) returns table return ( select * mytable aaa = @id )
Comments
Post a Comment