Madhivanan - All Comments

re: Import/Export to Excel

Madhivanan — Mon, 19 May 2008 07:41:55 GMT

mquinn64,

Make sure the number of columns in excel sheet is same as the table

re: Import/Export to Excel

mquinn64 — Mon, 19 May 2008 02:46:58 GMT

in using the export to Excel script I get the following message

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\testing.xls;HDR=YES',

'SELECT * FROM [Sheet1$]')

select * from cdbLink

WHERE (((cdbLink.extObjType)=11 Or (cdbLink.extObjType)=-1))

error message

Server: Msg 213, Level 16, State 5, Line 1

Insert Error: Column name or number of supplied values does not match table definition.

Set based splitting of delimited strings to columns

SimonS Blog on SQL Server Stuff — Tue, 01 Apr 2008 12:23:29 GMT

I recently presented on using CLR in SQL at DevWeek and commented on how TSQL Udfs just don't perform

re: Splitting csv to columns

Madhivanan — Mon, 17 Mar 2008 14:31:07 GMT

Hi Hugo

Thanks

I should have specified about SQL Injection

re: Splitting csv to columns

Hugo Kornelis — Mon, 17 Mar 2008 08:47:04 GMT

But remember that this is a VERY dangerous technique, since you're opening yourself wide to SQL injection. As this slightly modified version proves:

declare @s varchar(2000),@data varchar(2000)

select @s='this,is,SQL injection''; drop table HopeThisDoesntReallyExist; --'

select @data=''''+replace(@s,',',''',''')+''''

exec('select '+@data)

Best, Hugo

re: Find Nth Maximum value

Madhivanan — Sat, 15 Mar 2008 09:30:31 GMT

Muthukrishnan,

What is the datatype of the column?

Can you try the example I have given?

re: Find Nth Maximum value

Muthukrishnan — Mon, 03 Mar 2008 12:55:43 GMT

1)Use Inner Join

this one is not working properly,I have checked it,but not working properly.if the value (salary) is same digits(100,200,300,400) of all rows mean its working fine,other wise the value(salary) is different digits(1000,200,30000,450) mean here not working fine.

Can you please check it and reply me.

Thanks and Regards,

Muthukrishnan.S

re: Find Nth Maximum value

Madhivanan — Wed, 27 Feb 2008 09:58:15 GMT

Hi Danasegarane

It is the alias name for the derived table

The query select top 5 num from number order by num desc is a derived table from which data is retreived using min function

re: Find Nth Maximum value

Danasegarane — Wed, 27 Feb 2008 09:49:55 GMT

Hi Madhivanan,

Thanks for the excellent post.

Can you pls explain the meaning of T in this query ?

Select min(num) from (select top 5 num from number order by num desc) T

re: Extract only numbers from a String

Madhivanan — Wed, 27 Feb 2008 06:39:43 GMT

Hi Jeff

Yes it matters if your DB is case sensitive

re: Extract only numbers from a String

Jeff M — Tue, 26 Feb 2008 19:37:15 GMT

Thanks for pointing me at this method! Btw, the master.dbo.spt_values.type on my system is actually 'P' ( uppercase P ).

re: Understanding Single quotes

Jayasimha M N — Mon, 25 Feb 2008 12:33:46 GMT

nice article thank u Madhivanan

SQL SERVER - How to Escape Single Quotes - Fix: Error: 105 Unclosed quotation mark after the character string ‘ « Journey to SQL Authority with Pinal Dave

Wed, 20 Feb 2008 06:50:06 GMT

PingBack from http://blog.sqlauthority.com/2008/02/17/sql-server-how-to-escape-single-quotes-fix-error-105-unclosed-quotation-mark-after-the-character-string/

re: Handle ISDATE() with care

Madhivanan — Tue, 19 Feb 2008 14:25:13 GMT

Harsh

It depends on the format you stored

Can you give me some examples?

re: Handle ISDATE() with care

Harsh Athalye — Tue, 19 Feb 2008 11:14:16 GMT

What about the separator characters like '/'?

In that case this validation wouldn't be sufficient.