Write down the syntax and an example for create, rename and delete index?

0 Answers  

---

What are the disadvantages of using the stored procedures?

0 Answers  

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

How to find the date and time of last updated table?

6 Answers   Teledata,

---

---

Explain system scalar functions?

0 Answers  

---

What is an example of a foreign key?

0 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---

Explain what is scheduled job and how to create it?

0 Answers  

---

what is difference between NULL and ISNULL in SQL Server 2008?

0 Answers   MCN Solutions,

---

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,

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---