Skip to content
Simple SQL Tutorials

Simple SQL Tutorials

Your guide to querying and developing SQL Server databases

  • Home
  • Tutorials
    • The Basics
    • Transactions
    • Normalization
    • Querying data
    • Developing Databases
    • SQL Questions
    • Identity Property
    • JOIN
    • Data Types
    • Stored Procedures
    • Window functions
    • Data Definition Language
    • Views
    • Constraints
    • Set Operators
    • Table Expressions
    • Error Handling
    • Functions
    • Indexes
    • Triggers
  • Products
  • Contact
  • Privacy Policy
  • About

CAST and CONVERT: A How-To Guide

Posted on June 9, 2021June 30, 2023 by Josh D
CAST and CONVERT: A How-To Guide

Reading Time: 9 minutesTwo of the most common system functions you will see as a database developer are the CAST and CONVERT functions. These two functions perform in a similar way, with only slight differences between the two. The one you use will depend on your needs at the time. CAST and CONVERT Continue Reading

Posted In Data Types, Querying data, The Basics

SQL Server CASE Statement: A How-To Guide

Posted on June 9, 2021October 21, 2022 by Josh D
SQL Server CASE Statement: A How-To Guide

Reading Time: 8 minutesThe CASE expression is a very handy tool you should know when querying data using T-SQL in a Microsoft SQL Server database. In this very brief tutorial, we’ll break down the CASE expression and show you exactly how to write it and how it can make your querying life easier. Continue Reading

Posted In Querying data, The Basics

SQL Server Cursors: A How-To Guide

Posted on June 9, 2021October 9, 2022 by Josh D
SQL Server Cursors: A How-To Guide

Reading Time: 9 minutesYou will likely find yourself needing to use the capabilities of a cursor to accomplish some task in Microsoft SQL Server at some point in your career as a database professional. Cursors are the tool we use when working with large amounts of data, where you need to basically iterate Continue Reading

Posted In Stored Procedures, The Basics

SQL Server WHILE loop: A decision structure you should know

Posted on June 9, 2021October 8, 2022 by Josh D
SQL Server WHILE loop: A decision structure you should know

Reading Time: 7 minutesThe WHILE loop is one of the most basic tools you should know when you are first starting out with Microsoft SQL Server. Sometimes when working with SQL Server, you need certain code to execute several times in a loop while some condition is true. As soon as that condition Continue Reading

Posted In Stored Procedures, The Basics

SQL Server Wildcards: The 5 wildcards you need to know

Posted on June 9, 2021October 8, 2022 by Josh D
SQL Server Wildcards: The 5 wildcards you need to know

Reading Time: 9 minutesYou are the manager of a new up-and-coming hardware store in the city of Denver, Colorado. You are speaking with a new customer who says they own a woodworking business, and enjoy shopping at your store very much. They plan on being a regular customer, which you know will bring Continue Reading

Posted In Querying data, The Basics

Tutorial Categories

Navigation:

Home » 2021 » 06 » 09

Sign up for our newsletter!

Recent Posts

  • “Why should I save my query as a View instead of a .SQL file?” Answered!
  • SQL Server DELETE vs. TRUNCATE: What’s the difference?
  • SQL Server COALESCE System Function: How It Works
  • Can we create indexes in table variables? YES WE CAN!
  • SQL Server WINDOW Clause: Explained!
Copyright All rights reserved | Theme: Flash Blog by Unitedtheme.
SimpleSQLTutorials.com uses cookies to provide the best experience on our website through tailored advertising. By clicking Accept, you agree to our use of cookies.AcceptPrivacy policy