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 »