<?xml version="1.0" encoding="UTF-8" standalone="no"?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><rss xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd" version="2.0"><channel><title>Asp.Net,C#.Net,VB.Net,MVC,jQuery,JavaScipt,AJAX,WCF,Sql Server example</title><description>It is a collection of code snippets for web programmers, including code for Asp.Net,Sql Server,C#.Net,VB.Net,MVC Ajax,jQuery,JavaScript,XML,LINQ,WCF Services,C,C++,Interview Questions answers and more!</description><managingEditor>noreply@blogger.com (Lalit Raghuvanshi)</managingEditor><pubDate>Sat, 28 Mar 2026 04:55:32 +0530</pubDate><generator>Blogger http://www.blogger.com</generator><openSearch:totalResults xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/">514</openSearch:totalResults><openSearch:startIndex xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/">1</openSearch:startIndex><openSearch:itemsPerPage xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/">25</openSearch:itemsPerPage><link>http://www.webcodeexpert.com/</link><language>en-us</language><itunes:explicit>no</itunes:explicit><itunes:subtitle>It is a collection of code snippets for web programmers, including code for Asp.Net,Sql Server,C#.Net,VB.Net,MVC Ajax,jQuery,JavaScript,XML,LINQ,WCF Services,C,C++,Interview Questions answers and more!</itunes:subtitle><itunes:owner><itunes:email>noreply@blogger.com</itunes:email></itunes:owner><item><title>5 Tips and Tricks That Can Help Beginner Software Developers</title><link>http://www.webcodeexpert.com/2022/02/5-tips-and-tricks-that-can-help.html</link><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Tue, 8 Feb 2022 22:38:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-3303253104453395999</guid><description>&lt;h1 style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;p class="normal" style="font-size: medium; font-weight: 400; margin-bottom: 10pt;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;The average salary for a software developer in the US is just under $120,000. That makes this field a particularly lucrative one, especially considering that you don’t need to have a degree to start a career in this field, and more importantly, you don’t have to do it 9 to 5. You can make a career around software development sitting at home.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="font-size: medium; font-weight: 400; margin-bottom: 10pt;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;This post is about the top 5 tips and tricks that can help anyone start a career in software development. This is a generalized piece of advice and does not apply to any specific language. If you want to be a better developer, this can help.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;/h1&gt;&lt;h2 style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span style="color: #cc0000;"&gt;&lt;a name="_2h21cdezcnut"&gt;&lt;/a&gt;&lt;span lang="EN"&gt;Languages are not Everything&lt;/span&gt;&lt;/span&gt;&lt;/h2&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;Please
don’t get this wrong, programming languages are important as they are the means
of communicating with the computer, but they are not the most critical part of
being a developer or learning software development. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;You
can start your programming journey with Java, Python, C++, or any other
language but can eventually switch to another as the difference between
programming languages is not that huge. What’s important is developing the
logic that gets the job done. Once you get a hold of that, you can develop in
any language and even tackle 

  &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/05/most-important-sql-server-interview.html" target="_blank"&gt;&lt;span style="color: #2b00fe;"&gt;interview questions&lt;/span&gt;&lt;/a&gt;&lt;/u&gt;
  in a language that’s alien to
you. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;You
don’t even need to worry about which language is the most popular now or which
one is expected to be the most in-demand in five years. Focus on developing the
logic because you can always get help with the syntax, but the logic is what
you need to create on your own when working as a developer.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;Start
with learning the core concepts of any programming language of your choice,
like assigning variables, doing loops, data types, conditionals, etc. Once
you’re proficient in that, all programming languages use almost the same
concepts. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;h2 style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span style="color: #cc0000;"&gt;&lt;a name="_hxysfdiwcffq"&gt;&lt;/a&gt;&lt;span lang="EN"&gt;Beware of Open Source&lt;/span&gt;&lt;/span&gt;&lt;/h2&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;As
a developer, you cannot create all of your code on your own; you’ll be using a
lot of other people’s work, aka open source. Now, open-source is a great way to
decrease the time and effort needed to develop, but it does come with risks.
You need to be aware of the &lt;u&gt;&lt;a href="https://snyk.io/learn/risks-of-open-source-software/" target="_blank"&gt;&lt;span style="color: #2b00fe;"&gt;risks of open-source software&lt;/span&gt;&lt;/a&gt;&lt;/u&gt; components before you
use them in your code. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;One
of the things you can do to make sure that you are not compromising the safety
and security of your code by using open source is always to use open source
components from a credible source. Using a software composition analysis tool
or a vulnerability scanner can also find and point out flaws in the open-source
components you are using. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;If
you are at the very early stages of your journey as a developer and cannot
afford to use any of that, you can always consult forums and find out what
fellow developers say about the open source components you are about to use. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;h2 style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span style="color: #cc0000;"&gt;&lt;a name="_eojwfrtgik71"&gt;&lt;/a&gt;&lt;span lang="EN"&gt;Practice Makes a Developer Perfect &lt;/span&gt;&lt;/span&gt;&lt;/h2&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;There’s
nothing better than practice to help you become a good developer. Most beginner
developers don’t have anything to practice their developing skills. There’s a
solution to that, suggested by Ronan O’Dulaing, the vice-president of
engineering at Globoforce. He says, “Pick problems to solve, perhaps related to
your home or your other hobbies, and use your chosen language to figure them
out. There are lots of tutorials online to get you started.”&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;As
a beginner, you don’t need to work on actual projects; you might not have any.
Find any problem around you that can be solved with some lines of code and
solve it. Keep doing that, and you’ll start getting a hold of the core concepts
and logic of development. Once you do that, it will go a long way in your
journey as a developer. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;h2 style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span style="color: #cc0000;"&gt;&lt;a name="_b2zmstifrz4f"&gt;&lt;/a&gt;&lt;span lang="EN"&gt;Learn to Develop Without an IDE &lt;/span&gt;&lt;/span&gt;&lt;/h2&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;You’ll
use an IDE when coding for a job, but not using one puts you in a difficult
position and helps you learn better. It is way harder to write code without,
say,  &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/03/how-to-start-visual-studio-from-command.html" target="_blank"&gt;&lt;span style="color: #2b00fe;"&gt;Visual Studio&lt;/span&gt;&lt;/a&gt;&lt;/u&gt;. You’ll definitely spend a lot of time dealing with issues
like indentation, imports, or syntax. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;However,
that will happen at the start; once you practice things, it becomes very
smooth. This will also help you learn what the IDE is doing for you. Yor
concepts of things like file organization in the file system, code compilation,
and dependency management will develop. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;The
point is not to never use an IDE; that is not the practical approach. Once you
learn to write the code in a text editor and get it to execute, you’ll be so
much better at doing the same using an IDE. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;h2 style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span style="color: #cc0000;"&gt;&lt;a name="_v3pb96twakhs"&gt;&lt;/a&gt;&lt;span lang="EN"&gt;Take it Slow &lt;/span&gt;&lt;/span&gt;&lt;/h2&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;No
matter which language you are starting with, you can quickly learn the core
concepts, syntax, and data structure, but that is not enough. Take your time to
get a hold of the language before moving ahead. If you rush and don’t fully
understand the language you are learning, the holes in your knowledge will
always haunt your career as a developer. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;Software
development is a vast field, and it is natural to spend time learning it.
Rushing through it and being impatient will not do you any good. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;h2 style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span style="color: #cc0000;"&gt;&lt;a name="_ellxcsvzspfy"&gt;&lt;/a&gt;&lt;span lang="EN"&gt;Conclusion&lt;/span&gt;&lt;/span&gt;&lt;/h2&gt;&lt;p&gt;













































