Category: SQL

Understanding SQL Joins?

SQL Joins help in getting the commonality between SQL Tables ON certain condition or group of conditions being met.

4 … Read the rest

How to search through all SQL Stored Procedures?

/*Searching for text in all stored procedures across data base*/
 
SELECT ROUTINE_NAME AS 'spName', ROUTINE_DEFINITION AS 'spContent'
FROM
Read the rest

How to see all SQL Database locks?

SELECT dbLocks.resource_type, 
dbNames.name AS 'database_name', 
dbObjects.name AS 'object_name', 
dbLocks.request_type
Read the rest

How to search SQL Database objects for text with exclusions?

/*Replace Text to search and exclude with your requirements*/
 
DECLARE @toSearch VARCHAR(255) = 'TEXT_TO_SEARCH', @toExclude 
Read the rest

Home | Contact Us | Terms and Conditions | Theme By Anders Norén