So, last time we discussed why do we really want to use a stored procedure. One of the big things I said was, “so that my blocks of code can be re-used several times now and in the future. ” This statement, at least to me, forms the building block for stored procedures. They allow…… Continue reading Stored Procedures – Why
Category: SQLBasics
Stored Procedures
So, in our last post – Back to Basics – we went over what a stored procedure was and what goes into it. Now, let’s show you a simple stored procedure. CREATE PROCEDURE StoredProcedureTest AS SELECT 1/1 GO I know. I know. You thought we were going to begin by building skyscrapers, instead, we’re trying to find cinder…… Continue reading Stored Procedures
Back to Basics
Welcome to the New Year everyone! After debating with myself and talking to a few colleagues/peers over the last few weeks, I’ve decided that I have gotten away from my original sense of purpose for this blog. It’s time to fix that! My original idea was to have this blog be a place where people…… Continue reading Back to Basics
Security Audit – Part 4
So, since it has been some time since we looked at our Security Audit, let’s review what we’ve gone over so far: And We’re Back! Security Audit – Part 2 Security Audit On our next look at the Security Audit, let’s look at the server itself – SELECT COUNT(*) FROM sys.servers WHERE is_linked =’1′ This…… Continue reading Security Audit – Part 4
And We’re Back!
So, as you can tell from the lack of posts over the past few months, I have been more than just busy. Between moving into a new house, moving my son into a college dorm, several SQL Saturdays, and just general work items, it has been extremely hectic. But, I am back now, and my…… Continue reading And We’re Back!
Concatenation of Strings!
Now, I know for most of you, this seems like a rather simple idea. The definition of concatenation is, according to Dictionary.com is : verb (used with object) 1. to link together; unite in a series or chain. Simply put, you combine two or more strings together to form a new string. So, the first…… Continue reading Concatenation of Strings!
Merging Data Sources – Part 3
Now, when I last posted, I’m sure you thought I was done talking about the MERGE statement. You are so wrong, compadre! One more post is absolutely needed! There are a few issues with the MERGE statement. Well, as of this writing, there are 361 possible issues according to Microsoft Connect – the actual website…… Continue reading Merging Data Sources – Part 3
Merging Data Sources Part II
The last time we were together, we learned how to use the MERGE statement when we wanted to insert rows that didn’t exist and update rows that didn’t. This time we’re going to add onto that. We’re adding the seldom used, but delightfully potent – delete rows that no longer exist in the original table.…… Continue reading Merging Data Sources Part II
Merging Data Sources
Merging Data Sources, part 1
Getting rid of data
In previous posts, we’ve talked about SELECTing data, INSERTing data, and UPDATEing data. Now, what do we do if we want to just get rid of the data? Now, in most scenarios, you really don’t want to get rid of data. As a data professional, it is definitely not a good idea to get rid…… Continue reading Getting rid of data