If function Excel

Excel > Functions > IF

The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.

       IF(logical_test, [value_if_true], [value_if_false])

 

Example:



Response.IsClientConnected asp.net

ASP.NET > Web > HttpResponse > IsClientConnected

The IsClientConnected property is a read-only property that indicates if the client has reset the connection to the server.

This property enables you greater control over circumstances where the client may have reset the connection to the server. For example, if a long period of time has elapsed between when a client request was made and when the server responded, it may be beneficial to make sure the client is still connected before continuing with something.

Example

If Not Response.IsClientConnected Then 
  Response.Redirect("login.aspx")
End if

Response.Redirect asp.net

Redirects a client to a new URL. Specifies the new URL and whether execution of the current page should terminate.

Parameters

url

The target location.

endResponse

Indicates whether execution of the current page should terminate.

bool continue;

// some code

if (continue)
{
    Response.Redirect("page.aspx", false);
}
else
{
    Response.End();
}

HttpCookie asp.net

ASP.NET > HttpCookie 

The HttpCookie class gets and sets properties of individual cookies.

HttpCookie loginCookie = Request.Cookies.Get("loginCookie");
if (loginCookie == null)
{
     loginCookie = new HttpCookie("loginCookie");
     loginCookie.Value = txtUsr.Text;
     loginCookie.Expires = DateTime.Now.AddDays(15);
     Response.Cookies.Add(loginCookie);
}

OBJECT_ID SQL Server

SQL Server > Built-in Functions > OBJECT_ID

OBJECT_ID returns the database object identification number of a schema-scoped object.

Example:

IF OBJECT_ID (N'dbo.tbl1', N'U') IS NOT NULL
  DROP TABLE dbo.tbl;
GO

SET XACT_ABORT SQL Server

SQL > Set Statements > XACT_ABORT

Specifies whether SQL Server automatically rolls back the current transaction when a Transact-SQL statement raises a run-time error.






Syntax:
SET XACT_ABORT { ON | OFF }

Example

IF OBJECT_ID(N'tbl1', N'U') IS NOT NULL
DROP TABLE tbl1;
GO
IF OBJECT_ID(N'tbl2', N'U') IS NOT NULL
DROP TABLE tbl2;
GO

CREATE TABLE tbl1
(fld1 INT NOT NULL PRIMARY KEY);
CREATE TABLE tbl2
(fld2 INT NOT NULL REFERENCES tbl1(fld1));
GO
INSERT INTO tbl1 VALUES (1);
INSERT INTO tbl1 VALUES (2);
INSERT INTO tbl1 VALUES (3);
INSERT INTO tbl1 VALUES (4);
GO
SET XACT_ABORT OFF;
GO
BEGIN TRANSACTION;
INSERT INTO tbl2 VALUES (1);
INSERT INTO tbl2 VALUES (2);
INSERT INTO tbl2 VALUES (5); -- Foreign key error. SELECT shows only values 1 and 2 inserted. -- Values 5 insert failed and was rolled back, but
-- XACT_ABORT was OFF and rest of transaction
-- succeeded.

COMMIT TRANSACTION;
GO
SET XACT_ABORT ON;
GO
BEGIN TRANSACTION;
INSERT INTO tbl2 VALUES (3);
INSERT INTO tbl2 VALUES (5); -- Foreign key error.
-- Values 5 insert error with XACT_ABORT ON caused
-- all of the second transaction to roll back.
INSERT INTO tbl2 VALUES (4);
COMMIT TRANSACTION;
GO

SELECT * FROM tbl2;
GO

date datatype SQL Server

SQL Server > Data Types > Date

Default format: YYYY-MM-DD
Range: 0001-01-01 through 9999-12-31

Example

DECLARE @date1 date
CREATE TABLE Table1 ( datefield date )

-- difference between date and datetime

DECLARE @date date= '12-10-21';
DECLARE @datetime datetime= @date;

SELECT @date AS 'date', @datetime AS 'datetime';

--Result
--date              datetime
------------       -----------------------
--2021-12-10  2021-12-10 00:00:00.000

Other Examples

• Set hour and minute to date