What is Triggers in SQL Server?

What is Trigger in SQL Server? A trigger is especial type of Stored Procedure that executes when certain action performed on Table like:- Insert Delete Update It’s a Database Object which is bound to a table and is executed automatically. There are Two type of Trigger:- After Trigger(For Trigger) Instead of Trigger After Trigger are divided into Three type:- For Insert For Delete For Update Instead of Trigger are divided into Three type:- Instead of Insert Instead of Delete Instead of Update ...

Read More

Difference Between LEN and DATALENGTH Functions in SQL Server

Difference Between LEN and DATALENGTH Functions in SQL Server LEN:- It shows actual Length of Declared Variable not as it’s Capacity. Explanation:- Char(50),Here we declare on Char variable with 50 character capacity . But we assigned ‘Rahul’ only 5 character. This Actual Length is called Len of a Variable. DATALENGTH:- But DATALENGTH  shows the capacity of a Variable. Char(50) here 50 is the capacity of char Variabl...

Read More

Diffrence b/w Convert.ToString() and .ToString()

Diffrence b/w Convert.ToString() and .ToString() .ToString()…………. .ToString() does not handle null value. string s = null;         ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "<script> alert('" + s.ToString() + "')</script>", false); It’s Generates Error as Given Below:- NullReferenceException was unhandled by user code Convert.ToString () It’s handle null value. string s = null;         ScriptManager.RegisterClientScriptBlock(this,...

Read More

...

Read More

What is the Execution Flow of a SQL QUERY?

What is the flow of Execution of a SQL QUERY? 1.    FROM clause 2.    WHERE clause 3.    GROUP BY clause 4.    HAVING clause 5.    SELECT clause 6.    ORDER BY clause If we write the sql Query in SQL Editor. The Execution Flow is:                First Execute From Clause                        ...

Read More

How To Convert Text To Voice in WPF

How to  Convert Text To Voice in WPF …. XAML Design Page <Window x:Class ="Wpfwithdatabase.MainWindow"         xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"         xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"         Title="MainWindow"...

Read More