SQL Data Connection Dialog Source Code
Posted on Tuesday, August 9th, 2011
Whilst looking for something else today I came across this little nugget. Something that should be handy for anyone connecting to SQL servers wanting to build a connection string at runtime.
Here is a link to [...]
Recommended reading for anyone dealing with MSSQL
Posted on Friday, June 17th, 2011
I am not sure if I have mentioned this blog before but it is worth mentioning again anyway. I always enjoy reading the articles over at SQL Fool, I have learnt a lot there! The [...]
continue readingSQL Server Management Studio add-in
Posted on Wednesday, November 3rd, 2010
I discovered this little beauty the other day, SSMS Tools Pack for Microsoft SQL Server Management Studio from a developer in Slovenia. I haven’t had a chance to make use of everything in the package [...]
Trailing spaces in strings – Clarion vs SQL
Posted on Thursday, February 19th, 2009
This topic came up at work a while ago when trying to perform database operations on strings containing a trailing space.
The Problem: One of our stored procedures was using CHARINDEX to search for strings within [...]
Temp Tables, Scope and Clarion
Posted on Tuesday, March 11th, 2008
I was discussing this with a colleague yesterday and thought everyone might be interested in the outcome.
Problem:
I was getting an error “There is already an object named ‘PK_SUPPLIERPRODUCTID’ in the database.” when trying to [...]
