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

“Why should I save my query as a View instead of a .SQL file?” Answered!

Posted on May 13, 2024 by Josh D
“Why should I save my query as a View instead of a .SQL file?” Answered!

Reading Time: < 1 minute“If I have a query that I run frequently, why should I save it as a View in the database instead of just simply saving it as a .SQL script file and running the query when I need it?” There are two main benefits to saving your query as a Continue Reading

Posted In SQL Questions, Table Expressions, Views

SQL Server DELETE vs. TRUNCATE: What’s the difference?

Posted on May 5, 2024May 5, 2024 by Josh D
SQL Server DELETE vs. TRUNCATE: What’s the difference?

Reading Time: 2 minutesThe DELETE and TRUNCATE statements are both meant to delete content from a table. Since that’s true, it begs the question: What’s the difference? In this very brief tutorial, we’ll walk through the main differences between DELETE and TRUNCATE and explain when you should choose to use one over the Continue Reading

Posted In Querying data, SQL Questions, The Basics

Tutorial Categories

Navigation:

Home » 2024 » 05

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