Find a specific column Name in all tables of a database – SQL Server

Below is the query for searching only tables. SELECT c.name AS ‘ColumnName’ ,t.name AS ‘TableName’ FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE ‘%columnName%’ ORDER BY TableName ,ColumnName; If you want to search both tables and views – replace Sys.Columns toINFORMATION_SCHEMA.COLUMNS in the above query -Hussain Patel

.NET Core C#.NET Entity Framework

Entity Framework – Introduction

What is Entity Framework? Definition (Microsoft): The Microsoft ADO.NET Entity Framework is an Object/Relational Mapping (ORM) framework that enables developers to work with relational data as domain-specific objects, eliminating the need for most of the data access plumbing code that developers usually need to write. Using the Entity Framework, developers issue queries using LINQ, then […]


Stuff() function – Transact SQL

STUFF() Function – Transact SQL The STUFF function deletes a specified length of characters and inserts a designated string at the specified starting point. Important note: STUFF function has a limitation if 4000 characters. The syntax is as follows: STUFF ( character_expression, start, length, character_expression ) character_expression: argument of this function is the character expression […]