 |
Recent Posts (All Posts)
| I Have Moved This Blog This blog is now at htack210.wordpress.com. Please meet me there! Thanks! (More) |
| Another Way to Get a Value from a Stored Proc There's more than one way to skin a query. Yesterday I put up a code snippet showing how to get a return value from a stored proc using a SELECT statement. Another way to do the same thing is to use an OUTPUT parameter. You create your parameters (More) |
| Getting a Return Value from a Stored Proc For our PiggyBank project we need to create a stored proc that lets us add a customer. Since the CustomerID field is an Identity column and automatically creates a new ID for new customers, I thought it would be a good idea to return that value so th (More) |
| Shredding XML Files in T-SQL We are working on Piggy Bank project this week. One of the extra credit sections involves shredding an XML file so that transaction information is inserted into a table called Transactions. I love a challenge so I gave it shot! Figuring out the pa (More) |
| Why I Chose SetFocus I am a former school teacher. In my last teaching position I had the great privilege of teaching Junior/Senior high students with special needs at Hidden Treasure Christian School (HTCS). One of the best lessons I learned there was this: Whatever you (More) |