What is View State? View State allows the state of objects (serializable) to be stored in a hidden field on the page. View State is transported to the client and back to the server, and is not stored on the server or any other external source. View State is used the retain the state of server-side objects between postabacks. What is the lifespan for items stored in View State? Item stored in View State exist for the life of the current page. This includes post backs (to the same page). What does the “EnableViewState” property do? Why would I want … Click here to continue reading.
Cross Join: A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table. The common example is when company wants to combine each product with a pricing table to analyze each product at each price. Inner Join: A join that displays only the rows that have a match in both joined tables is known as inner Join. This is the default type of … Click here to continue reading.
A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement. A global temporary table remains in the database permanently, but the rows exist only within a given connection. When connection is closed, the data in the global temporary table disappears. However, the table definition remains with the database for access when database is opened next time.
Yes, SQL Server can be linked to any server provided it has OLE-DB provider from Microsoft to allow a link. E.g. Oracle has an OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL Server group.
CLR (Common Language Runtime) CLS (Common Language Specification) CTS (Common Type Systems) A CLR is a construct provide by the .NET framework that provides several functionalities to all .NET applications like memory management, security, Garbage collection, language independency, cross language exception handling, cross language inheritance, etc. CTS consist of all the types supported by .NET like bool, struct, enum etc; and thus keep the .net applications type safe. CLR manages the execution of code and provides different services for Base Class Libraries etc. CLR is a rich set of features for cross-language development and deployment. CLR supports both Object Oriented … Click here to continue reading.