How to Search SQL Query Text in Stored Procedures and Ad-Hoc Queries

preview_player
Показать описание
Have you ever wanted to search across all queries on your SQL Server?

In today's video, we take a look at how to search the SQL query body/text of ad-hoc queries, stored procedures, functions, and views.

Blog post containing code templates for easy copy/pasting:

Previous video that talks about searching for implicit conversions:

Follow me on Twitter:

  1. Bert Wagner
  2. SQL Server
  3. SQL
  4. SQL training
  5. SQL tutorial
  6. sql_modules
Рекомендации по теме
5 Basic SELECT 0:06:43

5 Basic SELECT Statement Queries in SQL

Search query on 0:11:29

Search query on sql example

SELECT query in 0:07:21

SELECT query in SQL - Retrieval of records from a table

Using SQL to 0:04:07

Using SQL to Search for Data

How to get 0:00:38

How to get COLUMN NAMES in SQL

How to Search 0:04:04

How to Search Table by Name in SQL Server

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

Data Analytics & 0:42:13

Data Analytics & Data Science Demo 03 | What Is SQL? | Tutorial for Beginners

How to use 0:02:27

How to use the SQL LIKE Condition

Searching for text 0:11:01

Searching for text in SQL Server: CHARINDEX and PATINDEX

How to get 0:00:19

How to get FIRST CHARACTER of STRING in SQL

Finding expensive queries 0:13:36

Finding expensive queries in SQL Server and performance optimization part 1

SQL Query Optimization 0:03:18

SQL Query Optimization - Tips for More Efficient Queries

Learn how to 0:49:56

Learn how to write SQL Queries(Practice Complex SQL Queries)

Writing your first 0:04:13

Writing your first SQL queries in SQL Server

SQL indexing best 0:04:08

SQL indexing best practices | How to make your database FASTER!

SQL Tutorial - 0:07:58

SQL Tutorial - How to search text in a Stored Procedure

Use ChatGPT To 0:09:01

Use ChatGPT To Write SQL Queries From Scratch

SQL Tricks | 0:13:09

SQL Tricks | How to find value in multiple columns ?

SOLVE 5 SQL 0:05:02

SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS

Approach to Complex 0:08:33

Approach to Complex SQL Queries

Advanced SQL Tutorial 0:08:37

Advanced SQL Tutorial | Subqueries

search filter conditions 0:03:18

search filter conditions multiple columns and rows in sql server

Комментарии
Автор

Old video, but you explained everything really well. Most SQL videos people either have difficult accents to understand, or explain them poorly. You used common phrases and words and made the explanation very easy to follow. Thank you Bert!

HandBalllll