Answer / Rakhi Gupta

To get a list of columns in a view using the sp_help stored procedure in MS SQL Server, use the following syntax:nEXEC sp_helpview 'viewName';nExample:nEXEC sp_helpview 'EmployeesView'

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  

---

How do I create a stored procedure in sql server?

1 Answers  

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

How the authentication mode can be changed?

1 Answers  

---

What is an index. What are the types?

1 Answers  

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

Why I am getting this error when dropping a database in ms sql server?

1 Answers  

---

What is ms sql server reporting services?

1 Answers  

---

How to turn off warning messages during php execution?

1 Answers  

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

1 Answers  

---

According to you what goes into making the best database administrator? : sql server database administration

1 Answers  

---