SQL in VBScript question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

SQL in VBScript question

Author

Topic

darms21
Yak Posting Veteran

54 Posts

Posted - 2012-10-18 : 14:51:52

I am trying to execute the below sql statement through an objshell.exec call and am not getting any data returned...I have verified that the statement does indeed work...assuming it an issue w/ the apostrophes...any ideas?

select concat('<attribute name=""Processor Speed"" type=""string"">',processor_speed,'</attribute>') as processor_speed from hardware_inventory where computer_id =7)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources