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 find a string within a string in SQL Server: Explained with Examples

Posted on June 27, 2022August 17, 2023 by Josh D
How to find a string within a string in SQL Server: Explained with Examples

Reading Time: 5 minutesThe task of finding a character string within a larger character string in a SQL Server database is very easy. SQL Server has many built-in system functions that can be used for character string manipulation, one of which is the CHARINDEX function. We use the CHARINDEX system function to locate Continue Reading

Posted In SQL Questions

How to drop a constraint in SQL Server: Explained with Examples

Posted on June 20, 2022June 30, 2023 by Josh D
How to drop a constraint in SQL Server: Explained with Examples

Reading Time: 4 minutesIt’s very easy to drop a constraint on a column in a table. This is something you might need to do if you find yourself needing to drop the column, for example. SQL Server simply will not let you drop a column if that column has any kind of constraint Continue Reading

Posted In Constraints, Data Definition Language

How to drop a column in SQL Server: Explained with Examples

Posted on June 13, 2022August 17, 2023 by Josh D
How to drop a column in SQL Server: Explained with Examples

Reading Time: 4 minutesKnowing how to make modifications to the definition of a table is very important when it comes to developing Microsoft SQL Server databases. The task of deleting a column is very straightforward. In this very brief tutorial, we’ll discuss how to drop a column from a Microsoft SQL Server table. Continue Reading

Posted In Data Definition Language, SQL Questions

Tutorial Categories

Navigation:

Home » 2022 » 06

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