Update table join SQL Server

SQL Server > Update > Using Join


UPDATE
  tbl1 AS A
  INNER JOIN tbl2 AS B ON A.F1=B.F1
SET
  A.X = 1,
  A.Y = 2
WHERE
  A.id = 100

nvarchar data type SQL Server

SQL Server > Data Types > nvarchar

• variable length 
• Unicode string data.
• length can be a value from 1 through 4,000.
• maximum storage size is 2 GB

Example

CREATE TABLE dbo.Person
(
   Name nvarchar(100)
);

Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack

ASP.NET > Errors

This error normally occurs when we use Response.Redirect or Server.Transfer or Response.End in your code before completing the actual process the page was doing.

In this case what you have to do is

In place of Response.End you have to use HttpContext.Current.ApplicationInstance.CompleteRequest

in place of Response.Redirect, use the Response.Redirect ("home.aspx", false)
in place of Server.Transfer, use the Server.Execute method

DATEADD SQL Server Example

SQL Server > Built-in Functions > DATEADD

Add a number to a specified datepart of that date.

DATEADD (datepart , number , date )

datepart: is the part of date to which an integer number is added.

Example:

SELECT DATEADD(month,1, GetDate()) -- add 1 month to current day

SELECT DATEADD(day,1, GetDate()) -- add 1 month to current day
SELECT DATEADD(year,1, GetDate()) -- -- add 1 year to current day


Find last day of previous month

ref c#

C# > Keywords > ref

The ref method parameter keyword on a method parameter causes a method to refer to the same variable that was passed into the method. Any changes made to the parameter in the method will be reflected in that variable when control passes back to the calling method.

using System;

public class MyClass
{
   public static void Ref(ref char x)
   {
      // The value of i will be changed in the calling method
      x = 'a';
   }
   public static void NoRef(char x)
   {
      // The value of i will be unchanged in the calling method
     x = 'b';
   }
   public static void Main()
   {
      char i = '';    // variable must be initialized
      Ref(ref i);  // the arg must be passed as ref
      Console.WriteLine(i);
      NoRef(i);
      Console.WriteLine(i);
   }
}

How to use the Desktop Alerts feature in Outlook

To open the settings dialog box for the Desktop Alerts feature, follow these steps:

1. On the Tools menu, click Options.
2. On the Preferences tab, click E-mail Options.
3. Click Advanced E-Mail Options.
4. Click Desktop Alert Settings.

In the Desktop Alert Settings dialog box, you can configure the duration and the transparency of your Desktop Alert notifications for when a new e-mail message is received. To turn off the Desktop Alerts feature, click to clear the Display a New Mail Desktop Alert check box.

Note You only receive Desktop Alert notifications if you have Microsoft Exchange server and Post Office Protocol version 3 (POP3) profiles. Internet Mail Access Protocol version 4 (IMAP4) and HTTP accounts do not support the Desktop Alerts feature.

?? Operator (C# Reference)

C# > Operators > ?? Operator

The ?? operator,also called the null-coalescing operator, returns the left-hand operand if it is not null, or else it returns the right operand.

Example

// y = x, unless x is null, in which case y = 0.
int y = x ?? 0;