Question { 11097 }

What is the difference between a Stored procedure and function?

Answer

1.stored proceudures can not return tables whereas
functions can.
2.stored procedures can not used in select statemnet
whereas functions can.

Question { Wipro, 6643 }

about view state and how validation controls will be
executed on client and server

Answer

View state is the object which is used to store the values
of a particular page during postback.It stores the values
in a hidden form field in form of string.And if again page
is loaded then it reloads the values of the controls on
particular page from the viewstate.Validation controls are
execute on clien-side.They contains isValid property which
is used to valid the control.Then it executes on the server.

Question { Syntax Softtech, 4911 }

How do we get only edited/deleted/inserted records from a
Dataset?

Answer

we can identify these records by accessing the readonly
property of datarow in dataset which is "RowSate" Property.
It will return 5 values which are:
Inserted
Modified
deleted
Original
Edited

Question { Syntax Softtech, 4032 }

What is the difference of a LEFT JOIN and an INNER JOIN
statement? What is a Cartesian product? What causes it?

Answer

Left join is used to retrieve the non-matching value from
the left table specified at left in query.And inner join or
equi join is used to retrieve the matching rows
only.Cartesian product is used to retrieve the value as
multiplication of the rows from number of tables specified
in query

Question { 15581 }

What is the Difference between user and server controls?

Answer

The main difference is that a seperate copy is generated of
user controls whereas only single copy of custom control is
shared.

Question { Infinite Computer Solutions, 19298 }

what is the differance between .DLL & .EXE

Answer

No,It is not like that.
The main difference is that .exe files are executed in its
own address space whereas .dll files requires address space
to run