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...

String Functions in SQL Server.

Tags : String Functions,Sql Server 2005,Sql Server 2008.Hi Friends,in this article i would like to explain String Functions in SQL Server.* LEN (string) - Returns the length of the given string.For Example :select len(Address) as Address from Employee* LEFT (string, length) - Returns the specified number of characters from the beginning of the string.For Example :Select LEFT(Address,1) as Address from Employee* RIGTH (string, length) - Returns the specified number of characters from the end of the string.For Example :Select RIGHT(Address,2)...

Readmore...

How to start and stop triggers in sql server?

Tags : Enable Trigger,Disable Trigger,SQL Server 2005,SQL Server 2008,Triggers,Start,Stop.Hi Friends,in this post i would like to explain enabling and disabling triggers in SQL Server.* By writing Commands we can Start/Stop triggers in SQL Server.Enabling/Starting Trigger :Enable Trigger TriggerName ON database.dbo.tablename Disabling/Stopping Trigger :Disable Trigger TriggerName ON database.dbo.tablenameThank You...

Readmore...

SQL Server Triggers.

Tags : SQL Server 2005,SQL Server 2008,Triggers,DML Triggers,DDL Triggers,Logon Triggers.Hi Friends,in this post i would like to explain Triggers in SQL Server.* It is one kind of stored procedure, but triggers neither accept nor return any values.* Trigger is an action which can be execute automatically.* It is defined to execute automatically when the specified event is occurred.Types of Triggers :1) DML Triggers :These triggers executes automatically when data manipulation language event occurs. DML events are insert,update,delete.2) DDL Triggers...

Readmore...