Answer / rajiv singh

CREATE LOGIN ra
WITH PASSWORD = 'passwd';
USE COREDATA;
CREATE USER ra FOR LOGIN ra;
GO

DROP LOGIN name

Answer / jagadeesh

create login 'name' with password='cghhicl'
GO
DROP LOGIN name

Can an entity have two primary keys?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

What happens if date-only values are provided as date and time literals?

0 Answers  

---

Which command is used for user defined error messages?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

What is difference between aggregate and analytic function?

0 Answers  

---

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  

---

What are the built in functions in sql server?

0 Answers  

---

How to connect ms access to sql servers through odbc?

0 Answers  

---

Why use triggers?

0 Answers  

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

How do you create an execution plan?

0 Answers  

---