Student Academic blog

You can get all database name by using below Query.

SELECT NAME FROM SYS.DATABASES

You can also use Store Procedure given below.

EXEC sp_databases

ALL, SQL 2005 & 2008 sql server 2008, sql

If you want to import huge amount of data in a table from another database , then first delete indexes becasue it will import fastly.

ALL, SQL 2005 & 2008 sql server 2008, sql, tips & tricks

SQL Server user names are:

• sa
• sql
• admin
• administrator
• administrador
• root
• access
• db
• database
• datenbank
• saadmin
• web
• webadmin
• master
• chef
• server

Do not visible above defult username to outside.

ALL, SQL 2005 & 2008 sql

you are working on database and you have to add the multipe columns in a table then you need alter command. In this example i have told you how to create multiple columns in a table by using query.

Syntax:

ALTER TABLE [TABLE NANE] 
ADD 
[COL 1] DATATYLE,
[COL 2] DATATYLE,
[COL 3] DATATYLE,
[COL 4] DATATYLE,
[COL 5] DATATYLE

Example

Create a table with anem table1

CREATE TABLE TABLE1

(ID BIGINT IDENTITY,

FULLNAME NVARCHAR(100)

)

Now you have to add birthdaym status and gender columns in table1. now you have to write one line of code as given below.

ALTER TABLE TABLE1 ADD BIRTHDAY SMALLDATETIME, STATUS BIT, GENDER CHAR(2)

ALL, SQL 2005 & 2008 sql, alter

What is Data Mining?

The analysis of data to find hidden patterns is called data mining. Architects, Devlopers and Analysts are involved in data mining process.

ALL, SQL 2005 & 2008 sql, data mining