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.   [...]

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 [...]

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 [...]

Read Full Post »