Answer Posted / vikram k mahapatra

It return Int datatype

How many instances per computer are there in sql server 2000?

1077

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111

---

What are the different types of normalization?

1167

---

What is the tcp/ip port on which sql server runs?

1160

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1030

---

How can you control the amount of free space in your index pages?

1057

---

Which autogrowth database setting is good?

1059

---

What is a partitioned view?

991

---

How to insert a new row into a table with "insert into" statements in ms sql server?

974

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1012

---

Does order by actually change the order of the data in the tables or does it just change the output?

1146

---

What program is used to store the data source file?

961

---

Define inner join in sql server joins?

1060

---

Can we perform backup restore operation on tempdb?

1015

---

What is index in an assignment?

954

---