Tag Archives: transact-sql

SQL Tricks – Remove Interior Spaces

This week, I was given a set of data to import to a database. After the import, I noticed that the source data had lots of unnecessary spaces all over the place. I can, of course get rid of leading … Continue reading

Posted in MS SQL, Transact SQL | Tagged , , , , , , , | Leave a comment

Vigenere By SQL

After that previous post, I suppose it was natural for me to wonder what it would take to apply Vigenere cypher logic using T-SQL. I knew right off that the code would look much different. Mainly, because my self-imposed rule … Continue reading

Posted in MS SQL, Transact SQL | Tagged , , , , , , , , , , , | Leave a comment

Easy Foreign Key Drop and Restore for SQL Server

From time to time, we’ve all had a database query to run that was stymied by foreign key constraints. In my case, it was a request to restore a table’s values from one copy of the system to another. We … Continue reading

Posted in Database Design, MS SQL, Transact SQL | Tagged , , , , , , | Leave a comment

Waitfor it

Suppose you are charged with system QA for a complicated system that expects dozens or hundreds of simultaneous users. The system has a user front end through either a browswer of through deployed software, and it sends transactions back and … Continue reading

Posted in MS SQL, Software QA/Testing, Transact SQL | Tagged , , , , , , , | Leave a comment