Using a CLR trigger we can register all user defined functions, procedures, types, aggregates etc., contained in an assembly when it is created in the database on "CREATE ASSEMBLY ... ". This saves us the time of registering all these ourselfves. We skip...

SQL Server provides the ability to find the week of the year in which a given date lies. For example: declare @d datetime set @d = '13 november 2005' select datepart(ww, @d) The result of this is 47. Now, the problem with this is that the...