Adding reference to Project in Visual Studio 2005

In your Visual Studio IDE go to the projects (at the top) -> add references -> com (tab) -> add the Microsoft Excel library installed.
 
Or you can use the project explorer.
Right click on the references-> add references -> com (tab) -> add the library.
 
Please refer to the image below.

 

Then simply what you need to do [...]

Read Full Post »

Finding out if there are trailing spaces in a column

A lot of you might have come across this problem just like me.
 
Firstly we create a temporary table.
create table #temp1
(
            id Int Identity(1,1),
            invoice varchar (20)
)
insert into #temp1 values (‘CR’)
insert into #temp1 values (‘CR ‘)
insert into #temp1 values (‘ CR ‘)
insert into #temp1 values (‘ CR’)
 
Select *  From #temp1
            where DATALENGTH(invoice) <> len(invoice)
 
The len function [...]

Read Full Post »

Updatable keyset-driven cursors on remote tables require a transaction with the REPEATABLE_READ or SERIALIZABLE isolation level spanning the cursor. Server: Msg 8180, Level 16 ,Server: Msg 102, Level 15, Server: Msg 1018, Level 15

Server: Msg 8180, Level 16
Server: Msg 102, Level 15
Server: Msg 1018, Level 15, State 1, Procedure SendReview, Line 12
Incorrect syntax near ‘FASTFIRSTROW’. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.
Remote tables are not updatable. Updatable keyset-driven [...]

Read Full Post »