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: database
March 9, 2010
by gregs
0 comments
Upgrading to Lenny
It's been while since I attended to my VPS, I decided to spend some time last night upgrading my distribution from Etch to Lenny. This is normally a moment where your heart sinks as quite a few things do tend … Continue reading
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
June 29, 2006
by gregs
0 comments
AUTO INCREMENT
Since the MySQL Query Browser on my Mac refused to let me set a field as auto increment through the GUI, here's how you can using SQL change an existing column to use auto_increment: PLAIN TEXT SQL: ALTER TABLE `aggregatedWeekly` … 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 21, 2005
by gregs
0 comments
LIKE and Oracle
I never spotted this before but the LIKE operator is case sensitive! Which was skewing my search results quite severely. The work around is to put everything into upper case, both the values in the column you are performing the … 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
October 18, 2000
by gregs
0 comments
Accessing a dB on a remote server
Some of the information we wanted to publish on my previous company's intranet was residing on databases that weren't on the main web server. This initially caused a little headache as we really needed to access that data on the … Continue reading