Adobe® PDF IFilter is designed for technically savvy users or administrators who wish to index Adobe PDF documents with Microsoft indexing clients. This allows the user to easily search for text within Adobe PDF documents. Key benefits: • Integrates with existing operating systems and tools within your company • Provides an easy solution to search within Adobe PDF documents located on your computer, your company network, and your company intranet • Greatly increases your ability to accurately locate information Adobe PDF IFilter 6.0 is an update to Adobe PDF IFilter 5.0 and includes the following improvements: • Support for all...

Da oggi e' disponibile la versione finale: http://www.microsoft.com/windowsserversystem/virtualserver/evaluation/vsmt.mspx

CREATE FUNCTION [dbo].[fn_GetAgeInYearsOnBDay] (@birthday datetime, @d datetime)  RETURNS int AS  BEGIN declare @age int select @age = datediff(yy, @birthday, @d) -         (case when (datepart(m, @birthday) > datepart(m, @d))OR                    (datepart(m, @birthday) = datepart(m, @d) AND                     datepart(d, @birthday) > datepart(d, @d))                         then 1                         else 0         end) Return(@age) END   USAGE:  select dbo.fn_GetAgeInYearsOnBDay('07/16/1971', Getdate()) Technorati tags: SQL