Necessary SQL query in MS SQL

less than 1 minute read

SQL stands for Structured Query Languages. In this article, I will show you some important query you need frequently.

  • Search a table name in a database in MS SQL Server
    WHERE TABLE_NAME LIKE '%tablename%'

If you want to see all column of a joining table

select Region.* from Branch
inner join Region
on Branch.RegionId = Region.Id