How many type of function in javascript

Today, Will discuss How many type of functions is available in javascript.

So There are 3 type of functions is available in javascript

• Named Function
• Anonymous Function
• Immediately Invoked function expression.

A function which has a name at the time of definition called Named function 

Syntax:

                  function function_Name(param1, param2){

                    function body

                 }

 function_Name();

Such function which don't have name are called Anonymous Function These functions are declared dynamically at runtime using the function operator instead of the function declaration. The function operator is more flexible than a function declaration and to invoked these function we assigned it to a variable.

Syntax:

            var fun = function(param) {

            do something here (Body of the function)

            }

    fun(param);

Let's understand with an example.

<script type ="text/javascript">

        var anonymousFun = function(param1, param2) {

           alert(param1 + " Good morning " + param2);

            }

        anonymousFun("Hello", "anonymous function");

    </script>

Add the above code to a web page an run the application then output would be :

Hello Good morning anonymous function

Invoked function expression are those function which runs as soon as the browser encounters it. The main benefit of function is that it runs immediately where it’s located in the code and produces a direct output. That means it is unaffected by code which appears further down in the script which can be useful.

<script type ="text/javascript">

        var msg = (function(){

            var name= "Dal Chand";

            return name;

        })();

    </script>

Outpou: Dal Chand

Explain the named function in javascript with example

 We are going to learn here about named function in javascript. Let's understand first what is named function.

Named Function: A function which is define with a name at the time of definition is called named function

Syntax: 

            function function_Name(param1, param2){

                    function body

               }

        function_Name();

Example: function Hi(name){

        alert("Hello "+name);

}

Hi("Dev");

Output: Hello Dev

How to install Sql server

We'll learn here  how to install sql server in system. Please follow below step to install sql server 2008 in your system.

Let me know if anyone is facing any issue while installing sql server.

Arithmetic overflow error converting numeric to data type numeric

 Arithmetic OverFlow:  It occur when  we try to insert a value in a column or assign a value to a variable  which is more than the limit of data type.

Let' say we have a variable of numeric type with size

            Declare @IsArithmeticOverFlow numeric(5,2)

            SET @IsArithmeticOverFlow  = 999.999

            SELECT @IsArithmeticOverFlow 

will get the airthmetic error  error here while executing the above statement because we defined the size of variable (5,2) and IsArithmeticOverFlow  vaiable have the capacity to hold the value upto only 999, not more than it. but the value 999.999 is rounding to nearest vale. so, after rounding, the nearest vale is 1000. and the variable don't have the capacity now to hold 1000. so in this situation, will get arithmetic overflow error

Now let's fix this issue. I am just increasing the size of variable from (5,2) to (6,2)

Declare @IsArithmeticOverFlow numeric(6,2)

            SET @IsArithmeticOverFlow  = 999.999

            SELECT @IsArithmeticOverFlow 

Let's run it and see the output.

Now you can see the above screenshot, no error after increasing the size of variable.

Let say if someone is using more than one nested procedure inside a procedure and getting arithmetic overflow issue then use the try catch to identify the eject place where it is occurring.

We'll discuss in details about try catch in our next post.

What is Javascript

 JavaScript: JavaScript is an object-oriented programming language It was introduced in 1995 for adding programs to the web pages in the Netscape Navigator browser. Since then, it has been adopted by all other graphical web browsers. it is lightweight,cross-platform ,interpreted and full-fledged programming language. it is used by lot's of websites for scripting the web pages.

Using JavaScript, developers can develop modern web applications to interact directly without reloading the page every time. it also improve the performance of the application because mostly validation part done only at client side.

Benefit of JavaScript: There are lot's of benefit of  javascript

1-JavaScript is lightweight,cross-platform and interpreted  programming language

2-Validation can be done on client side due to that it's avoid the unnecessary round trip between client side and server side.

3-it also provide the facility to update the  partially page rendering without reloading the entire web page.

How to truncate data from table in sql server

We'll learn here How to truncate data from database table.

So I have already created a employee table in test database  and inserted 5 records in Employee table

Let's select data from table with the help of below query.

So we have the 5 records in table. To truncate the data from the table we have the TRUNCATE command  let's truncate this data from the table with the help of below query.

Syntax: TRUNCATE TABLE <TABLENAME>

Execute below command to truncate the data

TRUNCATE TABLE  Employee

output:

Let's  check whether data is truncated or not from the table with the help of Select statement.

So using the TRUNCATE command we can delete the entire data from the table. it does not allow   WHERE Clause.

How to delete duplicate data from physical table in sql server

We'll learn here How to delete duplicate data from physical database table.

Step1: let's create the table and insert the data into table.

CREATE TABLE [dbo].[Employee](

[Id] [int],

[Name] [nvarchar](50) NULL,

[Gender] [nvarchar](10) NULL,

[Salary] [int] NULL,

)

GO

Step2: Insert multiple record into employee table.

INSERT INTO Employee(Id,Name,Gender,Salary)

VALUES(1,'Amit','Male',5000),

(2,'Fernando','Male',20000),

(2,'Fernando','Male',20000),

