function for sql

ALTER function [dbo].[GetRomanDate]
(
@Date datetime
)
returns varchar(20)
Begin
Declare @RomanDate varchar(20)
select @RomanDate=Convert(varchar(8),@Date,4)+ ' - '+ Convert(varchar(8),@Date,108)
return @RomanDate
End
--------------------------------
ALTER function [dbo].[GetperiodTitle](@Periodid int)
returns varchar(500)
as
begin
declare @title varchar(500)
set @title=(select 'Tema: ' + Periodname as periodname from utbfperiod where bfperiodid=@Periodid)
return @title

End
-------------------------------
ALTER function [dbo].[getCourseString]
(
@kindergarden varchar(100),@city varchar(100)
)
returns varchar(200)
begin
declare @TempString varchar(250)
set @TempString=''
if(@kindergarden=''and @city='')
begin
set @TempString=''
end
else
if(@kindergarden=''and @city <> '')
begin
set @TempString=@city
end
else if(@kindergarden <> '' and @city='')
begin
set @TempString=@kindergarden
end
else if(@kindergarden <>''and @city <> '')
begin
set @TempString=@kindergarden +', '+@city
end



return @TempString
end

tiggers for delete and update

ALTER trigger [dbo].[TRIG_StopDelete_UtBFDiscussion]
on [dbo].[UtBFDiscussion]
for delete as
begin
declare @num_Deleted int
/* Determine how many rows were deleted. */
select @num_Deleted = @@rowcount
if @num_Deleted > 1
Begin
select ' Invalid Operation'
rollback transaction
End
else
Begin
select str(@num_Deleted) + ' row(s) Deleted'
End
End
--------------------------
ALTER trigger [dbo].[TRIG_StopUpdate_UtBFDiscussion]
on [dbo].[UtBFDiscussion]
for update as
begin
declare @num_updated int
/* Determine how many rows were updated. */
select @num_updated = @@rowcount
if @num_updated > 1
Begin
select 'Invalid Operation'
rollback transaction
End
else
Begin
select str(@num_updated) + ' row(s) Updated'
End
End

Find Second Heighest salary

select top 1 t1.salary from
(select top 2 salary from dbo.tdemos order by salary desc)t1 order by salary asc