Answer / sonia

Using the DROP COMMAND-
See the eg below--

create table stup(roll int,name varchar,marks int)
insert into stup values(1,'A',10)
insert into stup values(2,'B',20)
select * from stup
Alter table stup drop column marks
select * from stup

Answer / swetha

we can directly ALTER OR DROP the column AND THEN COMMIT ON
IT SO THAT IT GETS MODIFIED

Answer / amit srivastava

create table stup(roll int,name varchar,marks int)
select * from stup
Alter table stup drop column marks
select * from stup

Answer / ram murthy

we can delete an attribute through delete command.

What is Covering Indexes? Plz explain with example

3 Answers  

---

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

---

What are the hotfixes and patches in sql server?

0 Answers  

---

what are the problems in logshipping?

3 Answers  

---

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

---

What is awe?

0 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

find the 3rd max salary

10 Answers  

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

What stored by the model?

0 Answers  

---

What are functions in the sql server?

0 Answers  

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---