is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

What command do we use to rename a db, a table and a column?

0 Answers  

---

what is difference between primary key and Unique

8 Answers  

---

What is difference between joins and subqueries?

0 Answers  

---

What is Online Index Rebuild Operation?

1 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

What are types of subqueries?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

Can you explain various data region available in ssrs with their use?

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

How to test values returned by a subquery with the in operator?

0 Answers  

---

If a table does not have a unique index, can a cursor be opened on it?

0 Answers  

---