{{theTime}}

Search This Blog

Total Pageviews

SqlServer Exception: Arithmetic overflow error converting expression to data type int.

This error will be thrown when count(*) function is wrongly used.

Example:  select count(*) from order_table ot join customer_table ct on ot.date is not null

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...