what is DTS what are tasks available

1 Answers   Wipro,

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

Relational calculus is what type of language?

0 Answers   HCL,

---

Simple example for difference between select and cursor in sql

1 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,

---

Can I work with several databases simultaneously? : sql server management studio

0 Answers  

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---

Is null vs coalesce?

0 Answers  

---

Does partitioning ssd reduce performance?

0 Answers  

---

Explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

---