geeksprogrammings

What are CTE in SQL ? CTE are Common Table Expressions first introduced in Sql Server 2005. It is basically a result set or result holde...

What are Table Valued Functions in Sql ? There are two types of “User Defined” fucntions in sql server scalar function ( that retur...

Instead of triggers are used to reverse the default action of the query same as the word ‘insted of’ denotes. For example if we are going ...

If you Mssql Server is Using Some Other Date Format For Insert Date in Date Column Then Possibly Default Date format is set to US Date For...

Stored Procedure and Functions   1. Function Must Return Value    For Stored Procedure it's Not Must to return value it's ...

Stored Procedure Vs Views 1. Stored Procedure are collection of pre-executed sql Statements that accepts parameters as input and depen...