Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Correlated and Noncorrelated – SubQuery Introduction, Explanation and Example

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Joins, SQL Scripts, SQL Sub Query
A correlated subquery is an inner subquery which is referenced by the main outer query such that the inner query is considered as being executed repeatedly. Example: ----Example of Correlated Subqueries USE AdventureWorks; GO SELECT e.EmployeeID FROM HumanResources.Employee e WHERE e.ContactID IN ( SELECT c.ContactID FROM Person.Contact c WHERE MONTH(c.ModifiedDate)…
Read More

SQLAuthority News – Interesting Read – Using A SQL JOIN In A SQL UPDATE/Delete Statement – Ben Nadel

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Joins, SQL Scripts, SQL Stored Procedure
As everybody know SQL is what I like most. Before I was into SQL Server, I was very much into ColdFusion. ColdFusion is still my most favorite programming language. I still program in ColdFusion, infect my personal website https://www.pinaldave.com/ is in ColdFusion. I regularly read ColdFusion blog and latest updates…
Read More

SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL System Table
My article SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key has received following question many times. I have deleted similar questions and kept only latest comment there. In SQL Server 2005 How to Find Tables With Primary Key Constraint in Database? Script…
Read More
All Articles keyicon

SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database

Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Server, SQL System Table

While writing article based on my SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key I got an idea about writing this article. I was thinking if you can find primary key for any table in the database, you can sure find foreign key for any table in the database as well.

Read More

SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Cursor, SQL Scripts, SQL Stored Procedure, SQL System Table
I receive following question many times by my team members. How can I find if particular table is being used in the stored procedure? How to search in stored procedures? How can I do dependency check for objects in stored procedure without using sp_depends? I have previously wrote article about…
Read More