Because I have to keep running this script and thus look it up, keeping it here for handy and quick reference PLAIN TEXT CODE: select count(id) from database.dbo.tablename group by id having count(id)> 1
September 21, 2010
by gregs
0 comments
Category Archives: MS SQL
August 29, 2007
by gregs
0 comments
SQL to XML
Just came across this neat trick that uses SQL to generate XML on the fly: PLAIN TEXT CODE: DECLARE @x xml SET @x=(select geoAreaCode , geoLevelCode , geoLevelId , geoAreaId from tbl_geoLevel where uuid = for xml raw('geoArea'), root('geoAreas'), type) … Continue reading
November 23, 2006
by gregs
0 comments
Beyond SQL injection attacks
Courtesy of Slashdot a reminder that you should also worry about other types of injection attacks. Don't you just wish that everybody would play nice? UPDATE In a similar vein, Nadav Samet covers off in more detail Cross Site Scripting … Continue reading
November 23, 2006
by gregs
0 comments
LogParser
Charlie Arehart has a handy little article published in this months CFDJ on using Microsoft's Log Parser tool, which allows you to write SQL like statements against your CFMX log files. Couldn't find a publicly accessible link, but if you … Continue reading
December 16, 2005
by gregs
0 comments
CFMX – MSDE connection refused error
I just started using MSDE for local development again and after creating my first DSN through the ColdFusion administrator I encountered the following problem: PLAIN TEXT CODE: # Connection verification failed for data source: SMS java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing … Continue reading
October 20, 2003
by gregs
0 comments
Updates from a select
I have been doing a lot more database based work recently and have learned one or two pretty useful techniques. Here is an extremely useful one: Running an update based on a select statement. In the past whenever I could … Continue reading