To Know , which Service Pack and version is installed of SQL Server 2005

SELECT SERVERPROPERTY('productversion') as productversion




,SERVERPROPERTY('productlevel') as productlevel



,SERVERPROPERTY('edition') as edition

Using Temp Table in Functions

CREATE TABLE #t (id INT)

GO

INSERT INTO #t VALUES (1),(2),(3)

GO

CREATE SYNONYM tSynonym FOR #t

GO

CREATE FUNCTION fnSTempTbl ()

RETURNS TABLE

AS

RETURN

(

SELECT * FROM tSynonym

)

GO

SELECT * FROM  fnSTempTbl ()

GO