Frank Kalis

USE MASTER
GO
SELECT
	CASE OBJECTPROPERTY(id, 'IsMSShipped')
		WHEN 1 THEN 'Bei Installation erzeugt'
		WHEN 0 THEN 'Nicht bei Installation erzeugt'
	END AS [Bei Installation Erzeugt]
	, CAST(name AS CHAR(30)) AS [name]
FROM
	sysobjects 
WHERE
	name = 'sp_helpdb'
OR
	name = 'sp_MBL_SORT'

Bei Installation Erzeugt       name                           
------------------------------ ------------------------------ 
Bei Installation erzeugt       sp_helpdb                     
Nicht bei Installation erzeugt sp_MBL_SORT                   

(2 row(s) affected)

SELECT
	DATEPART(yy , GETDATE()) AS Jahr
 	, DATEPART(qq , GETDATE()) AS Quartal
 	, DATEPART(mm , GETDATE()) AS Monat
	, DATEPART(dd , GETDATE()) AS Tag
	, DATEPART(hh , GETDATE()) AS Stunden
	, DATEPART(mi , GETDATE()) AS Minuten
	, DATEPART(ss , GETDATE()) AS Sekunden
	, DATEPART(ms , GETDATE()) AS Millisekunden
	, DATEPART(wk , GETDATE()) AS Woche


Jahr      Quartal   Monat     Tag       Stunden   Minuten   Sekunden  Millisekunden Woche
--------- --------- --------- --------- --------- --------- --------- ------------- -----
2004      2         6         23        11        23        59        513           26

(1 row(s) affected)

Weitere Informationen stehen in BOL.