Search In
Full form of ACID is Atomicity Consistency Isolation Durability . ACID is the concept that database professional follow while evaluating relational database and application architecture. For a reliable database all of the following attributes should
Stored Procedures
stored procedures is the collection of Sql statements which is stored in data base .
below are the advantage of stored procedures :
1.stored procedures reducing network traffic and boost application performance. .
2.stored p
Hi All,
Some times we need to know the all running/sleeping process in database. We can use the below code:--
SELECT 'These processes are using database' AS Note
,[Database]=DB_NAME(dbid), spid, last_batch,
status, hostname, loginame
FROM sys.syspr
We use ORDER BY to make our record list in a ordered manner in the sense of descending /ascending sort.
Syntax:-
SELECT column_name, column_name
FROM table_name
ORDER BY column_name ASC|DESC
Note:- User can ORDER BY more then one column in a s
IN Operator use:
It allows us to put multiple values in a where clause . With the help of this we can compare multiple values wtih where.
Syntax:
Select columnname(s) from Tablename where columnname IN(value1,value 2, .... value n);
Example:
SE
Endpoints in SQL
For providing TCP/IP communication between your SQL and other applications you need to create end point for that .
Creating end points is a series of steps
Message
Contract
Queue
Service
Route
Endpoint
In SQL we have Unique Key and Primary Key
Unique key is the key in which no value gets repeated including null once
Primary key cannot be null and value must be unique
So for making Unique key a primary key we will make it not null it will a
Suppose you have a Customer table in the database with the following data and you want to interchange the values of columns Name and Address.
Ex:
CREATE TABLE Customer
(
ID int IDENTITY,
Name varchar(100),
Address varchar(20
We need experienced Developer with strong SQL skills to work on migration of a large Database
- Very good DB and SQL skills specifically DML with ability to extract data from multiple tables and migrate them to the new DB structure.
- DB performanc
If the length of results is greater then the value if the max_allowed_packet system variable then the String-valued functions will return NULL
The first position of a string (for those functions which operate on string), is numbered 1.
Non-integer
