• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Sql
  • php
  • C program
  • Seo

Codelack.com

  • Home
  • C++
  • networking
  • Sql server
    • what is rdbms | one to one | one to many | many to many relation-codlack
    • sql server create table
    • code rules in sql server
  • ASP.NET
    • control state in asp.net
    • cookie in asp.net
    • datalist control in asp .net
    • Using ASP.NET To Send Email
    • application state in asp.net
    • file upload control in asp.net
  • contact us
  • Data structure
    • what is Data structure
    • doubly linked list program in c
    • Array in data structure
    • circular queue in data structure
    • Linear data structure
    • Delete node at any position in singly linked list
    • dequeue in data structure
    • implementation of stack using a Linked list in data structure
    • implementation of stack using array in data structure
    • linked list algorithm
    • linked list in data structure
  • C
    • continue and break in c
    • history of c programming language
    • array program in c
    • c programming practice questions
    • enumeration in c
    • C programs with solutions
    • Characteristic of c
    • print 1 to 100 without using loop in c program
    • two single dimension 2D array in c
  • php
    • php
    • Variables in PHP
    • Scalar data types in php
    • Output function in php
    • how to use php string functions | example of string function
    • point to point configuration
    • error in php
    • Array in  php

C++

Difference between NULL and nullptr in c plus plus

December 11, 2019 by admin

difference between NULL and nullptr in c++ 

NULL

  1. It is not defined by c++.
  2. It is internally mapped to into(zero).

Example

int f1 (char*);

int f1 (int);

char*ptr = NULL; // pointer

if  we have a NULL pointer then function call  int f1 (cptr) would always map to  f1(int) and not to int f1 (char*).

 

nullptr

  1. It has been defined by c++.
  2. nullptr is a legal empty/ null pointer.

Example

int f1 (char*);

int f1 (int);

char*ptr = nullptr; // pointer

if  we have a nullptr pointer then function call  int f1 (cptr)  will map to   int f1 (char*) only.

Filed Under: C++, Uncategorized Tagged With: Difference between NULL and nullptr

SQL join with example

December 9, 2019 by admin Leave a Comment

By using SQL joins , we can retrieve data from  two or more tables based on logical relationships between the tables.

SQL JOINS indicate how database should use data from one table to select the rows in others in another table.

The function of performing data from multiple tables is called joining.

Sql can produce data from several related tables by performing either a physical or virtual join of the tables.

The WHERE clause is most often used to perform the JOIN function where two or more tables have common columns. 

Specifying the column from each table to be used for JOIN.

A typical join condition specifies a foreign key from one table and  its associated key in the other table.

Specifying a logical operator (for example , = or <> ) to be used in comparing values from the columns.

In unrestricted join or Cartesian product of two tables, all possible concatenations are formed of all rows of both the tables. 

When we retrive  the data from more than one table

  1.   ANSI FORMAT JOINS
  2. NON ANSI FORMAT JOINS

ANSI FORMAT JOINS  

–  With “on” key word join condition.

-it is also called new style formant .

Syntax

SELECT */<LIST OF COLUMN NAMES> FROM <FIRST TABLE NAME><JOIN KEY> < SECOND TABLE NAME > ON (JOINING CONDITION)

Type of ANSI FORMAT JOINS

  1. INNER JOIN
  2. OUTER JOIN ( left outer, right outer, full
  3. CROSS JOIN
  4. NATURAL JOIN

NON ANSI FORMAT JOINS 

-Based on “where” key word join condition.

Syntax

SELECT */<LIST OF COLUMN NAMES> FROM <FIRST TABLE NAME><JOIN KEY> < SECOND TABLE NAME > WHERE (JOINING CONDITION)

Type of NON ANSI FORMAT JOINS

  1. Equi-join
  2. Non Equi-join
  3. Self join

Filed Under: C++, Sql, Uncategorized Tagged With: Sql, SQL join

Primary Sidebar

sql

  • introduction of sql
  • database management system
  • hierarchical database management system
  • what is rdbms | one to one | one to many | many to many relation-codlack
  • codd rules in sql server
  • Character Data Type
  • constraint unique
  • sql server create table

data structure

  • Data structure
  • Linear data structure
  • Array in data structure
  • What is a algorithm
  • stacks in data structure
  • queue data structure
  • dequeue in data structure
  • Priority queue
  • circular queue in data structure
  • linked list algorithm
  • Delete node in singly linked list
  • tree in data structure
  • implementation of stack using array in data structure
  • implementation of stack using a Linked list in data structure
  • Doubly Linked List Implementation

C programming

  • history of c programming language
  • C programs with solutions
  • Characteristic
  • constraint unique
  • continue and break
  • doubly linked list program in c
  • dynamic memory allocation
  • enumeration
  • print 1 to 100 without using loop
  • Variable declaration

c++

  • Introduction to C++ | similarities of  C++ structure and  class
  • default argument in c++
  • access specifiers in c++
  • Function In C++
  • friend function in c++
  • constructor in c++
  • destructor in c++ | How to call destructor C++
  • exception handling in c++

Categories

array multiplication (1) asp.net (10) B.ed (1) C# (1) c# (1) C++ (2) C program (3) FormView control (1) php (2) Seo (5) Sql (1) Uncategorized (11)
disclaimer

Copyright © 2022 · codelack.com