DECLARE @assemblypath nvarchar(256),
        @sql          nvarchar(256)

-- Replace the path below with your path!
SELECT @assemblypath = 'F:\Moje Dokumenty\WWW\dynsearch\'

IF NOT EXISTS (SELECT * FROM sys.assemblies WHERE name = 'search_orders_cs')
   SELECT @sql = 'CREATE'
ELSE
   SELECT @sql = 'ALTER'
SELECT @sql = @sql + ' ASSEMBLY search_orders_cs FROM ''' +
              @assemblypath + 'search_orders_cs.dll'''
EXEC (@sql)

IF NOT EXISTS (SELECT * FROM sys.assemblies WHERE name = 'search_orders_vb')
   SELECT @sql = 'CREATE'
ELSE
   SELECT @sql = 'ALTER'
SELECT @sql = @sql + ' ASSEMBLY search_orders_vb FROM ''' +
              @assemblypath + 'search_orders_vb.dll'''
EXEC (@sql)


IF NOT EXISTS (SELECT * FROM sys.objects WHERE name = 'search_orders_cs')
BEGIN
   EXEC ('CREATE PROCEDURE search_orders_cs
                    @orderid   int          = NULL,
                    @fromdate  datetime     = NULL,
                    @todate    datetime     = NULL,
                    @minprice  money        = NULL,
                    @maxprice  money        = NULL,
                    @custid    nchar(5)     = NULL,
                    @custname  nvarchar(40) = NULL,
                    @city      nvarchar(15) = NULL,
                    @region    nvarchar(15) = NULL,
                    @country   nvarchar(15) = NULL,
                    @prodid    int          = NULL,
                    @prodname  nvarchar(40) = NULL,
                    @debug     bit          = 0 AS
         EXTERNAL NAME search_orders_cs.StoredProcedures.search_orders_cs')
END

IF NOT EXISTS (SELECT * FROM sys.objects WHERE name = 'search_orders_vb')
BEGIN
   EXEC('CREATE PROCEDURE search_orders_vb
                    @orderid   int          = NULL,
                    @fromdate  datetime     = NULL,
                    @todate    datetime     = NULL,
                    @minprice  money        = NULL,
                    @maxprice  money        = NULL,
                    @custid    nchar(5)     = NULL,
                    @custname  nvarchar(40) = NULL,
                    @city      nvarchar(15) = NULL,
                    @region    nvarchar(15) = NULL,
                    @country   nvarchar(15) = NULL,
                    @prodid    int          = NULL,
                    @prodname  nvarchar(40) = NULL,
                    @debug     bit          = 0 AS
       EXTERNAL NAME search_orders_vb.StoredProcedures.search_orders_vb')
END