Search In
Basic structure of Layout Page
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width" />
<title>@ViewBag.Title</title>
@Styles.Render("~/Content/css")
@RenderBody()
@Scr
Properties file:
It is basically used to store data that is constant and can be used anywhere in the program.
Example: You can store the database credentials and connection parameters in the file and fetch it when required.
How to use:
PropertyP
CTE:Common Table Expressions
1)CTE's replace subqueries i.e they are result of complex queries so can be defined as temporary resultset.
2)CTE's are mainly used for recursive programming.
3)The lifetime of CTE's is the individual query it live in
Databases whose data is not required to be changed should be considered to be set as READ ONLY.Databases can be set to READ ONLY mode and back using T-SQL and SSMS.
Following are the scripts that can be used to set database read only and back:
--
UNION CLAUSE
The union operator in sql is used to combined two different queries into a singel table.
For eg:-we have one table which have information about employee, also have another table that have information about their department, and their is
Validation is an essential part of any web application. It is used to validate user input data. Before sending the user's input to different layers it must be validated.
Validation is of two types:-
1. CLIENT SIDE- client side validation is conside
StringBuffer:
As we know in Java String is immutable means we cannot reassign a new value to the same string object. That's why in Java to provide mutability we use either StringBuffer or StringBuilder. StringBuffer is a class in Java which provide
Whenever gem is used to easily schedule tasks using cron jobs, it enables you to manipulate standard functionality of your machine using Ruby code.
1: To start with Whenever we have to install gem
gem install whenever # insert this line in yo
Temp Table -Temporary Temp Tables
1)They can be created at run time in Tempdb database.
2)DDL,DML statements like select,update which can be executed on regular tables can be done on temporary tables. They can have constraints and can be indexed.
ArrayList:
The arraylist class provides dynamic arrays for storing elements. It extends AbstractList class and implements List interface. It stores only one type of objects (generic array).
Syntax:
ArrayList<String> arr=new ArrayList<Str
