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

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

---

How to truncate a table first before running a package?

1 Answers  

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  

---

Can we use where clause with group by?

0 Answers  

---

How to Insert multiple rows with a single insert statement?

0 Answers  

---

Explain a join?

0 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

How can you insert null values in a column while inserting the data?

0 Answers  

---

Explain following error properties?

0 Answers  

---

What is difference between delete and truncate commands?

0 Answers  

---

How to download and install microsoft .net framework version 2.0?

0 Answers  

---