Web Code Logics

Improve your skills

July 30, 2016

SQL Server – Insert Data From One Table to Another Table

, No comments
There are two ways to insert data from one table to another table. 1. INSERT INTO SELECT  statement- The INSERT INTO SELECT statement is used to copy data from one table and insert into another table. It is used when the table is already created in the database. If...
Read More

July 27, 2016

Email Validation in Javascript

, , , , No comments
Here I will show you how to validate the Email Id using JavaScript or jquery. First, we take a input text and a input button in body as show in below- HTML: <body> <input id="txtEmail" type="text" placeholder="Email Id" /> <input type="button" value="Check"...
Read More

July 22, 2016

Get Maximum Value of a Column in SQL Server

No comments
The MAX() function is return the maximum value of a column in sql server. Syntax-  SELECT MAX(COLUMN_NAME) FROM TABLE_NAME Example- Let we have a table 'tblStudents' which have the following data as shown below- Now we use MAX() function to get maximum...
Read More

July 14, 2016

Change color image to black and white image on hover using CSS

, No comments
By using grayscale property of css3 we can change the color of image to black and white (100% gray). Grayscale property apply a shade of grey on our images. The value can be either decimal or percentage. 100% or 1.0 will make the image full greyscaled, 0% or 0 will add no...
Read More

July 11, 2016

How to Clear/Remove Recent or Saved Connection Server Name From Drop Down List in SQL Server Management Studio

No comments
Sometimes we want to delete the saved server name from the list. there are two ways to delete the name. 1. Using DELETE key form keyboard- By using this method we can remove the saved server name from the list. First we click on the list.  Hover over the server name you...
Read More

July 08, 2016

jQuery Set Focus to the Next Element After ENTER Key Press

, , No comments
Sometimes we want to set focus to the next element after pressing ENTER key(same as TAB key). Here, I will explain how to set focus to the next element in jquery using focus() method. Note: e.preventDefault(); is used to stop the default behavior. Write below code to your...
Read More

July 02, 2016

Select column values as comma separated or delimited string in SQL Server

No comments
Sometimes we required to generate a comma separated list of columns values like a list of emailIds to send mail. In SQL Server, we can make a comma separated list by using some methods as shown in below- Suppose we have some data in 'tblUsers' table as shown in below- Now,...
Read More
Subscribe to: Posts (Atom)

Subscribe for Latest Update

Popular Posts