Helpful tSQL

Many people have asked me what the 't' is for, in 'tSQL'. Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL. Transact-SQL is central to using SQL Server. All applications that communicate with SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface, or the application. 
Per Wikipedia: http://en.wikipedia.org/wiki/Transact-SQL

I have banged my head against the tSQL wall on more than one occasion. Here I've posted a few tips, tricks... and workarounds. Hopefully you will find something useful. Please let me know if you have any questions.

Also remember that SQL Server is for the storing and administering the data, not for making it pretty. We can do some pretty clever manipulations within tSQL, but this really should be done on the front end. Coding the presentation in the backend can be very costly in terms of performance.

Helpful tSQL



I am continually working to add to the site, and I would love to know if any of this has been useful. Please send me an email at rebecca@sqlfingers.com.  Let me know if you have any questions, or if there is something specific that I can help with.  I offer different types of consulting;  for one or two problems at a time, or even managed service agreements through which I can provide regular, ongoing database administration, monitoring, and more.  Give me a call, we can customize an agreement to meet your needs.

-Rebecca
rebecca@sqlfingers.com