Viewing 5 posts - 1 through 5 (of 5 total)
Hi,
Use Return statement in the stored proc instead of "select person_id"
then
Declare @outvariable int
Exec @outvariable=getuser(<the required parameters>
select ourresult=@outvariable
I trust this clears u...
January 27, 2005 at 5:55 am
#539310
Use this
select
rank() over (order by
January 21, 2005 at 5:24 am
#538477
column_name from information_schema.columns where table_name
January 21, 2005 at 4:34 am
#538474
hi,
Try doing this
substring(cast(getdate()
January 21, 2005 at 4:22 am
#538472
Create
PROCEDURE ReturnColumns
/******************/
--Created by Muralikrishna
-- @ num holds the number of columns to be selected
-- @ tabname holds the...
January 20, 2005 at 2:07 am
#538250