How do I schedule a sql server profiler trace?

0 Answers  

---

What are the different types of collation sensitivity in sql server?

0 Answers  

---

How to use column default values in insert statements in ms sql server?

0 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

How to create an identity column?

0 Answers  

---

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

---

How to execute stored procedure and set temp table in sql server?

0 Answers  

---

Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,

---

Why do we need normalization?

0 Answers  

---

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

1 Answers   GE,

---