Answer Posted / 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

How to transfer a table from one schema to another?

1002

---

Why should one not prefix user stored procedures with ‘sp_’?

1046

---

What new data source types were added in ssrs 2014?

160

---

Does partitioning help performance?

935

---

Does hive support indexing?

959

---

What is Lock table in SQL?

1470

---

What is the difference between grant and with grant while giving permissions to the user?

963

---

How to set the current database in ms sql server?

1081

---

If user is owning any SQL Objects, can we drop that user

2076

---

What is the default port for SQL Server over a firewall?

1098

---

How will you optimize a stored procedure optimization?

1040

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5924

---

How does stuff differ from the replace function?

1011

---

Explain stored procedure?

1053

---

Can we create clustered index on composite key?

1084

---