&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;span style="font-family: helvetica; font-size: medium;"&gt;Software
development is a lucrative career to pursue, and the best thing is that the
skills you need to make a career in this field can be learned very easily. If
you are a beginner in this field, don’t mind the languages, you can start
learning with any one of them and then switch if need be. You’ll be using many
open source components as a developer so take necessary precautions when
dealing with them. Practice as much as you can; it is the only way to become a
better developer. Learning to code without using an IDE will hone your skills
and knowledge. Last but not least, take your time and don’t rush with learning
programming.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;b style="text-align: left;"&gt;&lt;i&gt;&lt;span style="color: #cc0000; font-size: large;"&gt;Now over to you:&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;/p&gt;&lt;p class="normal" style="margin-bottom: 10pt; text-align: justify;"&gt;&lt;span lang="EN"&gt;&lt;/span&gt;&lt;/p&gt;&lt;blockquote class="tr_bq" style="margin: 0px;"&gt;&lt;span style="font-size: medium;"&gt;&lt;i&gt;&lt;span style="background: white; font-family: &amp;quot;cambria&amp;quot; , serif;"&gt;A blog is nothing without reader's feedback and comments. So please provide your valuable feedback so that i can make this blog better and&amp;nbsp;&lt;/span&gt;&lt;/i&gt;&lt;i&gt;&lt;span face="&amp;quot;calibri&amp;quot; , sans-serif" style="background: white;"&gt;If you like my work; you can appreciate by leaving your comments, hitting Facebook&amp;nbsp;like button, following on Google+, Twitter, Linked in and Pinterest, stumbling my posts on stumble upon and subscribing for receiving free updates directly to your inbox . Stay tuned and stay connected for more technical updates.&lt;/span&gt;&lt;/i&gt;&lt;/span&gt;&lt;/blockquote&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>SQL Server: How to remove First and Last character from string</title><link>http://www.webcodeexpert.com/2020/05/sql-server-how-to-remove-first-and-last.html</link><category>Remove First and Last character from sql string</category><category>Sql Server</category><category>Sql tips and tricks</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Sun, 17 May 2020 14:38:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-1979062648457299679</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span data-original-attrs="{&amp;quot;style&amp;quot;:&amp;quot;background-color: transparent; color: #cc0000; font-family: \&amp;quot;segoe ui\&amp;quot; , sans-serif; font-size: x-large;&amp;quot;}" style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: large;"&gt;Introduction&lt;/span&gt;&lt;span data-original-attrs="{&amp;quot;style&amp;quot;:&amp;quot;color: #cc0000; font-family: \&amp;quot;segoe ui\&amp;quot; , sans-serif; font-size: x-large;&amp;quot;}" style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: large;"&gt;: &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;In this article I am going to
explain How to remove first and last character from string in sql server. We
will also update trimmed string into table. &lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/02/sql-server-query-to-split-string-from.html" target="_blank"&gt;How to &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/02/sql-server-query-to-split-string-from.html" target="_blank"&gt;Split string from comma and get left and right part&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/07/remove-first-or-last-character-from.html" target="_blank"&gt;How to &lt;o:p&gt;&lt;/o:p&gt;&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/07/remove-first-or-last-character-from.html" target="_blank"&gt;Remove first or last character from string or column in sql server&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/01/concatenate-rows-values-as-comma.html" target="_blank"&gt;Concatenate rows values as a comma separated string using for xml path and stuff&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/08/sql-server-query-to-get-string-between.html" target="_blank"&gt;Query to get string between two characters or symbols&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/12/how-to-count-number-of-occurrences-of.html" target="_blank"&gt;Count number of occurrences of character or word in a string in sql&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="background-color: white; color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: large;"&gt;Implementation:&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 16px;"&gt; &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; Let understand by
an example:&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;First lets consider we have a string
having square brackets and we want to remove these brackets from the string
i.e. we need to remove first and last character from string. Let’s write query
to get the desired result.&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/05/sql-server-how-to-remove-first-and-last.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>SQL Server: How to Toggle / Flip / Invert value of Bit column</title><link>http://www.webcodeexpert.com/2020/05/sql-server-how-to-toggle-flip-invert.html</link><category>Sql Server</category><category>Sql tips and tricks</category><category>Toggle Bit Value</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Sat, 9 May 2020 22:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-4039548880564835696</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span data-original-attrs="{&amp;quot;style&amp;quot;:&amp;quot;background-color: transparent; color: #cc0000; font-family: \&amp;quot;segoe ui\&amp;quot; , sans-serif; font-size: x-large;&amp;quot;}" style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: large;"&gt;Introduction&lt;/span&gt;&lt;span data-original-attrs="{&amp;quot;style&amp;quot;:&amp;quot;color: #cc0000; font-family: \&amp;quot;segoe ui\&amp;quot; , sans-serif; font-size: x-large;&amp;quot;}" style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: large;"&gt;: &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In
this article I am going to share some methods to invert / flip / toggle value of a
bit field / column in sql server i.e. converting value from 1 to 0 and vice
versa. &lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2018/09/generate-row-numberserial-number.html" target="_blank"&gt;How to &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2018/09/generate-row-numberserial-number.html" target="_blank"&gt;Generate row number/serial number without ordering by any columns&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/02/sql-rownumber-rank-denserank-ntile.html" target="_blank"&gt;Row_number(), rank(), dense_rank(), ntile() ranking functions&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/07/using-merge-in-sql-server-to-insert.html" target="_blank"&gt;Using merge in sql server to insert, update and delete in single statement&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-cte-recursive-query-to-get.html" target="_blank"&gt;CTE recursive query to get parent child hierarchy with levels&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/05/sql-server-function-to-check-column.html" target="_blank"&gt;Function to check column exists in table or not&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span data-original-attrs="{&amp;quot;style&amp;quot;:&amp;quot;font-family: \&amp;quot;segoe ui\&amp;quot; , sans-serif; font-size: 12pt;&amp;quot;}" style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;span style="background-color: white; color: #cc0000; font-size: large;"&gt;Implementation:&lt;/span&gt; &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt; Let’s create a dummy table for demonstration purpose using the following
script.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;CREATE&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;  &lt;/span&gt;&lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; dbo&lt;span style="color: grey;"&gt;.&lt;/span&gt;tbEmployeeMaster&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;(&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;            &lt;/span&gt;EmployeeId&lt;span style="mso-spacerun: yes;"&gt;      &lt;/span&gt;&lt;span style="color: blue;"&gt;INT&lt;/span&gt; &lt;span style="color: blue;"&gt;IDENTITY&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;1&lt;span style="color: grey;"&gt;,&lt;/span&gt;1&lt;span style="color: grey;"&gt;)&lt;/span&gt; &lt;span style="color: blue;"&gt;PRIMARY&lt;/span&gt; &lt;span style="color: blue;"&gt;KEY&lt;/span&gt;&lt;span style="color: grey;"&gt;,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;            &lt;/span&gt;Name&lt;span style="mso-spacerun: yes;"&gt;            &lt;/span&gt;&lt;span style="mso-spacerun: yes;"&gt;   &lt;/span&gt;&lt;span style="color: blue;"&gt;VARCHAR&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;100&lt;span style="color: grey;"&gt;),&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;            &lt;/span&gt;Age&lt;span style="mso-spacerun: yes;"&gt;             &lt;/span&gt;&lt;span style="mso-spacerun: yes;"&gt;     &lt;/span&gt;&lt;span style="color: blue;"&gt;INT&lt;/span&gt;&lt;span style="color: grey;"&gt;,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;            &lt;/span&gt;IsActive&lt;span style="mso-tab-count: 1;"&gt;           &lt;/span&gt;&lt;span style="mso-spacerun: yes;"&gt; &lt;/span&gt;&lt;span style="color: blue;"&gt;BIT&lt;/span&gt;&lt;span style="mso-spacerun: yes;"&gt;  &lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;)&lt;/span&gt;&lt;br&gt;
&lt;/div&gt;&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/05/sql-server-how-to-toggle-flip-invert.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>SQL SERVER: Function to check column exists in table or not?</title><link>http://www.webcodeexpert.com/2020/05/sql-server-function-to-check-column.html</link><category>Check Column Existence in table</category><category>SQL</category><category>Sql Server</category><category>Sql tips and tricks</category><category>User Defined Functions</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Sat, 2 May 2020 21:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-4836718490234284190</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;&lt;span style="background-color: transparent; color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt; &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In this article I am going to explain how to check whether column exists in table or not; if not only then add the column. We will create a user defined function to check column existence.&lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles I have explained &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-how-to-split-or-convert.html" target="_blank"&gt;How to split or convert delimited string into rows without using function&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-how-to-sort-alphanumeric.html" target="_blank"&gt;Sort alphanumeric string data in table&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-cte-recursive-query-to-get.html" target="_blank"&gt;CTE recursive query to get parent child hierarchy with levels&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-how-to-add-unique.html" target="_blank"&gt;Add unique constraint/index on a column that allows multiple null values&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-case-statement-to-sort.html" target="_blank"&gt;Case statement to sort records by different columns of different data types&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;&lt;span style="background-color: white; color: #cc0000;"&gt;Description:&lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; Very often we need to add new columns in tables. We write ALTER TABLE command in development server to add new column in table using the following syntax:&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;ALTER&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt; &lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; table_name &lt;span style="color: blue;"&gt;ADD&lt;/span&gt; column_name datatype&lt;span style="color: grey;"&gt;.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/05/sql-server-function-to-check-column.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>SQL SERVER: How to split or convert delimited string into rows without using function</title><link>http://www.webcodeexpert.com/2020/04/sql-server-how-to-split-or-convert.html</link><category>Split comma separated string</category><category>Split delimited string</category><category>Sql Server</category><category>Sql tips and tricks</category><category>XML</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Sat, 18 Apr 2020 10:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-187255144402252913</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #cc0000;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt;&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt; &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In this article I am going to explain How to convert
or split the delimited string (comma separated string) into table rows by
converting them into xml and then parsing the xml to split them in rows. &lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;In previous articles I have explained How to &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/05/convert-or-split-comma-separated-string.html" target="_blank"&gt;Convert or split comma separated string into table rows in sql server&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/08/how-to-get-column-values-as-comma.html" target="_blank"&gt;Get column values as comma separated list in sql server&lt;/a&gt;&lt;/u&gt; and  &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/02/sql-server-query-to-split-string-from.html" target="_blank"&gt;Split string from comma and get left and right part&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/01/concatenate-rows-values-as-comma.html" target="_blank"&gt;Concatenate rows values as a comma separated string using for xml path and stuff&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/02/sql-server-separate-integer-and.html" target="_blank"&gt;Separate integer and fractional part from decimal number&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="background-color: white; color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Implementation:&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; Let’s create a table and add dummy data using the following script&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/sql-server-how-to-split-or-convert.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Sql server: How to sort alphanumeric string data in table</title><link>http://www.webcodeexpert.com/2020/04/sql-server-how-to-sort-alphanumeric.html</link><category>Alphanumeric sort in SQL</category><category>SORT Records</category><category>Sort table data</category><category>Sql Server</category><category>Sql tips and tricks</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Sat, 11 Apr 2020 23:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-2530931649875152878</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #cc0000;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt;&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt; &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In this article I am going to explain how to sort
alphanumeric string data/records in sql table. &lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/10/update-using-inner-join-in-sql-server.html" target="_blank"&gt;How to &lt;o:p&gt;&lt;/o:p&gt;&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/10/update-using-inner-join-in-sql-server.html" target="_blank"&gt;Update table data using inner join in sql server&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/08/sql-server-drop-or-truncate-parent.html" target="_blank"&gt;Drop or truncate parent table by dropping all foreign key constraints&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-cte-recursive-query-to-get.html" target="_blank"&gt;CTE recursive query to get parent child hierarchy with levels&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/02/sql-rownumber-rank-denserank-ntile.html" target="_blank"&gt;Row_number(), rank(), dense_rank(), ntile() ranking functions&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="background-color: white; color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Implementation:&lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;  &lt;/span&gt;Let’s create a temporary table having alphanumeric
data using the following script.&lt;span style="color: blue; mso-no-proof: yes;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;o:p&gt;GO&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;IF&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt; &lt;span style="color: magenta;"&gt;OBJECT_ID&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;&lt;span style="color: red;"&gt;&amp;#39;tempdb.dbo.#tbTest&amp;#39;&lt;/span&gt;&lt;span style="color: grey;"&gt;,&lt;/span&gt; &lt;span style="color: red;"&gt;&amp;#39;U&amp;#39;&lt;/span&gt;&lt;span style="color: grey;"&gt;)&lt;/span&gt; &lt;span style="color: grey;"&gt;IS&lt;/span&gt; &lt;span style="color: grey;"&gt;NOT&lt;/span&gt; &lt;span style="color: grey;"&gt;NULL&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;  &lt;/span&gt;&lt;span style="color: blue;"&gt;DROP&lt;/span&gt; &lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; #tbTest&lt;span style="color: grey;"&gt;;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 16px;"&gt;GO&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;  &lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;CREATE&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt; &lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; #tbTest&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;(&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-tab-count: 1;"&gt;            &lt;/span&gt;Data &lt;span style="color: blue;"&gt;VARCHAR&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;20&lt;span style="color: grey;"&gt;)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;)&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/sql-server-how-to-sort-alphanumeric.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>How to center align an image or div using CSS</title><link>http://www.webcodeexpert.com/2020/04/how-to-center-align-image-or-div-using.html</link><category>Center Align Div using CSS</category><category>Center Align Image using CSS</category><category>CSS</category><category>HTML</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Fri, 10 Apr 2020 23:30:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-369937230511744575</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #cc0000;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt;&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt; &lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In this article I am going to explain how to center align an image or the div element with the help&lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; of&lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; CSS.  &lt;/span&gt;&lt;br&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhX7EchhHqUL6tkbCL4JOKjoPR2kFYfjP3JS9O-so4L42AcZghMD5AOpLUGVFr71r09EdO07pxWWOTvfzAMhJZmqeCHW3CzO-te9Q8CB0iLvEx79PVzA9FhzidtCbXnF6MkSZOdaBA8eM/s1600/center+aligned+image+and+div.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" data-original-height="198" data-original-width="310" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhX7EchhHqUL6tkbCL4JOKjoPR2kFYfjP3JS9O-so4L42AcZghMD5AOpLUGVFr71r09EdO07pxWWOTvfzAMhJZmqeCHW3CzO-te9Q8CB0iLvEx79PVzA9FhzidtCbXnF6MkSZOdaBA8eM/s1600/center+aligned+image+and+div.PNG"&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="background: white; color: blue; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/06/how-to-show-tool-tip-message-using-css.html" target="_blank"&gt;How to &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/06/how-to-show-tool-tip-message-using-css.html" target="_blank"&gt;Show tool tip message using css and html in asp.net website&lt;/a&gt;&lt;/u&gt; &lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/10/how-to-show-animated-bootstrap-alert.html" target="_blank"&gt;Show animated bootstrap alert messages in asp.net&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/02/dropdownlist-with-checkboxes-using.html" target="_blank"&gt;Dropdownlist with checkboxes using jquery bootstrap multi select plugin&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/10/css-to-change-background-and-border.html" target="_blank"&gt;Css to change background and border color of asp.net extbox and multiline textbox on hover&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/11/jquery-to-enlarge-thumbnail-image-in.html" target="_blank"&gt;Jquery to enlarge thumbnail image in slider on mouse over in asp.net&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="background: white; color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description:&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif;"&gt; &lt;/span&gt;&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot;, sans-serif; font-size: 12pt;"&gt;Sometimes it is required to show image or div element in the center of the page. We can simply align them using CSS as shown below in example.&lt;/span&gt;&lt;br&gt;
&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot;, sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/how-to-center-align-image-or-div-using.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhX7EchhHqUL6tkbCL4JOKjoPR2kFYfjP3JS9O-so4L42AcZghMD5AOpLUGVFr71r09EdO07pxWWOTvfzAMhJZmqeCHW3CzO-te9Q8CB0iLvEx79PVzA9FhzidtCbXnF6MkSZOdaBA8eM/s72-c/center+aligned+image+and+div.PNG" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>How to make rounded image using CSS</title><link>http://www.webcodeexpert.com/2020/04/how-to-make-rounded-image-using-css.html</link><category>border-radius in CSS</category><category>CSS</category><category>HTML</category><category>Rounded image using CSS</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Fri, 10 Apr 2020 23:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-1491238342145835242</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #cc0000;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt;&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt; &lt;/span&gt;In this article I am going to explain how to make
rounded image or we can say circular image using &lt;span style="background: white; color: red;"&gt;border-radius&lt;/span&gt;&lt;span style="color: black;"&gt; property of&lt;/span&gt; CSS. &lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhe9IpU5DgrBRJ4fdVHpoMNUWrwqpZpdEUFVqCon7_p-fCMXyhqXGFRxWNemHYr764qe_N4bgVhmnmKBHQ8vhyphenhyphenfNDMNDKov0ujKzsWg8x3ulptbw-IJqGacgaw9orIrY8YGDAev_pa2Agk/s1600/rounded+image+using+jquery.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img alt="How to make rounded image using CSS" border="0" data-original-height="179" data-original-width="337" height="169" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhe9IpU5DgrBRJ4fdVHpoMNUWrwqpZpdEUFVqCon7_p-fCMXyhqXGFRxWNemHYr764qe_N4bgVhmnmKBHQ8vhyphenhyphenfNDMNDKov0ujKzsWg8x3ulptbw-IJqGacgaw9orIrY8YGDAev_pa2Agk/s320/rounded+image+using+jquery.png" title="How to make rounded image using CSS" width="320"&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/css-to-hide-first-last-or-nth-column-of.html" target="_blank"&gt;How to&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/css-to-hide-first-last-or-nth-column-of.html" target="_blank"&gt; hide first / last or nth column of table before printing using css&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/07/convert-text-to-uppercase-or-lowercase.html" target="_blank"&gt;Convert text to uppercase or lowercase while typing in asp.net textbox using css&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2014/06/how-to-create-jquery-scrollable.html" target="_blank"&gt;Create jquery scrollable gridview with fix header in asp.net c#,vb&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/02/highlight-gridview-row-on-mouse-over.html" target="_blank"&gt;Highlight gridview row on mouse over using css in asp.net&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/12/change-border-and-background-color-of.html" target="_blank"&gt;Change border and background color of asp.net controls on validation failure using javascript and css&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; &lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description:&lt;/span&gt; Sometimes it is required to show image in
round shape to make it more attractive or as per requirement to suit the page layout. We can simply make
the image circular using the border-radius property to add rounded corners to
an image. Setting this property to 50% will make the image round.&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/how-to-make-rounded-image-using-css.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhe9IpU5DgrBRJ4fdVHpoMNUWrwqpZpdEUFVqCon7_p-fCMXyhqXGFRxWNemHYr764qe_N4bgVhmnmKBHQ8vhyphenhyphenfNDMNDKov0ujKzsWg8x3ulptbw-IJqGacgaw9orIrY8YGDAev_pa2Agk/s72-c/rounded+image+using+jquery.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>jQuery: Difference between .empty() and .remove methods with examples</title><link>http://www.webcodeexpert.com/2020/04/jquery-difference-between-empty-and.html</link><category>.empty() in jquery</category><category>.remove() in jQuery</category><category>JavaScript</category><category>Jquery</category><category>jQuery Tips &amp; Tricks</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Fri, 10 Apr 2020 22:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-2713242818138102314</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #cc0000;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; jQuery provides various methods like .empty(), .remove() and .detach() to remove elements from DOM.&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;  &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;And in this article, I will show you how
these methods .empty() vs .remove() are used to remove elements and different from each other with suitable
examples. I will explain .detach() method in upcoming article. &lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles  I have explained How to &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-all-except-one-or.html" target="_blank"&gt;Remove all except one or first or last item from dropdown using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/check-and-display-warning-message-if.html" target="_blank"&gt;Check and display warning message if caps lock key is on using javascript&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/03/add-textbox-search-functionality-in.html" target="_blank"&gt;Add textbox search functionality in asp.net checkboxlist using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/02/bootstrap-modal-dialog-popup-example-in.html" target="_blank"&gt;Bootstrap modal dialog popup example in asp.net&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/10/how-to-show-animated-bootstrap-alert.html" target="_blank"&gt;Show animated bootstrap alert messages in asp.net&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;Let’s start with jQuery&amp;#39;s .empty() method:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;jQuery .empty() method&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description: &lt;/span&gt;The .empty() method clears the contents of the
selected element (e.g. &amp;lt;div&amp;gt; element), along with the child nodes (if
any). Let’s demonstrate with an example.&lt;/span&gt;&lt;br&gt;
&lt;/div&gt;&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/jquery-difference-between-empty-and.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuudSDG0lSCKPHELTBG6d5eacm7KP0nDn6-fzyMTpOyx347Oq6othS_WuTJBHNWCYb7mN7ZMQsP5Fc00RtDS7tmQCZYGry0wg-CAa85vohFY4fs-ah3JlT-71xkXrg2Ki013qbIrMgECE/s72-c/empty.gif" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>jQuery to remove all except one or first or last item from select option(dropdown)</title><link>http://www.webcodeexpert.com/2020/04/jquery-to-remove-all-except-one-or.html</link><category>.remove() in jQuery</category><category>:not() selector in jquery</category><category>DropDownList</category><category>HTML</category><category>HTML Select</category><category>JavaScript</category><category>Jquery</category><category>jQuery Tips &amp; Tricks</category><category>Select option</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Thu, 9 Apr 2020 22:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-4409821526945263263</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #cc0000;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; Here in this article I am going to explain
how to remove all items from the dropdown except the first item, last item or
any one as per requirement from the select element i.e. dropdownlist using
jQuery. &lt;/span&gt;&lt;br&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8jPmHgAbKiVCWoXxK4qdsCcR0VL-nHnxDrkIE90wPVsRmcOAG9-1Fpelt5K80B7EH-3kRW_cWFZfb2MVd5N8-DAFzgUrMcmTvUwsbEGzJjUkfqviiKabOgLyQhjizFBFYqEElRvx_1A4/s1600/zzz.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img alt="jQuery to remove all except one or first or last item from select option(dropdown)" border="0" data-original-height="117" data-original-width="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8jPmHgAbKiVCWoXxK4qdsCcR0VL-nHnxDrkIE90wPVsRmcOAG9-1Fpelt5K80B7EH-3kRW_cWFZfb2MVd5N8-DAFzgUrMcmTvUwsbEGzJjUkfqviiKabOgLyQhjizFBFYqEElRvx_1A4/s1600/zzz.gif" title="jQuery to remove all except one or first or last item from select option(dropdown)"&gt;&lt;/a&gt;&lt;/div&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles I have explained How to &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-item-by-value-or-text.html" target="_blank"&gt;Remove item by value or text or index from dropdown&lt;/a&gt;&lt;/u&gt;  and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-first-last-or-selected.html" target="_blank"&gt;Remove first, last or selected item from dropdown&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-multiple-or-all.html" target="_blank"&gt;Remove multiple or all items from dropdown&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and  &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2014/11/auto-resize-textarea-or-aspnet.html" target="_blank"&gt;Auto resize textarea or asp.net multiline textbox based on content using javascript&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-difference-between-empty-and.html" target="_blank"&gt;Difference between .empty() and .remove jquery methods with examples&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description:&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; jQuery provides some interesting methods
that would help remove items (options) from dropdown. We can remove all the
items, multiple items or remove specific (single) item, remove all except
first, remove all except last, remove all except one, remove first item, remove
last item, remove selected item, remove item by item text/value/index as per
requirement.&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/jquery-to-remove-all-except-one-or.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8jPmHgAbKiVCWoXxK4qdsCcR0VL-nHnxDrkIE90wPVsRmcOAG9-1Fpelt5K80B7EH-3kRW_cWFZfb2MVd5N8-DAFzgUrMcmTvUwsbEGzJjUkfqviiKabOgLyQhjizFBFYqEElRvx_1A4/s72-c/zzz.gif" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>jQuery to remove multiple or all items from select option(dropdown)</title><link>http://www.webcodeexpert.com/2020/04/jquery-to-remove-multiple-or-all.html</link><category>.filter() in jquery</category><category>.remove() in jQuery</category><category>DropDownList</category><category>HTML</category><category>HTML Select</category><category>JavaScript</category><category>Jquery</category><category>jQuery Tips &amp; Tricks</category><category>Select option</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Wed, 8 Apr 2020 17:55:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-5801827721065629086</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #cc0000;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt;&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt; &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;Here in this article I am going to explain how to remove all or multiple options / elements / items at once from the select
element i.e. dropdownlist using jQuery. &lt;/span&gt;&lt;br&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj00em0CMoD835TKYwqHcOt82kzsa1QFlO9NmUrGRQo6lkqAqzcvXCpRv5z8Lo6jtdhmo5A9_G_9i322NfTP4w3PPbs4WSkS3siXKY48FdNho1I-78GhQfCIsOY924m976gjwCQQCMM9rE/s1600/999.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img alt="jQuery to remove multiple or all elements / items from select option(dropdown)" border="0" data-original-height="123" data-original-width="258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj00em0CMoD835TKYwqHcOt82kzsa1QFlO9NmUrGRQo6lkqAqzcvXCpRv5z8Lo6jtdhmo5A9_G_9i322NfTP4w3PPbs4WSkS3siXKY48FdNho1I-78GhQfCIsOY924m976gjwCQQCMM9rE/s1600/999.gif" title="jQuery to remove multiple or all elements / items from select option(dropdown)"&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-item-by-value-or-text.html" target="_blank"&gt;How to &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-item-by-value-or-text.html" target="_blank"&gt;Remove item by value or text or index from dropdown using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-first-last-or-selected.html" target="_blank"&gt;Remove first, last or selected item from dropdown&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and  &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2014/08/jquery-to-limit-and-display-number-of.html" target="_blank"&gt;Limit and display number of characters left in asp.net multiline textbox using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/07/example-to-validate-aspnet-checkboxlist.html" target="_blank"&gt;Validate asp.net checkboxlist using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;u style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 16px;"&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-difference-between-empty-and.html" target="_blank"&gt;Difference between .empty() and .remove jquery methods with examples&lt;/a&gt;&lt;/u&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description:&lt;/span&gt;&lt;span style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; &lt;/span&gt; jQuery provides some interesting methods
that would help remove items (options) from dropdown. We can either remove all
the items, multiple items or remove specific (single) item, remove all except first,
remove all except last, remove all except one, remove first item, remove last
item,&lt;span style="mso-spacerun: yes;"&gt;  &lt;/span&gt;remove selected item, remove item
by text or by value or by index as per requirement. &lt;/span&gt;&lt;br&gt;
&lt;/div&gt;&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/jquery-to-remove-multiple-or-all.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj00em0CMoD835TKYwqHcOt82kzsa1QFlO9NmUrGRQo6lkqAqzcvXCpRv5z8Lo6jtdhmo5A9_G_9i322NfTP4w3PPbs4WSkS3siXKY48FdNho1I-78GhQfCIsOY924m976gjwCQQCMM9rE/s72-c/999.gif" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>jQuery to remove item by value or text or index from select option(dropdown).</title><link>http://www.webcodeexpert.com/2020/04/jquery-to-remove-item-by-value-or-text.html</link><category>.remove() in jQuery</category><category>DropDownList</category><category>HTML</category><category>HTML Select</category><category>JavaScript</category><category>Jquery</category><category>jQuery Tips &amp; Tricks</category><category>Select option</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Wed, 8 Apr 2020 12:03:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-8509141859384784915</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #cc0000;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;span style="color: #cc0000;"&gt; &lt;/span&gt;Here in this article I am going to explain how to remove dropdown item by value or by text or by index using jQuery&amp;#39;s method remove(). I have also mentioned the ways to select items to remove. &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; &lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgH3q63EcIivhXDoOheVs2UtD9Znk3Nc_fMuolzyavCleyzyAkeoP8cQeZ3KOnDhmNFVe95wJMMNnYxeaSEKMpeX3n8hmRzFKyaAJE6-ShizTE0ZfgNsuL0R1fg1oqFPmlFJXRMrLXd8WE/s1600/777.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img alt="jQuery to remove item by value or text or index from select option(dropdown)." border="0" data-original-height="123" data-original-width="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgH3q63EcIivhXDoOheVs2UtD9Znk3Nc_fMuolzyavCleyzyAkeoP8cQeZ3KOnDhmNFVe95wJMMNnYxeaSEKMpeX3n8hmRzFKyaAJE6-ShizTE0ZfgNsuL0R1fg1oqFPmlFJXRMrLXd8WE/s1600/777.gif" title="jQuery to remove item by value or text or index from select option(dropdown)."&gt;&lt;/a&gt;&lt;/div&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles I have explained How to &lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-first-last-or-selected.html" target="_blank"&gt;Remove first, last or selected item from dropdown&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-item-by-value-or-text.html" target="_blank"&gt;Remove item by value or text or index from dropdown&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and  &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/03/jquery-to-select-all-text-in-aspnet-and.html" target="_blank"&gt;S&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/03/jquery-to-select-all-text-in-aspnet-and.html" target="_blank"&gt;elect all text in asp.net and html textbox on click or focus using jQuery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/03/add-textbox-search-functionality-in.html" target="_blank"&gt;Add textbox search functionality in checkboxlist using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;u style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 16px;"&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-difference-between-empty-and.html" target="_blank"&gt;Difference between .empty() and .remove jquery methods with examples&lt;/a&gt;&lt;/u&gt;&lt;br&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="color: #cc0000; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description:&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; jQuery provides some interesting methods
that would help remove items (options) from dropdown. We can either remove all
the items, multiple items or remove specific (single) item, remove all except
first, remove all except last, remove all except one, remove first item, remove
last item, remove selected item, remove item by item text or by value or by
index as per requirement.&lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;/span&gt;&lt;br&gt;
&lt;/div&gt;&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/jquery-to-remove-item-by-value-or-text.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgH3q63EcIivhXDoOheVs2UtD9Znk3Nc_fMuolzyavCleyzyAkeoP8cQeZ3KOnDhmNFVe95wJMMNnYxeaSEKMpeX3n8hmRzFKyaAJE6-ShizTE0ZfgNsuL0R1fg1oqFPmlFJXRMrLXd8WE/s72-c/777.gif" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>jQuery to remove first, last or selected item from select option(dropdown).</title><link>http://www.webcodeexpert.com/2020/04/jquery-to-remove-first-last-or-selected.html</link><category>.remove() in jQuery</category><category>DropDownList</category><category>HTML</category><category>HTML Select</category><category>JavaScript</category><category>Jquery</category><category>jQuery Tips &amp; Tricks</category><category>Select option</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Wed, 8 Apr 2020 10:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-4669131136563975351</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;Here in this article I am going to explain how to remove &lt;/span&gt;&lt;span style="background: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;first,
last or selected &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;item from the select element i.e. dropdownlist using
jQuery. &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-D-RjeOc3OZwEnoajMZMZr6ZVNLcbQCbOadmgX8muNeMD2bmkBlMUShiEgrncu-0-BFR3qxywxYngDhrwJ5nrzkjLDSMt-Afc6Fd1kRThQQtw6Lbt37isTADagDZFh7dwkRXvURs5LL8/s1600/mmm.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img alt="jQuery to remove first, last or selected item from select option(dropdown)" border="0" data-original-height="123" data-original-width="258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-D-RjeOc3OZwEnoajMZMZr6ZVNLcbQCbOadmgX8muNeMD2bmkBlMUShiEgrncu-0-BFR3qxywxYngDhrwJ5nrzkjLDSMt-Afc6Fd1kRThQQtw6Lbt37isTADagDZFh7dwkRXvURs5LL8/s1600/mmm.gif" title="jQuery to remove first, last or selected item from select option(dropdown)"&gt;&lt;/a&gt;&lt;/div&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-item-by-value-or-text.html" target="_blank"&gt;How to &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-item-by-value-or-text.html" target="_blank"&gt;remove item by value or text or index from select option(dropdown) &lt;/a&gt;&lt;/u&gt;and &lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-remove-multiple-or-all.html" target="_blank"&gt;Remove multiple or all items from dropdown&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and  &lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/08/jquery-to-show-image-preview-after.html" target="_blank"&gt;Jquery to show image preview after validating image size and type before upload in asp.net&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/07/jquery-slide-up-down-div-content-based.html" target="_blank"&gt;Slide up down div content based on asp.net checkbox check uncheck using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;u style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 16px;"&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-difference-between-empty-and.html" target="_blank"&gt;Difference between .empty() and .remove jquery methods with examples&lt;/a&gt;&lt;/u&gt;&lt;br&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;&lt;span style="color: black; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description:&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; jQuery provides some interesting methods
that would help remove items (options) from dropdown. We can remove all items,
multiple items or remove specific (single) item, remove all except first,
remove all except last, remove all except one, remove first item, remove last
item, remove selected item, remove item by item text/value/index as per
requirement. &lt;/span&gt;&lt;br&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/jquery-to-remove-first-last-or-selected.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-D-RjeOc3OZwEnoajMZMZr6ZVNLcbQCbOadmgX8muNeMD2bmkBlMUShiEgrncu-0-BFR3qxywxYngDhrwJ5nrzkjLDSMt-Afc6Fd1kRThQQtw6Lbt37isTADagDZFh7dwkRXvURs5LL8/s72-c/mmm.gif" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>jQuery to highlight gridview's single or all rows on checkbox check uncheck.</title><link>http://www.webcodeexpert.com/2020/04/jquery-to-highlight-gridviews-single-or.html</link><category>.addClass in jQuery</category><category>.removeClass in jQuery</category><category>ASP.NET</category><category>CSS</category><category>GridView Examples</category><category>Highlight GridView Row</category><category>JavaScript</category><category>Jquery</category><category>jQuery Tips &amp; Tricks</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Mon, 6 Apr 2020 21:05:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-7463688344798430257</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;: &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In this article I am going to explain How to highlight single or all rows in asp.net gridview on checkbox check uncheck using jQuery and CSS.  &lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;br&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMuRMs1-oUs3uCDdB8lbTeULqo6jSkrufvTqNIejb4mXHhAgbxikKjjS8grmsk7YqA405jJaGun7JlYD8xHblj6-aD5u2scTIcxJG4tBNtQMfnnxwQ2-0R12_XNCun7PgLMztfP4MTSTA/s1600/Highlight.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img alt="jQuery to highlight gridview&amp;#39;s single or all rows on checkbox check uncheck." border="0" data-original-height="182" data-original-width="405" height="143" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMuRMs1-oUs3uCDdB8lbTeULqo6jSkrufvTqNIejb4mXHhAgbxikKjjS8grmsk7YqA405jJaGun7JlYD8xHblj6-aD5u2scTIcxJG4tBNtQMfnnxwQ2-0R12_XNCun7PgLMztfP4MTSTA/s320/Highlight.gif" title="jQuery to highlight gridview&amp;#39;s single or all rows on checkbox check uncheck." width="320"&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;In previous articles I have explained &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/09/how-to-delete-multiple-selected.html" target="_blank"&gt;How to delete multiple selected records/items based on checkbox in gridview&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/12/bulk-insert-multiple-records-from.html" target="_blank"&gt;Bulk insert multiple records from gridview to sql database using xml data type in asp.net&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/12/sqlbulkcopy-to-insert-multiple-records.html" target="_blank"&gt;Sqlbulkcopy to bulk insert multiple records from gridview to sql database in asp.net&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/06/send-email-to-multiple-users-based-on.html" target="_blank"&gt;Send email to multiple users based on checkbox selection inside gridview&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-hide-first-last-or-nth-column.html" target="_blank"&gt;Jquery to hide first /last or nth column of table before printing&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;  &lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description: &lt;/span&gt;We usually add checkbox along with each record in gridview to select specific record and similarly to select all records at once we also add checkbox in gridview&amp;#39;s header. &lt;/span&gt;&lt;br&gt;
&lt;/div&gt;&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/jquery-to-highlight-gridviews-single-or.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMuRMs1-oUs3uCDdB8lbTeULqo6jSkrufvTqNIejb4mXHhAgbxikKjjS8grmsk7YqA405jJaGun7JlYD8xHblj6-aD5u2scTIcxJG4tBNtQMfnnxwQ2-0R12_XNCun7PgLMztfP4MTSTA/s72-c/Highlight.gif" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>jQuery to highlight single or all rows in asp.net repeater on checkbox check uncheck.</title><link>http://www.webcodeexpert.com/2020/04/jquery-to-highlight-single-or-all-rows.html</link><category>.addClass in jQuery</category><category>.removeClass in jQuery</category><category>CheckBox</category><category>CSS</category><category>Highlight Repeater Row</category><category>JavaScript</category><category>Jquery</category><category>jQuery Tips &amp; Tricks</category><category>Repeater</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Mon, 6 Apr 2020 21:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-5238766783813586353</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;: &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In this article I am going to explain How to highlight
single or all rows in asp.net repeater on checkbox check uncheck using jQuery and CSS.  &lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;br&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMuRMs1-oUs3uCDdB8lbTeULqo6jSkrufvTqNIejb4mXHhAgbxikKjjS8grmsk7YqA405jJaGun7JlYD8xHblj6-aD5u2scTIcxJG4tBNtQMfnnxwQ2-0R12_XNCun7PgLMztfP4MTSTA/s1600/Highlight.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img alt="jQuery to highlight single or all rows in asp.net repeater on checkbox check uncheck." border="0" data-original-height="182" data-original-width="405" height="143" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMuRMs1-oUs3uCDdB8lbTeULqo6jSkrufvTqNIejb4mXHhAgbxikKjjS8grmsk7YqA405jJaGun7JlYD8xHblj6-aD5u2scTIcxJG4tBNtQMfnnxwQ2-0R12_XNCun7PgLMztfP4MTSTA/s320/Highlight.gif" title="jQuery to highlight single or all rows in asp.net repeater on checkbox check uncheck." width="320"&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/01/check-uncheck-all-checkboxes-in-aspnet.html" target="_blank"&gt;How to &lt;o:p&gt;&lt;/o:p&gt;&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/01/check-uncheck-all-checkboxes-in-aspnet.html" target="_blank"&gt;Check uncheck all checkboxes in asp.net gridview using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/08/add-or-remove-items-from-one.html" target="_blank"&gt;Add or remove items from one checkboxlist to other in asp.net using c#,vb&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/check-and-display-warning-message-if.html" target="_blank"&gt;Check and display warning message if caps lock key is on using javascript&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/06/send-email-to-multiple-users-based-on.html" target="_blank"&gt;Send email to multiple users based on checkbox selection inside gridview in asp.net c#,vb&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/10/jquery-to-show-hide-password-characters.html" target="_blank"&gt;Jquery to show hide password characters in asp.net textbox on checkbox check uncheck&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;  &lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description: &lt;/span&gt;We usually add checkbox along with each record in repeater
to select specific record and similarly to select all records at once we also
add checkbox in repeater&amp;#39;s header. &lt;/span&gt;&lt;br&gt;
&lt;/div&gt;&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/jquery-to-highlight-single-or-all-rows.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMuRMs1-oUs3uCDdB8lbTeULqo6jSkrufvTqNIejb4mXHhAgbxikKjjS8grmsk7YqA405jJaGun7JlYD8xHblj6-aD5u2scTIcxJG4tBNtQMfnnxwQ2-0R12_XNCun7PgLMztfP4MTSTA/s72-c/Highlight.gif" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>SQL SERVER: CTE recursive query to get parent child hierarchy with levels</title><link>http://www.webcodeexpert.com/2020/04/sql-server-cte-recursive-query-to-get.html</link><category>Common Table Expression (CTE)</category><category>Recursive CTE</category><category>Sql Server</category><category>Sql tips and tricks</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Sun, 5 Apr 2020 21:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-4833994754060329208</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;:&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; In this article I am going to explain how
to create parent-child hierarchy(&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;Continent-&amp;gt; Country-&amp;gt; State-&amp;gt; City&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;) with levels using recursive common table
expression (CTE). &lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles i have explained How to use &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/09/sql-server-cte-recursive-query-to-get.html" target="_blank"&gt;CTE recursive query to get employee manager hierarchy with level&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/01/sql-server-using-cte-to-get-all-dates.html" target="_blank"&gt;Using CTE to get all dates between two specified dates&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;a href="https://www.webcodeexpert.com/2014/12/multiple-sql-server-queries-to-get-all.html" target="_blank"&gt;Multiple sql server queries to get all dates between two dates&lt;/a&gt; and &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-how-to-check-column.html" target="_blank"&gt;C&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-how-to-check-column.html" target="_blank"&gt;heck column existence before adding new column in table&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/02/sql-rownumber-rank-denserank-ntile.html" target="_blank"&gt;Row_number(), rank(), dense_rank(), ntile() ranking functions&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description:&lt;/span&gt; While working with database we often
store parent and child id in same table. For example category id and sub
category Id, employee id and his manager id etc.&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;Here in this article I am taking
an example where continents and their countries and state of that countries and
cities of that states are stored in same table. And suppose it is required to
get all of them in hierarchy e.g.&lt;/span&gt;&lt;b style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt; Continent-&amp;gt; Country-&amp;gt; State-&amp;gt; City&lt;/b&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;,
then CTE is very useful in such case because of its recursive capability. &lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/sql-server-cte-recursive-query-to-get.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>SQL SERVER: How to check column existence before adding new column in table?</title><link>http://www.webcodeexpert.com/2020/04/sql-server-how-to-check-column.html</link><category>Check Column Existence in table</category><category>COL_LENGTH in SQL</category><category>COLUMNPROPERTY in SQL</category><category>INFORMATION_SCHEMA.COLUMNS in SQL</category><category>Sql Server</category><category>SYS.COLUMNS in SQL</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Sat, 4 Apr 2020 21:05:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-3526512969060911656</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;: &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In this article I am going to explain how to check
whether column exists in table or not; if not only then add the column.&lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles I have explained How to use &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/07/using-merge-in-sql-server-to-insert.html" target="_blank"&gt;merge in sql server to insert, update and delete in single statement&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/04/sql-server-convert-table-data-to-xml.html" target="_blank"&gt;Convert table data to xml format using for xml path()&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2018/09/sql-server-how-to-get-n-random-number.html" target="_blank"&gt;Get n random number of records from table&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-case-statement-to-sort.html" target="_blank"&gt;Case statement to sort records by different columns of different data types&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2018/09/generate-row-numberserial-number.html" target="_blank"&gt;Generate row number/serial number without ordering by any columns&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;


