Category Archives: SQL

Structured Query Language, is a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon relational algebra and calculus. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control. SQL was one of the first commercial languages for Edgar F. Codd’s relational model, as described in his influential 1970 paper, “A Relational Model of Data for Large Shared Data Banks”. Despite not adhering to the relational model as described by Codd, it became the most widely used database language

2 of 10,388 days remaining #TRON

Posted on 12/15/2010 by Eric Fickes

– Using tsql to figure out how long until TRON:LEGACY DECLARE @tron datetime, @tron_legacy datetime SET @tron = ’7/9/1982 12:00:00′ SET @tron_legacy = ’12/17/2010 12:00:00′ SELECT CAST( DATEDIFF( DD, GETDATE(), @tron_legacy ) as varchar(2) ) + ‘ of’ + CAST … Continue reading →

Posted in fun, internets, microsoft, motivation, SQL, tsql | Leave a comment

TSQL : How to find all database tables ending with an UPPERCASE X

Posted on 12/08/2010 by Eric Fickes

1 2 3 4 5 6 7 8 9 10 — Give me all tables ending with an UPPERCASE X SELECT table_name, SUBSTRING( table_name, LEN(table_name), 1 ) as 'end' FROM INFORMATION_SCHEMA.TABLES — SELECT ascii('X') = 88 — SELECT ascii('x') = … Continue reading →

Posted in database, internets, SQL, tips and tricks, tsql | Leave a comment

Endless Mural wins FWA site of the day

Posted on 11/19/2010 by Eric Fickes

I’m ecstatic to announce the Endless Mural HTML5 project has won the prestigious FWA Site of the day award.  While this isn’t the first project I’ve worked on that has won the FWA, it is the first NON-Flash, HTML5 and … Continue reading →

Posted in .net, art, award, browser, C#, cool, database, development, fun, Internet Explorer, javascript, microsoft, SQL, Visual Studio | Tagged , , , , , , , , , , , , , | 3 Comments

Selecting random ids using TOP and a CTE

Posted on 09/29/2010 by Eric Fickes

While testing visualizations in a Flex application, I needed to do some underlying data cleanup in SQL Server.  One of my tasks was to manually update an entity table and set the status column to one of three possibilities.  Status … Continue reading →

Posted in database, SQL, tips and tricks, tsql | Tagged , , , , , , , | Leave a comment