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

DATENAME function: Explained

Posted on July 26, 2021July 28, 2023 by Josh D
DATENAME function: Explained

Reading Time: 7 minutesThe DATENAME function is a system function in Microsoft SQL Server we can use to present meaningful date information to the user. We use this function to basically spell out a specific part of a date value. For example, if we have a date of 4/1/2021, we can use DATENAME to Continue Reading

Posted In Data Types, Querying data

DATETIME2 Data Type: Explained

Posted on July 19, 2021July 27, 2023 by Josh D
DATETIME2 Data Type: Explained

Reading Time: 7 minutesThe DATETIME2 data type is one of several data types used to keep track of date and time information, obviously. Just like any other data type, there is a time and place where DATETIME2 might be the preferred type to use over other date and time types, like it’s close Continue Reading

Posted In Data Types, The Basics

SQL Integer Data Types – Everything you need to know

Posted on July 12, 2021July 27, 2023 by Josh D
SQL Integer Data Types – Everything you need to know

Reading Time: 6 minutesKnowing the difference between all the integer data types available to us in Microsoft SQL Server is very important when it comes to the task of designing and developing SQL Server databases. Most people don’t realize that a data type is essentially a constraint, meaning the data type you choose Continue Reading

Posted In Data Types, The Basics

Are you making this ROLLBACK mistake in your stored procedures?

Posted on July 5, 2021July 27, 2023 by Josh D
Are you making this ROLLBACK mistake in your stored procedures?

Reading Time: 9 minutesIf you read my post about the 6 rules you should know about SQL Server transactions, you should know there is one rule that can be a bit tricky. This rule centers around the idea of doing a ROLLBACK within a stored procedure. The rule is this: When you leave Continue Reading

Posted In Error Handling, Stored Procedures, Transactions

Tutorial Categories

Navigation:

Home » 2021 » 07

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