Different Types of SQL Server Functions?
Function is a database object in Sql Server. Basically it is a set of sql statements that accepts only input parameters, perform actions and return the result. Function can return...
MVC Demo
https://onedrive.live.com/?cid=a0e15b608ffbb6e2#cid=A0E15B608FFBB6E2&id=A0E15B608FFBB6E2%21291
Difference Between StringBuilder and String?
String: 1.Its a class used to handle strings.2.Here concatenation is used to combine two strings.3.String object is used to concatenate two strings.4.The first string is combined to the other string...
How to find Last Day of Any Month?
Last Day of Previous MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) Last Day of Current MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)) Last Day of Next MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))
Differentiate between alert(), prompt() and confirmation()?
alert() dialog The alert() dialog box is used to communicate a message to the user (generally warnings of missed actions). For example, if the email address entered is wrong, you...
Difference between a Value Type and a Reference Type?
The Types in .NET Framework are either treated by Value Type or by Reference Type. A Value Type holds the data within its own memory allocation and a Reference Type...
What is boxing and unboxing ?
Boxing Implicit conversion of a value type (int, char etc.) to a reference type (object), is known as Boxing. In boxing process, a value type is being allocated on the...
MVC vs. 3-tier architecture?
At first glance, the three tiers may seem similar to the model-view-controller (MVC) concept; however, topologically they are different. A fundamental rule in a three tier architecture is the client tier...
Difference Between Repeater and DataList and GridView?
Difference between DataList and Repeater DataList Repeater Rendered as Table. Template driven. Automatically generates columns from the data source. This features is not supported. Selection of row is supported. Selection...
SQL Server Stored Procedure?
Defination: -In database management systems (DBMSs), an operation that is stored with the database server. Typically, stored procedures are written in SQL. They're especially important for client-serverdatabase systems because storing the procedure on the...
