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

How to escape a single quote in SQL Server

Posted on December 27, 2021August 15, 2023 by Josh D
How to escape a single quote in SQL Server

Reading Time: 2 minutesSQL Server makes it very easy to escape a single quote when querying, inserting, updating or deleting data in a database. Here’s how it’s done: Just use another single quote For example, let’s take a look at a table called Books: Let’s say we want to insert another row for Continue Reading

Posted In SQL Questions, The Basics

How to see the definition of a View in SQL Server

Posted on December 27, 2021August 15, 2023 by Josh D
How to see the definition of a View in SQL Server

Reading Time: 4 minutesMicrosoft SQL Server makes it very easy to create and use Views within SQL Server Management Studio. In this very brief tutorial, we’ll discuss how easy it is to see the definition of a View after it has been created and saved in your database. If you need a full Continue Reading

Posted In SQL Questions, The Basics, Views

Tutorial Categories

Navigation:

Home » 2021 » 12 » 27

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