Hi Celko,

How about somethign like this:

CREATE TABLE Produ ts

(ean CHAR(13) NOT NULL PRIMARY KEY

CONSTRAINT valid_ean

CHECK(ean LIKE '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')

CONSTRAINT good_check_digit

CHECK (CAST SUBSTRING (ean, 13, 1) AS INTEGER)

= (3* CAST SUBSTRING (ean,...

Hi Celko,

thanks for your message. The function is used to calculate a UCC/EAN check-digit and of course it will could be improved. It is a function for string manipulation.

Thanks!

Sergio

I am finally able to update a PivotTable test that resides on a Microsoft Excel worksheet.

The last test I've run on a PC with Windows 7 Professional x64 x64 SS2008...

Hi,

I need to update a pivot table that resides on a Microsoft Excel worksheet.

I created a stored procedure dbo.USP_DMO_EXCEL_Pivot_RefreshTable(http://www.ugiss.org/Content/Article/Aggiornare-una-tabella-pivot-di-Microsoft-Excel.aspx) that uses OLE Automation (sp_OA*) to refresh, every night (without open...

I had the same need: record the DML commands on a table in one database. I have used the auditing mechanisms.

With SQL Server 2008 auditing support is native thanks to...

Hi Susannah

do you remember the first solution based on the use of OLE Automation Stored Procedures ? Now is available an update of the stored procedure dbo.USP_DMO_Excel_Pivot_RefreshTable: I fixed a...

Hi Susannah

I'm trying to reproduce the error:

Msg 6522, Level 16, State 1, Procedure up_excel_pivot_refreshtable, Line 0

A .NET Framework error occurred during execution of user-defined routine or aggregate "up_excel_pivot_refreshtable":

System.Runtime.InteropServices.COMException: The...

Hi Susannah,

what message you get by running the stored procedure in debug mode, with the following example command (with @Debug = 1) ?

-- exec StoredProcedureName

exec dbo.up_excel_pivot_refreshtable

@FilePath = 'C:\temp\refresh.xls',

...

Hi Susannah,

seems a problem of method Quit ()... I was not able to reproduce the problem... I check...

Hi Susannah,

No problem 🙂

In fact, the CLR stored procedure accepts one parameter more, the fourth (@Debug)... this is...

Hi Susannah,

The CRL_Excel_Interf.dll is created (in automatic mode, the output is) doing the build of the CLR project (CLR_Excel_Interf.csproj) on Microsoft...

Hi Susannah,

I have completed the stored procedures in CLR languages 🙂 take a look at this post: http://community.ugiss.org/blogs/sgovoni/archive/2009/04/11/sqlclr-instead-of-ole-automation-sp_5F00_oa_2A00_-method.aspx the article that you reach by clicking on read more explains the...

Hi

This result...

Hi Susannah,

the problem may be related to the use of OLE Automation objects, for example OLE Automation objects compete for the same memory space with SQL Server.

I'm rewriting 🙂 the...

Hi Susannah,

for memory leaks,...