&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description:&lt;/span&gt; Very often we need to add new columns in tables. We
write ALTER TABLE command in development server to add new column in table
using the following syntax:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;ALTER&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt; &lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; table_name &lt;span style="color: blue;"&gt;ADD&lt;/span&gt; column_name datatype&lt;span style="color: grey;"&gt;.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/sql-server-how-to-check-column.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>SQL SERVER: How to check whether column exists in table or not? </title><link>http://www.webcodeexpert.com/2020/04/sql-server-how-to-check-whether-column.html</link><category>Check Column Existence in table</category><category>COL_LENGTH in SQL</category><category>COLUMNPROPERTY in SQL</category><category>INFORMATION_SCHEMA.COLUMNS in SQL</category><category>Sql Server</category><category>SYS.COLUMNS in SQL</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Sat, 4 Apr 2020 21:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-594388846211479292</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;: &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In this article I am going to explain four methods to check
whether column exists in sql table or not. &lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles I have explained how to &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/08/search-particular-column-in-all-tables.html" target="_blank"&gt;Search particular column in all tables or views in sql server database&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2014/12/createcheck-and-drop-foreign-key.html" target="_blank"&gt;Create, check and drop foreign key constraint on table&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/08/sql-server-query-to-search-any-text-in.html" target="_blank"&gt;Query to search any text in all stored procedures,views and functions&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/04/sql-query-to-delete-or-select-first-or.html" target="_blank"&gt;Query to delete or select first or last n records from table&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2014/01/what-is-use-of-self-join-in-sql-server.html" target="_blank"&gt;Use of self joins in sql with example&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Implementation:&lt;/span&gt; Let&amp;#39;s create a demo table for demonstration
purpose using the following script.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;CREATE&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;  &lt;/span&gt;&lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; dbo&lt;span style="color: grey;"&gt;.&lt;/span&gt;tbEmployeeMaster&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;(&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;            &lt;/span&gt;EmployeeId&lt;span style="mso-spacerun: yes;"&gt;     &lt;/span&gt;&lt;span style="color: blue;"&gt;INT&lt;/span&gt; &lt;span style="color: blue;"&gt;IDENTITY&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;1&lt;span style="color: grey;"&gt;,&lt;/span&gt;1&lt;span style="color: grey;"&gt;)&lt;/span&gt; &lt;span style="color: blue;"&gt;PRIMARY&lt;/span&gt; &lt;span style="color: blue;"&gt;KEY&lt;/span&gt;&lt;span style="color: grey;"&gt;,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;            &lt;/span&gt;Name&lt;span style="mso-spacerun: yes;"&gt;            &lt;/span&gt;&lt;span style="mso-spacerun: yes;"&gt;  &lt;/span&gt;&lt;span style="color: blue;"&gt;VARCHAR&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;100&lt;span style="color: grey;"&gt;),&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;            &lt;/span&gt;Salary&lt;span style="mso-spacerun: yes;"&gt;          &lt;/span&gt;&lt;span style="mso-spacerun: yes;"&gt;    &lt;/span&gt;&lt;span style="color: blue;"&gt;DECIMAL&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;18&lt;span style="color: grey;"&gt;,&lt;/span&gt;2&lt;span style="color: grey;"&gt;),&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-tab-count: 1;"&gt;            &lt;/span&gt;&lt;span style="mso-spacerun: yes;"&gt; &lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;Age&lt;span style="mso-tab-count: 2;"&gt;                &lt;/span&gt;&lt;span style="mso-spacerun: yes;"&gt;   &lt;/span&gt;&lt;span style="color: blue;"&gt;INT&lt;/span&gt;&lt;span style="mso-tab-count: 1;"&gt;   &lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;)&lt;/span&gt;&lt;br&gt;
&lt;/div&gt;&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/sql-server-how-to-check-whether-column.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Check and display warning message if caps lock key is on using javascript</title><link>http://www.webcodeexpert.com/2020/04/check-and-display-warning-message-if.html</link><category>Check Caps Lock key On</category><category>JavaScript</category><category>Jquery</category><category>jQuery Tips &amp; Tricks</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Fri, 3 Apr 2020 21:00:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-5888904689373502144</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-size: x-large;"&gt;: &lt;/span&gt;In &lt;span style="background: white; mso-highlight: white;"&gt;this
article I am going to explain how to check and display warning message&lt;/span&gt; if caps
lock key of the keyboard is on using javascript/jquery. &lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9euoScy7iywyabXM_r5beqpXl_hIFb1zGBkU75sz9yMVvxSJsnc2t582WdU07J5RGQjc1p0QURCGPLd229lVpcqbzfxCvdxIzg0p9KaqYRS7dH8AklWrvhvLwljsSwvkfCwHo8bqR3YE/s1600/Jvascript+to+check+caps+lock+is+on+or+not.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img alt="Javascript to check and display message if caps lock key is on" border="0" data-original-height="98" data-original-width="266" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9euoScy7iywyabXM_r5beqpXl_hIFb1zGBkU75sz9yMVvxSJsnc2t582WdU07J5RGQjc1p0QURCGPLd229lVpcqbzfxCvdxIzg0p9KaqYRS7dH8AklWrvhvLwljsSwvkfCwHo8bqR3YE/s1600/Jvascript+to+check+caps+lock+is+on+or+not.gif" title="Javascript to check and display message if caps lock key is on"&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt; line-height: 115%;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/12/jquery-to-count-and-limit-words-in.html" target="_blank"&gt;How &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/12/jquery-to-count-and-limit-words-in.html" target="_blank"&gt;to count and limit number of words in asp.net textbox or html textarea using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/jquery-to-hide-first-last-or-nth-column.html" target="_blank"&gt;Hide first / last or nth column of table before printing using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/10/highlight-aspnet-or-html-textbox-on.html" target="_blank"&gt;Highlight asp.net or html textbox on mouse hover using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/10/jquery-to-show-hide-password-characters.html" target="_blank"&gt;Jquery to show hide password characters in asp.net textbox on checkbox check uncheck&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/07/jquery-to-replace-all-spaces-with.html" target="_blank"&gt;Jquery to replace all spaces with underscores while typing in textbox&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-size: x-large;"&gt;:&lt;/span&gt; While taking input from user we may
require to detect whether user has enabled caps lock or not. E.g. in password
field we must notify user whether his caps lock key is on or not because in
password field user cannot see what he is typing. He may enter password in
capital letter unintentionally. &lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/check-and-display-warning-message-if.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9euoScy7iywyabXM_r5beqpXl_hIFb1zGBkU75sz9yMVvxSJsnc2t582WdU07J5RGQjc1p0QURCGPLd229lVpcqbzfxCvdxIzg0p9KaqYRS7dH8AklWrvhvLwljsSwvkfCwHo8bqR3YE/s72-c/Jvascript+to+check+caps+lock+is+on+or+not.gif" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Sql Server: Case statement to Sort records by different columns of different data types</title><link>http://www.webcodeexpert.com/2020/04/sql-server-case-statement-to-sort.html</link><category>CASE Expression</category><category>CASE Statement</category><category>ORDER BY Clause</category><category>SORT Records</category><category>Sort table data</category><category>Sql Server</category><category>Sql tips and tricks</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Thu, 2 Apr 2020 21:40:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-5737824364221857037</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-size: x-large;"&gt;: &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;Here in this article I am going to explain how to use
CASE statement in Order by clause to sort records with different columns of
different data types based on condition.&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;As we know we can use CASE statement in order by
clause to sort data based on condition.But &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 16px;"&gt;CASE expression can only have one data type, then how to sort with different columns of different data types? Here i have explained the solution. &lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 16px;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 16px;"&gt;In previous articles i have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-using-case-expression-in.html" target="_blank"&gt;How to use &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-using-case-expression-in.html" target="_blank"&gt;case expression in order by clause to sort records&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 16px;"&gt; and &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/01/sql-server-using-case-statement-inside.html" target="_blank"&gt;How to &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/01/sql-server-using-case-statement-inside.html" target="_blank"&gt;CASE statement inside in clause (alternative)&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/02/sql-rownumber-rank-denserank-ntile.html" target="_blank"&gt;ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE() RANKING functions in SQL&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/12/sqlbulkcopy-to-insert-multiple-records.html" target="_blank"&gt;SQLBULKCOPY to bulk insert multiple records from gridview to sql database in asp.net c#,vb&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/03/sql-server-update-existing-column.html" target="_blank"&gt;Update existing column values with linear serial numbers without loop&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Implementation:&lt;/span&gt; Let&amp;#39;s understand this by suitable
example.&lt;/span&gt;&lt;br&gt;
&lt;/div&gt;&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/sql-server-case-statement-to-sort.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>SQL Server: Count employees based on their months/days of experience | Get Experience wise employee summary.</title><link>http://www.webcodeexpert.com/2020/04/sql-server-count-employees-based-on_2.html</link><category>Common Table Expression (CTE)</category><category>Experience wise employee summary</category><category>Sql Server</category><category>Sql tips and tricks</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Thu, 2 Apr 2020 21:35:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-306304905846430330</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="background-color: white; color: #0b5394; font-size: x-large;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif;"&gt;Introduction&lt;/span&gt;: &lt;/span&gt;&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In
this article I am going to share how to count employees based on their months
or days of experience or we can say query to get experience wise employee
summary or we can say grouping staff by their months or days of experience. &lt;/span&gt;&lt;br&gt;
&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles i have explained &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-count-employees-based-on.html" target="_blank"&gt;How to count employees based on their years of experience&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/11/how-to-remove-duplicate-recordsdata.html" target="_blank"&gt;How to &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2013/11/how-to-remove-duplicate-recordsdata.html" target="_blank"&gt;remove duplicate records/data from sql table&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="http://www.webcodeexpert.com/2016/10/delete-records-from-table-using-inner.html" target="_blank"&gt;Delete records from table using inner join in sql server&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/02/difference-between-temporary-table-and.html" target="_blank"&gt;Difference between temporary table and table variable in sql&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/09/how-to-pass-table-name-as-parameter-to.html" target="_blank"&gt;How to pass table name as parameter to stored procedure or query&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="background: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;span style="background: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;&lt;span style="color: #0b5394; font-size: x-large;"&gt;Implementation:&lt;/span&gt;&lt;/span&gt;&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 16px;"&gt; &lt;/span&gt;&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 16px;"&gt;Let’s demonstrate by an example.&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0in 0.5in; text-indent: -0.5in;"&gt;
&lt;span style="background: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif;"&gt;&lt;span style="color: #0b5394; font-size: large;"&gt;Create a temporary table for holding employee data using following script.&lt;/span&gt;&lt;span style="color: #444444; font-size: 12pt;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;IF&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt; &lt;span style="color: magenta;"&gt;OBJECT_ID&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;&lt;span style="color: red;"&gt;&amp;#39;tempdb..#tbEmployee&amp;#39;&lt;/span&gt;&lt;span style="color: grey;"&gt;)&lt;/span&gt; &lt;span style="color: grey;"&gt;IS&lt;/span&gt; &lt;span style="color: grey;"&gt;NOT&lt;/span&gt; &lt;span style="color: grey;"&gt;NULL&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;DROP&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt; &lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; #tbEmployee&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;GO&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;CREATE&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt; &lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; #tbEmployee&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;(&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0in 0.5in;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;EmployeeId&lt;span style="mso-tab-count: 1;"&gt;    &lt;/span&gt;&lt;span style="mso-tab-count: 1;"&gt;            &lt;/span&gt;&lt;span style="color: blue;"&gt;INT&lt;/span&gt; &lt;span style="color: blue;"&gt;IDENTITY&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;1&lt;span style="color: grey;"&gt;,&lt;/span&gt;1&lt;span style="color: grey;"&gt;)&lt;/span&gt; &lt;span style="color: grey;"&gt;NOT&lt;/span&gt; &lt;span style="color: grey;"&gt;NULL&lt;/span&gt; &lt;span style="color: blue;"&gt;PRIMARY&lt;/span&gt; &lt;span style="color: blue;"&gt;KEY&lt;/span&gt; &lt;span style="color: grey;"&gt;,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0in 0.5in;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;EmployeeName&lt;span style="mso-tab-count: 1;"&gt;         &lt;/span&gt;&lt;span style="color: blue;"&gt;VARCHAR&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;100&lt;span style="color: grey;"&gt;),&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0in 0.5in;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;DateOfJoining&lt;span style="mso-tab-count: 1;"&gt;           &lt;/span&gt;&lt;span style="color: blue;"&gt;DATE&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt;"&gt;);&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/sql-server-count-employees-based-on_2.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>SQL Server: Count employees based on their years of experience | Get Experience wise employee summary.</title><link>http://www.webcodeexpert.com/2020/04/sql-server-count-employees-based-on.html</link><category>Common Table Expression (CTE)</category><category>Experience wise employee summary</category><category>Sql Server</category><category>Sql tips and tricks</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Thu, 2 Apr 2020 21:30:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-8247573273116747573</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="background-color: white; color: #0b5394; font-size: x-large;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif;"&gt;Introduction&lt;/span&gt;: &lt;/span&gt;&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In
this article I am going to share how to count employees based on their
years of experience or we can say query to get experience wise employee summary
or we can say grouping staff by their years of experience.&lt;/span&gt;&lt;br&gt;
&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles i have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/05/sql-server-query-to-count-malefemale.html" target="_blank"&gt;How to &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/05/sql-server-query-to-count-malefemale.html" target="_blank"&gt;count male, female and total employees&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/06/sql-query-to-count-department-wise.html" target="_blank"&gt;Query to count department wise male, female and total employees&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/01/sql-server-get-created-or-modified-date.html" target="_blank"&gt;Get created or modified date of tables, stored procedures, views and functions&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/04/sql-query-to-delete-or-select-first-or.html" target="_blank"&gt;Query to delete or select first or last n records from table&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/02/sql-server-query-to-split-string-from.html" target="_blank"&gt;Query to split string from comma and get left and right part&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="background: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="color: #0b5394; font-size: x-large;"&gt;Implementation:&lt;/span&gt; Let’s demonstrate by an example. &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-layout-grid-align: none; text-autospace: none; text-indent: -.5in;"&gt;
&lt;span style="background: white; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif;"&gt;&lt;span style="color: #0b5394; font-size: large;"&gt;Create a temporary
table for holding employee data using following script.&lt;/span&gt;&lt;span style="color: #444444; font-size: 12pt;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;IF&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt; &lt;span style="color: magenta;"&gt;OBJECT_ID&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;&lt;span style="color: red;"&gt;&amp;#39;tempdb..#tbEmployee&amp;#39;&lt;/span&gt;&lt;span style="color: grey;"&gt;)&lt;/span&gt;
&lt;span style="color: grey;"&gt;IS&lt;/span&gt; &lt;span style="color: grey;"&gt;NOT&lt;/span&gt; &lt;span style="color: grey;"&gt;NULL&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;DROP&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt; &lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; #tbEmployee &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;GO&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;CREATE&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt; &lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; #tbEmployee&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;(&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;EmployeeId&lt;span style="mso-tab-count: 1;"&gt;    &lt;/span&gt;&lt;span style="mso-tab-count: 1;"&gt;            &lt;/span&gt;&lt;span style="color: blue;"&gt;INT&lt;/span&gt; &lt;span style="color: blue;"&gt;IDENTITY&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;1&lt;span style="color: grey;"&gt;,&lt;/span&gt;1&lt;span style="color: grey;"&gt;)&lt;/span&gt; &lt;span style="color: grey;"&gt;NOT&lt;/span&gt; &lt;span style="color: grey;"&gt;NULL&lt;/span&gt; &lt;span style="color: blue;"&gt;PRIMARY&lt;/span&gt; &lt;span style="color: blue;"&gt;KEY&lt;/span&gt; &lt;span style="color: grey;"&gt;,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;EmployeeName&lt;span style="mso-tab-count: 1;"&gt;         &lt;/span&gt;&lt;span style="color: blue;"&gt;VARCHAR&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;100&lt;span style="color: grey;"&gt;),&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;DateOfJoining&lt;span style="mso-tab-count: 1;"&gt;           &lt;/span&gt;&lt;span style="color: blue;"&gt;DATE&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;);&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/sql-server-count-employees-based-on.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>jQuery to hide first / last or nth column of table before printing</title><link>http://www.webcodeexpert.com/2020/04/jquery-to-hide-first-last-or-nth-column.html</link><category>first-child selector</category><category>Hide First or Last or nth Column using jQuery</category><category>Hide Table Column using jQuery</category><category>Hide() Method</category><category>HTML</category><category>JavaScript</category><category>Jquery</category><category>last-child selector</category><category>nth-child selector</category><category>Show() Method</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Thu, 2 Apr 2020 21:25:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-5374956530514518534</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;: &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In this article I am going to explain how to hide first/last or nth column using javascript/jquery i.e. any column we want to hide from table before printing or we can say in print preview mode so that they do not print on page. &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; &lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;In previous articles I have explained &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/css-to-hide-first-last-or-nth-column-of.html" target="_blank"&gt;CSS to hide first / last or nth column of table before printing&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt; and &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/08/check-user-name-or-email-availability.html" target="_blank"&gt;How to &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;a href="https://www.webcodeexpert.com/2016/08/check-user-name-or-email-availability.html" target="_blank"&gt;&lt;u&gt;&lt;/u&gt;&lt;/a&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/08/check-user-name-or-email-availability.html" target="_blank"&gt;Check user name or email availability using asp.net,ajax and jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/04/what-is-difference-between-jquery-and.html" target="_blank"&gt;Difference between jquery and javascript&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/01/check-uncheck-all-checkboxes-in-aspnet.html" target="_blank"&gt;Check uncheck all checkboxes in asp.net gridview using jquery&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/01/jquery-to-validate-file-type-and-size.html" target="_blank"&gt;Jquery to validate file type and size before uploading through asp.net fileupload control&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;br&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description:&lt;/span&gt; Many times we have some additional columns in table e.g. checkbox in front or last column to select specific records or there may be edit or delete buttons in the table to perform edit and delete operations.&lt;span style="mso-spacerun: yes;"&gt; &lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;Whenever we want to print the table data; checkboxes, edit, delete button should not be printed. Is it possible to hide these columns in print mode only without hiding it on page?&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;Yes, it is possible using javascript/jquery or simply
using CSS. Here in this article I am using jquery’s hide() method to hide the
unwanted column in print mode so that they do not print on the page and using
show() method column can be shown again on page. &lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/jquery-to-hide-first-last-or-nth-column.html#more"&gt;Continue reading... »&lt;/a&gt;</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgY2_WHxGNGNiQr8-hgRpGfSadF9l694ci47_tfgkvrWFLrmuXz18BX2DK7wZ9VzKSXxZcsK7ZAyRfE2V-7XKCMLcwK4UuMfhn-56-Y_GPa7vPFsirM28TR9r3zGF3uJushJnQhFjKF_dY/s72-c/Hide+column+using+CSS.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Sql Server: Using case expression in order by clause to sort records</title><link>http://www.webcodeexpert.com/2020/04/sql-server-using-case-expression-in.html</link><category>CASE Expression</category><category>CASE Statement</category><category>ORDER BY Clause</category><category>SORT Records</category><category>Sql Server</category><category>Sql tips and tricks</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Thu, 2 Apr 2020 21:20:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-2267614922621943003</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Introduction&lt;/span&gt;&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;: &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;Here in this article I am going to explain how to use
CASE statement in Order by clause to sort records as per requirement. &lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-case-statement-to-sort.html" target="_blank"&gt;How to use &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2020/04/sql-server-case-statement-to-sort.html" target="_blank"&gt;Case statement to sort records by different columns of different data types&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; and  &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/01/sql-server-using-case-statement-inside.html" target="_blank"&gt;How to u&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/01/sql-server-using-case-statement-inside.html" target="_blank"&gt;se case statement inside in clause (alternative)&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;a href="https://www.webcodeexpert.com/2016/10/update-using-inner-join-in-sql-server.html" target="_blank"&gt;Update table data using inner join in sql server&lt;/a&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/03/examples-to-use-case-expression-in_12.html" target="_blank"&gt;Using case expression in select statement in sql &lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/09/sql-statement-equivalent-to.html" target="_blank"&gt;Sql statement equivalent to ternary/conditional operator&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2015/04/try-catch-to-handle-exception-and.html" target="_blank"&gt;Try catch to handle exception and commit/rollback transaction in sql&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="background-color: white; color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Implementation:&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt; Let&amp;#39;s understand this by suitable
example.&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;Create a temporary table using following script.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt;IF&lt;/span&gt;&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt; &lt;span style="color: magenta;"&gt;OBJECT_ID&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;&lt;span style="color: red;"&gt;&amp;#39;tempdb.dbo.#tbStudent&amp;#39;&lt;/span&gt;&lt;span style="color: grey;"&gt;,&lt;/span&gt; &lt;span style="color: red;"&gt;&amp;#39;U&amp;#39;&lt;/span&gt;&lt;span style="color: grey;"&gt;)&lt;/span&gt; &lt;span style="color: grey;"&gt;IS&lt;/span&gt; &lt;span style="color: grey;"&gt;NOT&lt;/span&gt; &lt;span style="color: grey;"&gt;NULL&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;/span&gt;&lt;br&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;"&gt;
&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt;  &lt;span style="color: blue;"&gt;DROP&lt;/span&gt; &lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; #&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot;, sans-serif; font-size: 16px;"&gt;tbStudent&lt;/span&gt;&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt;&lt;span style="color: grey;"&gt;;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt;"&gt;
&lt;span style="font-family: &amp;quot;Segoe UI&amp;quot;, sans-serif; font-size: 12pt;"&gt;&lt;span style="color: grey;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;GO&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: blue; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;CREATE&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt; &lt;span style="color: blue;"&gt;TABLE&lt;/span&gt; #tbStudent&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;(&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;  &lt;/span&gt;StudentId&lt;span style="mso-tab-count: 1;"&gt;     &lt;/span&gt;&lt;span style="mso-tab-count: 1;"&gt;            &lt;/span&gt;&lt;span style="color: blue;"&gt;INT&lt;/span&gt; &lt;span style="color: blue;"&gt;IDENTITY&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;1&lt;span style="color: grey;"&gt;,&lt;/span&gt;1&lt;span style="color: grey;"&gt;)&lt;/span&gt; &lt;span style="color: grey;"&gt;NOT&lt;/span&gt; &lt;span style="color: grey;"&gt;NULL&lt;/span&gt; &lt;span style="color: blue;"&gt;PRIMARY&lt;/span&gt; &lt;span style="color: blue;"&gt;KEY&lt;/span&gt;&lt;span style="color: grey;"&gt;,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;  &lt;/span&gt;StudentName&lt;span style="mso-tab-count: 1;"&gt;          &lt;/span&gt;&lt;span style="color: blue;"&gt;VARCHAR&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;100&lt;span style="color: grey;"&gt;),&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;&lt;span style="mso-spacerun: yes;"&gt;  &lt;/span&gt;Gender&lt;span style="mso-tab-count: 1;"&gt;         &lt;/span&gt;&lt;span style="mso-tab-count: 1;"&gt;            &lt;/span&gt;&lt;span style="color: blue;"&gt;CHAR&lt;/span&gt;&lt;span style="color: grey;"&gt;(&lt;/span&gt;1&lt;span style="color: grey;"&gt;)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;"&gt;
&lt;span style="color: grey; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt;"&gt;)&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/sql-server-using-case-expression-in.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>SQL SERVER: How to add Unique Constraint/Index on a Column that allows Multiple Null values</title><link>http://www.webcodeexpert.com/2020/04/sql-server-how-to-add-unique.html</link><category>Sql Server</category><category>Sql tips and tricks</category><category>Unique Constraint</category><category>UNIQUE NONCLUSTERED INDEX</category><author>noreply@blogger.com (Lalit Raghuvanshi)</author><pubDate>Thu, 2 Apr 2020 21:15:00 +0530</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-2042718971061517382.post-3812293418662251611</guid><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="background-color: white; color: #0b5394; font-size: x-large;"&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif;"&gt;Introduction&lt;/span&gt;: &lt;/span&gt;&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In this article example I am going to share how to add UNIQUE CONSTRAINT/ UNIQUE NONCLUSTERED INDEX on a column that allows Multiple Null values. &lt;/span&gt;&lt;br&gt;
&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;br&gt;&lt;/span&gt;
&lt;span style="background-color: white; color: #444444; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In previous articles I have explained &lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/03/sql-server-find-all-primary-and-foreign.html" target="_blank"&gt;How to &lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/03/sql-server-find-all-primary-and-foreign.html" target="_blank"&gt;Find all primary and foreign key constraints on each or any table in database&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/04/sql-server-without-primary-key-column.html" target="_blank"&gt;Without primary key column update first or last n records in table&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/08/sql-server-query-to-search-any-text-in.html" target="_blank"&gt;Search any text in all stored procedures, views and functions&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2016/09/sql-server-query-to-find-all-foreign_9.html" target="_blank"&gt;Find all foreign keys referring to particular table&lt;/a&gt;&lt;/u&gt; and &lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;&lt;u&gt;&lt;a href="https://www.webcodeexpert.com/2017/07/using-merge-in-sql-server-to-insert.html" target="_blank"&gt;Merge in sql server to insert, update and delete in single statement&lt;/a&gt;&lt;/u&gt;&lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12.0pt; line-height: 115%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="background: white; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 115%;"&gt;&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;&lt;br&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="background: white; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 115%;"&gt;&lt;span style="color: #0b5394; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: x-large;"&gt;Description: &lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;Unique Constraint allows only one NULL value. We
cannot insert multiple NULLs. &lt;/span&gt;&lt;span style="background: white; font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;However, there are situations when we need more than one NULL value in the column but still have to maintain uniqueness, ignoring all those NULL values.&lt;/span&gt;&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt; &lt;/span&gt;&lt;br&gt;
&lt;div class="MsoNormal"&gt;
&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , &amp;quot;sans-serif&amp;quot;; font-size: 12pt; line-height: 18.4px;"&gt;&lt;br&gt;&lt;/span&gt;

&lt;span style="font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 12pt;"&gt;In such cases we can create UNIQUE NONCLUSTERED INDEX with
the NOT NULL filter and can insert multiple NULLs.&lt;/span&gt;&lt;br&gt;
&lt;/div&gt;&lt;/div&gt;&lt;a href="http://www.webcodeexpert.com/2020/04/sql-server-how-to-add-unique.html#more"&gt;Continue reading... »&lt;/a&gt;</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item></channel></rss>