Object Oriented Programming Languages & Systems. Everything in the world is an object. The type of the object may vary. In OOPS, we get the power to create objects of our own, as & when required. OOPs is the new concept of programming ,parallel to Procedure oriented programming.It were introduced… Continue reading
Describe the role of inetinfo.exe, aspnet_isapi.dll and aspnet_wp.exe in the page loading process. inetinfo.exe is the Microsoft IIS server running, handling ASP. NET requests among other things. When an ASP. NET request is received (usually a file with .aspx extension), the ISAPI filter aspnet_isapi.dll takes care of it by passing… Continue reading
I have used a lot of free .NET libraries, some from Microsoft itself! Which ones have you found the most useful? Package managers for external libraries NuGet (formerly known as NuPack) – Microsoft (developer-focused package management system for the .NET platform intent on simplifying the process of incorporating third party… Continue reading
When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When SET QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers.
Meta-Lists 25 Free Computer Science Ebooks Book Training – On Video Cheat Sheets (Free) CodePlex List of Free E-Books Free Tech Books Galileo Computing (German) How to Design Programs: An Introduction to Computing and Programming Microsoft Press: Free E-Books MindView Inc O’Reilly’s Open Books Project Sofware Program Managers Network TechBooksForFree.com… Continue reading
There are many ways to find out of this result, here we mentioned 2 best methods among them. First of all you run this query for fetching all table names and using these table names you can make a query for fetching all rows count of a particular database. use… Continue reading
They specify a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically… Continue reading
Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command. TRUNCATE TRUNCATE is faster and uses… Continue reading
Boxing is implicit conversion of ValueTypes to Reference Types (Object). Boxing a value type packages it inside an instance of the Object reference type. This allows the value type to be stored on the garbage collected heap. Boxing is conversion from value type to object(reference) type. Actually the copy of… Continue reading
Log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server. Enterprise Editions only supports log shipping. In log shipping the transactional log file from one server is automatically updated into the backup… Continue reading