MS SQL Server

by

HOW TO OPEN WEB FORM IN NEW TAB OR WINDOW

To open a web page or html page in new window there is function “open” of “window” object. The open() method opens a new browser window.

Open() method is compatible with all browsers like (Google Chrome, Internet Explorer, Mozilla, Safari and Opera)

Syntax:
window.open(URL,name,specs,replace)

Parameter values:

URL: Optional. Specifies the URL of the page to open. If no URL is specified, a new window with about:blank is opened.

Name: Optional. Specifies the target attribute or the name of the window. The following values are supported:

_blank – URL is loaded into a new window. This is default
_parent – URL is loaded into the parent frame
_self – URL replaces the current page
_top – URL replaces any framesets that may be loaded
name – The name of the window (Note: the name does not specify the title of the new window)

Specs: Optional. A comma-separated list of items, no whitespaces. The following values are supported:

channelmode= [yes|no|1|0] – Whether or not to display the window in theater mode. Default is no. IE only

directories= [yes|no|1|0] –  Obsolete. Whether or not to add directory buttons. Default is yes. IE only

fullscreen= [yes|no|1|0] Whether or not to display the browser in full-screen mode. Default is no. A window in full-screen mode must also be in theater mode. IE only

height= pixels The height of the window. Min. value is 100

left= pixels The left position of the window. Negative values not allowed

location= [yes|no|1|0] Whether or not to display the address field. Opera only

menubar= [yes|no|1|0] Whether or not to display the menu bar

resizable= [yes|no|1|0] Whether or not the window is resizable. IE only

scrollbars= [yes|no|1|0] Whether or not to display scroll bars. IE, Firefox & Opera only

status= [yes|no|1|0] Whether or not to add a status bar

titlebar= [yes|no|1|0] Whether or not to display the title bar. Ignored unless the calling application is an HTML Application or a trusted dialog box

toolbar= [yes|no|1|0] Whether or not to display the browser toolbar. IE and Firefox only

top= pixels The top position of the window. Negative values not allowed

width= pixels The width of the window. Min. value is 100

replace: Optional. Specifies whether the URL creates a new entry or replaces the current entry in the history list. The following values are supported:

true – URL replaces the current document in the history list
false – URL creates a new entry in the history list

Share this:
Share
by

SQL Server – Difference Between Primary Key and Unique Key In MS Sql Server

Both PRIMARY KEY and UNIQUE KEY enforces the Uniqueness of the values (i.e. avoids duplicate values) on the column[s] on which it is defined. Also these key’s can Uniquely identify each row in database table.

Primary Key:

  • Can be only one in a table
  • It never allows null values
  • Primary Key is a unique key identifier and can not be null
  • By default it adds a clustered index
  • A table can have only one PRIMARY KEY Column[s]
  • We can generated ID automatically with the help of Auto Increment field. Primary key supports Auto Increment value.
  • Primary key can be related with another table’s as a Foreign Key.

Unique Key:

  • Can be more than one unique key in one table
  • Unique key can have null values(only single null is allowed)
  • It can be a candidate key
  • Unique key can be null But only one Null value.
  • By default it adds a UNIQUE non-clustered index
  • A table can have more than one UNIQUE Key Column[s]
  • Unique Constraint doesn’t supports Auto Increment value.
  • Unique Constraint can not be related with another table’s as a Foreign Key.

Share this:
Share
by

SQL Server – STUFF function in MS SQL Server

The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position.

Syntax:
STUFF ( character_expression , start , length , replaceWith_expression )

Arguments:

character_expression
Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data.

start
Is an integer value that specifies the location to start deletion and insertion. If start or length is negative, a null string is returned. If start is longer than the first character_expression, a null string is returned. start can be of type bigint.


PolicyBazaar IN CPL - Personal Loan

length
Is an integer that specifies the number of characters to delete. If length is longer than the first character_expression, deletion occurs up to the last character in the last character_expression. length can be of type bigint.

replaceWith_expression
Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data. This expression will replace length characters of character_expression beginning at start.

Example:
SELECT STUFF(‘abcdef’, 2, 3, ‘ijklmn’)

Output:
aijklmnef

Share this:
Share