microsoft sql
SQL 101 – What is SQL?
SQL, pronounced S - Q - L or sequel, stands for structured query language. It's the language you use to tell a database what you want to do. It's been
Latest
microsoft sql
SQL 101 – What is a Database
The term database is used for many different meanings. But if you compared them all, I think you would find that databases are all collections of data that
t-sql
Quickly Disconnect Users From a Database
Disconnect All Users of a Database There comes a time in every DBA's life when he or she has many users connected to a database that needs to be detached, placed in single user mode, or simply refreshed. The problem is they keep reconnecting more quickly than you can KILL them off. This is especiall
microsoft sql
An Upcoming Series…
I'm currently putting together some notes on a series I'd like to share with all of you. This series will cover the fundamentals of Transactional SQL (T-SQL).
microsoft sql
String Manipulation — CAST and CONVERT
So far I’ve shown you just a few of the many string manipulation functions available in Microsoft SQL. Today we’re adding two more of these tools to
t-sql
String Manipulation — REPLACE, PATINDEX and Regular Expressions
Finding the exact patter can be like trying to a certain snowflake. In the previous SQL posts, I showed you SUBSTRING, then I showed you REPLACE. Now, with
Untitled Post - http://shannonlowder.com:80/wp-json/oembed/1.0/embed?url=http://shannonlowder.com/2005/03/string-manipulation-replace-patindex-and-regular-expressions/
{"version":"1.0","provider_name":"Shannon Lowder","provider_url":"https:\/\/web.archive.org\/web\/20191106183843\/http:\/\/shannonlowder.com","author_name":"Shannon Lowder","author_url":"https:\/\/web.archive.org\/web\/20191106183843\/http:\/\/shannonlowder.com\/author\/slowder\/","title":"String Ma
t-sql
String Manipulation — REPLACE
In the last SQL post, I showed you SUBSTRING, and how you could use it to locate the area code in an un-formatted phone number. The problem was the field we
microsoft sql
Work, work, then some more work.
After the last post, I worked on getting a heating system put into the addition. As of last night, that's done. It only cost 3 grand. (that's more than i used
personal
Damn It’s Cold!
You have no idea how cold it is with that addon on the house. It was 57 when i woke up this morning. Well, I suppose all the other improvements are now on hold.
Posted in: Personal
Project 1
I’ve been back from Christmas for nearly a week now. I’ve accomplished much more than I thought I was going to be able to this week. I have been able to create my XML parser that will allow myself and others to develop forms more rapidly. Basically the way it...
dev
Whistle While You Work
Well, lets see. I've been back in the coding game for more than a day now. It is so nice to be in a position to solve problems, and develop new and better ways