Answer / bhagwat sharma

create table student
(
roll_no int,
name varchar(20),
class int,
address varchar(50),
phone int
)
++++++++++++++++run select than press f5

insert into student values(1,'Bhagwat',10,'Mathura',9268450493)
+++++++++++++run select than press f5

select * from student where roll_no=1
+++++++++++++++++++++++++++run select than press f5

Answer / muruga nandhini.p

create table student
(
roll_no int,
name varchar(20),
class int,
address varchar(50),
phone int
)
++++++++++++++++run select than press f5

insert into student values(1,'Bhagwat',10,'Mathura',9268450493)
+++++++++++++run select than press f5

select * from student where roll_no=1
+++++++++++++++++++++++++++run select than press f5

How to convert a table data in XML format in sql server?

0 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

What is built-in function?

0 Answers  

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

Mention a few common trace flags used with sql server?

0 Answers  

---

What is primary key, unique key, and foreign key?

0 Answers  

---

What is a cube? : sql server analysis services, ssas

0 Answers  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---

What is the purpose of update statistics and scope_identity() function?

0 Answers  

---

According to you what goes into making the best database administrator? : sql server database administration

0 Answers  

---

what is DTS what are tasks available

1 Answers   Wipro,

---