SQL Aliases SQL aliases are actually temporary names given to tables or a column or columns in a table. They do not actually create a new column in the database, but are the temporary readable names given to columns or tables for the time of the execution of the query. So, they only exists for... Continue Reading →
SQL Stored Procedure to select data based on conditions
Solution As we know a simple SQL select statement goes like this: select column_names from table_name Now, If we want to add a condition to selected records based on a single value of a column, we use where clause select column_names from table_name where column_value=value Example USE [DB_Name] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER... Continue Reading →
SQL stored procedure to delete a specific record based on id
Solution USE [DB_Name] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_DeleteMember] @Id as bigint AS BEGIN SET NOCOUNT ON; Delete from Members_Table where ID = @Id END Explanation This delete stored procedure will delete the member from Members_Table whose member id is passed.
Get id of selected dropdown value in jquery
Solution var selectedid=$("#dropdownname").find('option:selected').attr('id'); Explanation This will find the id of selected dropdown option and store it in the variable selectedid.
Javascript function to calculate age from date of birth entered in a text box
Solution function calculateAge() { var dob = $('#DateOfBirth').val(); dob = new Date(dob); var today = new Date(); var age = Math.floor((today - dob) / (365.25 * 24 * 60 * 60 * 1000)); $('#Age').val(age); } Explanation dob will get the date of birth from DateOfBirth text box. It will convert it into date so to... Continue Reading →
Function to allow numbers only using Regex
Regex to allow numbers only Solution In JQuery var checkNumbers = function (textBox) { debugger; var regexp = new RegExp('^[0-9]+$'); var check = textBox.value; if (!regexp.test(check)) { alert('Invalid Value. Please enter numbers only'); $(textBox).css('border-color', 'red'); return false; } else { $(textBox).css('border-color', 'green'); $(textBox).value = check; return true; } } In HTML @Html.TextBox("AddAge", null, new {... Continue Reading →
Function to validate Date of Birth using Regex
Regex to validate date of birth Solution In Jquery var checkDOB = function () { debugger; var regexp = new RegExp( '^(0[1-9]|1[012])[/](0[1-9]|[12][0-9]|3[01])[/](19|20)\\d\\d$'); var check = $("#AddDateOfBirth").val(); if (!regexp.test(check)) { alert('Invalid Format. Please Enter: dd/mm/yyyy'); $('#AddDateOfBirth').css('border-color', 'red'); return false; } else { $('#AddDateOfBirth').css('border-color', 'green'); return true; } } In HTML @Html.TextBox("AddDateOfBirth", null, new { @class =... Continue Reading →
Object Operators in PHP
Answer There are two object operators in PHP. The symbols are -> and :: -> Operator The object operator -> is used when you have to access an Instance property or call a method just like a dot (.) in other languages. For example, if there is a 'Students' class that includes the method 'Marks',... Continue Reading →
What is PSS of a process?
Answer The "proportional set size" or PSS of process is the sum of the unshared memory of a process and the proportion of memory shared with other processes. Formula: unshared memory of a process + (memory shared with other processes /number of processes that share memory) We'll understand through an example Example Process A has... Continue Reading →
Compound/Assignment Operators in Different Languages
NameCompound OperatorsSQLC++JavaPHPJavaScriptPython Add Equals+=+=+=+=+=+=Subtract Equals-=-=-=-+-=-=Multiply Equals *=*=*=*=*=*=Divide Equals /=/=/=/=/=/=Modulo Equals %=%=%=%=%=%=Bitwise AND Equals &=&=&= &= &=Bitwise Exclusive Equals ^-= ^=^=^=^=Bitwise OR Equals |*= |=|=|=|= Compound left-shift <<= <<=<<=<<= Compound right-shift >>=>>=>>=>>= Compound right-shift filled 0 >>>=>>>=Exponentiation assignment**=**=Integer division assignment//=
Bug Fixes & Coding Solutions 