tsql

   1 exec sp_helptext 'schema.storedProc'
   2 exec sp_helptext 'schema.function'

   1 -- get assembly_id
   2 select * from sys.assembly_modules

   1 -- reconfigure
   2 sp_configure 'show advanced options', 1;
   3 GO
   4 RECONFIGURE;
   5 GO
   6 sp_configure 'Ole Automation Procedures', 1;
   7 GO
   8 RECONFIGURE;
   9 GO
  10 
  11 -- extract assembly
  12 DECLARE @IMG_PATH VARBINARY(MAX)
  13 DECLARE @ObjectToken INT
  14 
  15 SELECT @IMG_PATH = content FROM sys.assembly_files WHERE assembly_id = 65824 and file_id=1
  16 
  17 EXEC sp_OACreate 'ADODB.Stream', @ObjectToken OUTPUT
  18         EXEC sp_OASetProperty @ObjectToken, 'Type', 1
  19         EXEC sp_OAMethod @ObjectToken, 'Open'
  20         EXEC sp_OAMethod @ObjectToken, 'Write', NULL, @IMG_PATH
  21         EXEC sp_OAMethod @ObjectToken, 'SaveToFile', NULL, 'c:\windows\temp\65824.dll', 2
  22         EXEC sp_OAMethod @ObjectToken, 'Close'
  23         EXEC sp_OADestroy @ObjectToken

   1 SELECT datediff(second, dateX1, GETDATE() )
   2 FROM tablex

   1 SELECT CONVERT(NVARCHAR(30), GETDATE(), 126)
   2 2009-05-01T14:18:12.430
   3 
   4 SELECT CONVERT(NVARCHAR(30), GETDATE(), 120)
   5 2009-05-01 14:18:12