Answer Posted / muthu kumar

create table t(id int identity(seed,increment))

where seed is starting number and increment is number to be
incremented.

create table t(id int identity(1,1),name varchar(50))

so the id will be start with 1 and will be incremented 1 by
1 each time when record is get insered

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2043

---

What will happen if a column containing char type data is changed to the nchar data type?

1054

---

Explain the xml support sql server extends?

999

---

How to list all login names on the ms sql server?

1093

---

What are the difference between primary key and unique key? : sql server database administration

911

---

How to generate random numbers with the rand() function in ms sql server?

1074

---

How to assign new column names in a view?

877

---

What are click through reports?

140

---

How to generate create table script on an existing table in ms sql server?

1111

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

968

---

Explain what is the main purpose of having conversation group?

894

---

What do you mean by an execution plan?

1065

---

What is msdb database? : SQL Server Architecture

1084

---

how many type of indexing in database?

946

---

You want to use a perspective in an mdx query. How do you select the perspective?

235

---