Hussain Patel

The Working Programmer


October 2019

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

Below is the query for searching only tables. SELECT AS ‘ColumnName’ , AS ‘TableName’ FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE LIKE ‘%columnName%’ ORDER BY TableName ,ColumnName; If you want to search both tables… Continue Reading →

Git – Update local branch with remote Develop

Follow the below steps: git checkout develop git pull git checkout <your-branch-name> git merge┬ádevelop The above steps will merge the changes from develop into your branch and probably create a new commit, with a comment making it clear that it’s… Continue Reading →

© 2021 Hussain Patel — Powered by WordPress

Theme by Anders NorenUp ↑