SQL interview question Summary

-- Recursion of functions in SQL Server; -- by, 13... calculate the first occurrence number. If exists (select * From sysobjects where id = object_id (N 'P', 'fn ') begindrop function p; endgocreate function p (@ I int) returns INTAS begindeclare @ return int; If @ I = 0 beginset @ return = 0; endelse if @ I = 1 beginset @ return = 1; endelsebeginset @ return = DBO. P (@ I-1) + DBO. P (@ I-2); endreturn @ return; endgoselect DBO. P (30); go -- query data from 31 rows to 40 rows select * from (select *, row_number () over (order by number ASC) as ID from DBO. spt_values) A where ID between 31 and 40;