Answer / Rajender Kumar

A SELECT query statement in MS SQL Server is used to retrieve data from one or more tables. The basic structure of a SELECT statement includes the keywords SELECT, FROM, and WHERE. For example: SELECT column1, column2 FROM table_name WHERE condition;

How do I shrink an ldf file?

1 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

1 Answers  

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

Create and insert into temp table in sql server?

1 Answers  

---

How to create dbo table in sql server?

1 Answers  

---

How do I manually uninstall an instance of sql server 2016?

1 Answers  

---

Can sql servers linked to other servers like oracle?

1 Answers  

---

What is a rollup clause?

1 Answers  

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

1 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---