C# Interview Question OOPS - Top 50

1.       What is OOPS? OOPS is abbreviated as Object Oriented Programming system in which programs are considered as a collection of objects. Each object is nothing but an instance of a class. 2.       Write basic concepts of OOPS? Following are the concepts of OOPS and are as follows:. Abstraction. Encapsulation. Inheritance. Polymorphism. 3.       What is a class? A class...

Read More »

Part-2 SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database Sending Mail in HTML Format

Part-2 SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database Sending Mail in HTML Format I am just providing the steps that are enough to give you the basic undrstanding to create HTML Format -- Creating HTML Format Using Stored Procedures for sending email from database the following Stored Procedures Required -- 1) Create DataSourceCheck stored procedures CREATE PROCEDURE [dbo].[DataSourceCheck] @dataSource varchar (100) = NULL, @db varchar(50) = NULL...

Read More »

SQL SERVER 2008 Configure Database Mail – Send Email From SQL Database Using sp_send_dbmail

SQL SERVER 2008 Configure Database Mail – Send Email From SQL Database In order to send mail using Database Mail in SQL Server, there are 3 basic steps that need to be carried out: Create Profile and Account Configure Email Send Email I am just providing the steps that are enough to give you the basic undrstanding to send a mail from the database to your mail hosting server. Here for example i am using the Gmail SMTP server details to send a test e-mail. -- 1) First Enable...

Read More »

SQL Server Generate Week Dates for a Year and Month in SQL Server

SQL Server Generate Week Start Dates End Dates for a Year or Month in SQL Server Sometimes, you might require Start & End dates for all the weeks in a given year or month to generate week-wise report starting from Monday to Sunday I have developed a Table-Valued function where you have to pass year and it would return a table with all the weeks and its Start & End Dates for a given year. Getting Month Week Start Date and End Date - - Totals by Week  CREATE FUNCTION...

Read More »

Generate Week Dates for a Month in SQL Server - IT Developer Zone

Generate Week Dates for a Month in SQL Server - IT Developer Z...

Read More »

Interview Questions ASP.NET VIEW STATE

1). What is View State in Asp.net? Ans: View state is nothing but a method that the ASP.NET use to preserve page and control values between postbacks. When the HTML markup for the page is rendered, the current state of the page and values that must be retained during postback are serialized into base64-encoded strings. This information is then put into the view state hidden field. 2). View state is client-side or server side state management techenique? Ans: View state is client-side...

Read More »

Interview Questions ASP.NET State Management Techniques

Here are the top 10 questions answers for both experienced and beginners asp.net developers. 1).What is state management? Ans: State management is the process by which you maintain state and page information over multiple requests for the same or different pages. 2).Http is stateless, What does this mean? Ans: Stateless protocol is a communications protocol that treats each request as an independent transaction that is unrelated to any previous request so that the communication consists...

Read More »

SQL Server interview questions | triggers all about triggers

Explain Triggers? A trigger is a special type of event driven stored procedure.  It gets initiated when Insert, Delete or Update event occurs.  It can be used to maintain referential integrity.  A trigger can call stored procedure. Executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table. You can specify which trigger fires first or fires last using sp_settriggerorder. Triggers can't be invoked on demand. They get triggered...

Read More »

SQL Server interview questions | data integrity constraints

SQL Server interview questions | data integrity constraints What is primary key? A Primary Key in a table identifies each and every row uniquely. It should not allow null values. We could assign primary key on only column or more than one column also. What is the difference between primary key and unique key? Primary should not allow null; where as unique key will allow nulls. By default Primary key is created as clustered...

Read More »

SQL Integrity Constraints Foreign Key Not Null Unique Check

SQL Integrity Constraints Integrity Constraints are used to apply business rules for the database tables. Enforcing data integrity ensures the quality of the data in the database.  For example, if an employee is entered with an employee_id value of 123, the database should not allow another employee to have an ID with the same value. Data integrity falls into these categories: Entity Integrity Entity integrity defines a row as a unique entity for a particular table....

Read More »