How column data types are determined in a view?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

what is an extended stored procedure? : Sql server database administration

0 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

---

What is the difference between login and a user?

13 Answers   CTS, TCS,

---

What is row-level compre?

0 Answers  

---

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 Answers  

---

Explain different types of locks in sql server.

0 Answers  

---

How to add an address record into adventureworkslt?

0 Answers  

---