Search In
While working with SQL you always face columns with NULL values. For avoiding that you can put a check on it. NULL value is something that is different from nothing and space
ALTER proc [dbo].[sp_GetMailToEmployee]
(
@EmployeeID int
)
as
begin
While working for an autocomplete funtionality in angularJS encountered a problem where instead of the JSON we need to iterate each element and have to make an Array of string.
For iterating the JSON data(from server side), we used:
$scope.complet
UIApplicationDelegate-> UIApplicationDelegate is a protocol which consists some predefine methods. These methods are called by singleton UIApplication object.
UIApplication Object-> UiApplication Object is the object of UIApplication Class w
Hello Friends,
If you are working on symfony2 and looking to implement insert query please review the below example and make the changes according:
Open your model/repository file
$sql = "insert into tbl_paymentmethod set pm_m_id =:pm_m_id, pm_ve
CakePHP database configuration details are in a file that is located at app/Config/database.php.
This database file user can edit the file in the notepad or sublime and can edit the feilds by which it will be connected to the database.Filling all fie
Hello, I am an Italian developer, I was trying to implement my PayPal's library within my e-commerce App.
I created two test accounts, and it seems to work, but there is a problem.
If during the phase of sending money, I deactivate the Internet
This blog will help you to understand how to add files to your git repository:
Step 1: Move the files into local directory which you want to upload to Github that was created when you cloned the repository.
Step 2: Open and change the current worki
INTERSECT Clause:
It works similar like union clause as it is used to combine two SELECT statements, but it returns tuples only from first SELECT statement which are common to tuples in the second SELECT statement.
Syntax:
SELECT colum
Hello Friends,
Twig is a simple template system used in Symfony and Slim Framework. This is something different to implement your code in HTML file as other frameworks or CMS. If you want to implement conditional statement(if else) in twig template
Except Clause:
It combines two select statements and return tuples from first SELECT statement which are not returned by second SELECT statement. It is used to achieve Distinct and Not In queries operation in a single clause(Except).
Syntax:
