The Working Programmer
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
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 a merge. There are other ways do to update the local branch, i would say […]
For Part I please refer link Part II – please refer link One we have referenced / loaded JQuery (as mentioned in Part II) either using a local copy or CDN, the next thing is to start using JQuery. the most important function of jQuery that is used a lot and we all would be […]
For Part I Please click following link Considering you have are already downloaded JQuery files (see note below) from JQuery website or you have Microsoft or Google CDN (Content Distribution Networks) link (more on this below in this post). The first thing you need to do for using JQuery is setting up JQuery reference in the […]
Introduction JQuery is one of the most popular JavaScript libraries – in many ways it helps increase the productivity, minimize the code and most importantly help solving cross browser issues. Starting we would be learning all about JQuery. The below articles / post are based on my learning, my experience in projects and my reference […]
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 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 […]
In this article, we will understand how to work with strings in C#, use string class in C# and finally used learn how to use the String Builder class in C#. In C# strings are created by enclosing a series of characters in double quotation marks, these series of characters can be letters, numbers, and […]
Design Pattern – Singleton In this blog we discuss and learn about the easy design pattern of all the design patterns – the Singleton pattern. This article is an attempt to provide the new developers / readers with some basic understanding about singleton pattern and its implementation in my words. Singleton pattern when implemented provides […]