blnreddyTech

SQL  Server  built-in functions Coalesce() It is A function Is Very Much Useful at Run time When We Have Multi Value Attribute in a Table. If U Consider below facts placed in a employee table With Id, Name, ph_no, Alt_no, Office no. id Name Ph_ no Alt_ no Office no 101 Albert 999999 456453 321333 102 khan null null 123455 103 victor 112121 null null 104 lovely null null 1897321 Above Employee table may have single value are three values if it have single value then it fill null  values with remaining attributes When We Retrieve The Number from employee table That Number Should Not be Null value To get not null value from employee table We Use Coalesce() Function It Returns First Encountered Not Null Value  from employee table select id , name , coalesce ( Ph_no , Alt_no , Office_no ) as contact number from employee

Events in C# Syntax of event declaration [attributes][modifers] event <delegate_type> <event_name>[ {event body}   ]; we will discuses about syntax of event ·         Attribute s are csharp attributes ·         Modifiers are optional and those may one are combination of more than one o    Accessing specifies §   Public, private, protected, internal §   New, Virtual, Abstract, override §   Static ,extern o    Event will work between objects because of that when your are defining event in main function existing class you have to specifies event as static              ·         Event o    It is a keyword used to give event declaration o    In syntax event keyword must not be omitted ·         Type o    Event is a role player  variable foe delegate o    Without delegate event will not fired o    Type is a delegate type which is giving functions to event at run time when event is fired this process is known as hookup ·