(3,'Rahul','Male',10000),

(1,'Amit','Male',5000),

(4,'Atom','Male',7000),

(5,'SpTan','Female',5000)

Step3: check the data prior to delete operation with the help of below query.

Select * from Employee;

Output:

Step4: Let's delete data from table using CTE table.

WITH DeleteDuplicateRecord AS (

    SELECT 

        ID,  NAME, GENDER, SALARY, ROW_NUMBER()OVER

        (PARTITION BY ID, NAME,GENDER,SALARY ORDER BY ID,NAME,GENDER,SALARY

        ) DuplicateRecord

     FROM  Employee)

DELETE FROM DeleteDuplicateRecord

WHERE DuplicateRecord > 1

Step5: check data after execute the delete operation.

Select * from Employee

How to find duplicate record in sql server

We'll learn here how to find the duplicate record in a sql server database table.

Step1: Let's create the table.

CREATE TABLE [dbo].[Employee](

[Id] [int],

[Name] [nvarchar](50) NULL,

[Gender] [nvarchar](10) NULL,

[Salary] [int] NULL,

)

GO

Step 2: Insert the data into table

INSERT INTO Employee(Id,Name,Gender,Salary)VALUES(1,'Amit','Male',5000),

(2,'Rahul','Male',10000),

(1,'Amit','Male',5000),

(3,'Fernando','Male',20000),

(3,'Fernando','Male',20000),

(4,'Kimboon','Male',7000),

(5,'Kristen','Female',5000)

Step 3: Check the data in table with the help of below query.

SELECT* FROM Employee

Step 4: So with the help of below query we can  get the duplicate data from Employee table.

SELECT *,COUNT(*)Duplicate FROM Employee

group by ID,name,gender,salary

Having COUNT(*)>1

or

WITH duplicatedata AS (

    SELECT 

        *,

        ROW_NUMBER() OVER (

            PARTITION BY id

            ORDER BY id) duplicate

    FROM 

        Employee

) 

SELECT * FROM duplicatedata 

WHERE duplicate > 1;

Output:

So now we have the duplicate data.

Sql Server System define function

System function are those functions which is pre-defined and  perform operations and return information about database objects in SQL Server

below are some system function

Count, Avg,Min, Max etc.

What would be the output of below queries.

SELECT 'A'+'B'

Output : AB

SELECT 'A'+1

Output :Conversion failed when converting the varchar value 'A' to data type int.

SELECT '1'+'A'

Output : 1A

SELECT 16

Output : 16

SELECT $

Output :0.00

SELECT COUNT(*)

output : 1

SELECT COUNT('8')

output: 1

SELECT (SELECT 'DAL CHAND')

output : DAL CHAND

SELECT SELECT 'DAL CHAND'

output: Incorrect syntax near the keyword 'SELECT'.

SELECT * FROM 'Employees'

output: Incorrect syntax near 'Employees'.

SELECT COUNT(*) + COUNT(*)

output: 2

SELECT 'DAL CHAND' FROM Employees

output: it will print the DAL CHAND total number of rows times.

so here we have 2 records in employees table so name will print 2 times

DAL CHAND

DAL CHAND

SELECT SUM(1+4*3)

output: 13

SELECT MAX(1,3,4)

output: The MAX function requires 1 argument(s).

SELECT MAX('DAL CHAND')

output: DAL CHAND

Select Count(SELECT id FROM Employees)

output:Incorrect syntax near the keyword 'SELECT'.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near ')'.

SELECT 1 + '1'

output: 2

SELECT '1' + 1 

output: 2

SELECT NULL + 5

output: NULL

SELECT NULL + '1'

output: NULL

SELECT 1 WHERE NULL = NULL

output: (0 row(s) affected)

SELECT SUM('1')

output: Operand data type varchar is invalid for sum operator.

SELECT SUM(NULL)

output: Operand data type void type is invalid for sum operator.

SELECT 6/0

output:Divide by zero error encountered.

SELECT 0/0

output:Divide by zero error encountered.

SELECT 0/9

output:0

How to improve the performance of stored procedure

To improve the performance of stored procedure we have to keep few things in mind.

1- Always  use SET NOCOUNT ON it can improve performance because network traffic can be reduced because the message that indicates the number of rows that are affected by the T-SQL statement is not returned as part of the results. When you use SET NOCOUNT OFF; the count is returned.

2- Avoid to use wild card(*) we should avoid to SELECT * or all the column of table with select statement. we can use the column name which is required.

Example: Select * from employee  (need to avoid) we can use like Select column name from  employee.

3-Use IF EXISTS or SELECT 1 to check the value or record in table.

4- USE with (nolock) keyword while selection data from table.

example: SELECT * FROM Employees WITH(NOLOCK)

5- Avoid to use cursor if possible.

6-Use indexing on table column.

7-Use fully qualified procedure name like  database.schema.objectname

8-Avoid to set the procedure name prefix with sp_ keyword.

What is latest version of c#?

 C# is a object oriented programming language which is developed by Microsoft in 2001 and the latest  version of c# is 10.0, which was released in 2021 in . NET 6.0.

Inspirational thought