For this article, we are going to examine the benefit of using stored procedures that simply return a result set (i.e. a stored procedure that has a SELECT statement). Before we do a shallow dive into this functionality, it is worth noting that SQL Server has 3 methods of returning data from a stored procedure: … Continue reading Stored Procedures: Returning Data Using a Result Set
Author: Scott Peters
Oracle 1Z0-149 Exam
Hello everyone! Has anyone passed the Oracle 1Z0-149 exam? I would love to hear your thoughts. I attempted this exam last week and did not reach the required 66% to pass. And it appears I may be the first person posting about this exam online here.... The exam is insanely difficult; 65 questions, 90 minutes, … Continue reading Oracle 1Z0-149 Exam
SQL Syntax Conventions
If you have always wondered what the different symbols and formatting mean when viewing syntax examples, Microsoft has the following page. Transact-SQL Syntax Conventions (Transact-SQL) - SQL Server | Microsoft Docs It's always a good exercise to go through the DDL statements like below and take stock of which options you understand or need to … Continue reading SQL Syntax Conventions
Happy New Year: 2022
Welcome to a new year. I haven't utilized the blog portion of my website yet, but I figured a nice year-end review would be a good topic. I'm not expecting a lot of people to read this, so if you are, hello and welcome! This site has become quite popular considering its niche subject of … Continue reading Happy New Year: 2022
Welcome
Hello everyone. Thank you to everyone for making this niche SQL website so popular; keep the comments and ideas coming. Please contact me through the contact page on this website. It was months in the making, but I've finally completed a revamp of my website and GitHub repository. I created a static landing page here … Continue reading Welcome