Displaying Festival Names on Calendar control in ASP.Net

Tags : Festival Names,Calendar Control,Importance of the day,Asp.Net,C#.Net,SQL Server. Hi Friends,In this article i would like to explain how to display Festival Names on Calender control in ASP.Net.* For this i took 1 Calendar control on to the page.* I created a table with name(Holidays) in SQL Server 2005 & fields are HolidayName,HolidayDate. * Please find the below table once :* Then...

Readmore...

Logical Operators in SQL Server.

Tags : Logical Operators,Sql Server 2005,Sql Server 2008,Sql Server Operators.Hi Friends,In this article i would like to explain Logical Operators in SQL Server.* Logical operators, like comparison operators, return a Boolean data type with a value of TRUE, FALSE, or UNKNOWN.* Available Logical Operators :1) AND: Performs a logical AND operation. The expression evaluates to TRUE if all conditions are TRUE.Example :SELECT * FROM ClassWHERE ( Marks > 40 AND Marks < 100)2) OR :Performs a logical OR operation. The expression evaluates to TRUE...

Readmore...

Difference between Varchar and NVarchar in SQL Server.

Tags : Varchar ,NVarchar ,Varchar(n),NVarchar(n),SQL Server,String,Length,Difference.Hi Friends,in this post i would like to explain difference between Varchar & NVarchar in SQL Server.* The data type Varchar and NVarchar are the sql server data types, both will used to store the string values.Differences :1 Character Data TypeVarchar - Non-Unicode Data NVarchar - Unicode Data2 Character Size Varchar - 1 byteNVarchar - 2 bytes3 Maximum Length Varchar - 8,000 bytesNVarchar - 4,000 bytes4 Storage Size...

Readmore...