while 1=1

print 'test'

Jack Corbett (10/24/2008)

---

I was going to ask Jeff the same question. I knew there were issues with IsNumeric, try IsNumeric('$'), but I've usually been able to deal with those...

If you want to do this in sql, refer http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

aveerabadran (10/23/2008)

---

Hi All,

I have a requirement where i need to execute a query (daily) ,and put its output into Excel or HTML file before sending it as a mail ....

Also read about sp_executesql in sql server help file

Here it is

declare @d float

declare @d1 float

select @d = '34343.454'

select @d1 = '676.1566545'

select cast(cast (@d...

welcome 🙂

Use replace(@record,'''','''''')

Also beware of implicit conversion

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/01/16/beware-of-implicit-conversions.aspx

aravind (10/21/2008)

---

The following query truncates the decimal characters when we convert it to varchar.

declare @d float

declare @d1 float

select @d = 34343.454

select @d1 = 676.1566545

select cast (@d as varchar(50)) + CHAR...

carlos.tapadinhas (10/21/2008)

---

Hi to all,

I need a function that run a simple sp, but i need to insert into a table the result... but i dont know how to fix this...

Also refer

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

vsjayashri (10/21/2008)

---

Hi

declare @dFrom varchar(12)

set @dFrom = convert(varchar,getdate(),112)

INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\test.xls','SELECT * FROM October$B2:B2]')

@dFrom

I want to write the date on the october sheet in b2 cell,

I tried the...

msaidi2 (10/14/2008)

---

This is passed from vb.net(Executble file) to the Server using this :

SELECT * INTO table FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=" +

OpenFileDialog1.FileName + ";Extended...

Chris Morris (10/15/2008)

---

That's interesting, I also assumed it took a new connection.

If you create the temp table before executing the string, then (as Barry's code shows) the table is...