Introduction:
Here I will explain how to use sql
server
to show exact match values at the top and then partial match values with
example or sql
server
show exact match values at first and then show partial match / like values next
with example. By using Order By property we can
show exact match values first and then remaining values in sql
server.
Description:
Introduction:
Here
I will explain what is charindex function in SQL Server and uses of charindex function in SQL Server.
Generally charindex function in SQL Server is used to search for specific word or substring in overall string and returns starting position of match. Generally we will use charindex in SQL Server to check if string contains specific word or not.
Introduction:
Here I will explain how to get string before and after character in sql
server
with example or sql
server
get string before or after character / delimiter example. By using CHARINDEX and SUBSTRING properties we
can get string before or after character in sql
server.
Description:
Introduction:
Here I will explain how to use jQuery
to hide div when user clicks outside of it example or Hide/Close div when clicked
outside of it using
jQuery
or hide element if click anywhere else using jQuery with example.
If
you want to close or hide div when click outside of it in jQuery we need to write the code
like as shown below
Introduction:
Here I will explain how to split string with comma delimited character in SQL
Server or split string with comma separated delimiter in SQL
Server or split string with special character in SQL Server or split and convert comma separated or delimited string to table in SQL Server.
Description:
Introduction:
Description:
In previous articles I explained Bootstrap dropdownlist with checkboxes in jQuery, Bootstrap set particular tab opened in jQuery, jQuery
autocomplete textbox with multiple words in asp.net, jQuery
autocomplete with images in asp.net, jQuery
slideup, slidedown, slidetoggle effects example and many
articles relating to autocomplete, bootstrap, css, AngularJS, jQuery, JavaScript
and asp.net. Now I will
explain how to implement bootstrap autocomplete textbox without typeheadjs in asp.net using c#,
vb.net
with example.
Introduction:
Description:
In previous articles I explained Bootstrap dropdownlist with checkboxes in jQuery, Bootstrap set particular tab opened in jQuery, jQuery
autocomplete textbox with multiple words in asp.net, jQuery
autocomplete with images in asp.net, jQuery
slideup, slidedown, slidetoggle effects example and many
articles relating to autocomplete, bootstrap, css, AngularJS, jQuery, JavaScript
and asp.net. Now I will
explain how to implement bootstrap autocomplete textbox without typeheadjs in asp.net using c#,
vb.net
with example.
Introduction:
Here I will explain how to use jQuery to get selected bootstrap tab on click or jQuery set or get bootstrap
selected tab value on change event with example. By using data-toggle property we can get selected bootstrap tab value in jQuery on tab change.
Introduction:
Here I will explain how to solve
the problem of “There
was a problem acquiring a personal certificate required to sign in, If the
problem continues, please contact your support team.” while login in to Lync communicator in windows 8.
Actually this problem occurs when our cached credentials of Lync get corrupted.
To fix this problem we need to delete existing certificates and login with your
details it will fix your “Cannot sign into Lync. There was a problem acquiring a certificate
from the server.”
Description:
Introduction:
Here I will explain how to use AngularJS to enable or disable
button based on checkbox value selection with example. By using “ng-disabled” property we can enable or
disable button on checkbox selection value in AngularJS.