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

What is a data source or ds? : sql server analysis services, ssas

1 Answers  

---

Why do we use non clustered index?

1 Answers  

---

What is logshipping and its purpose?

1 Answers  

---

How to truncate a table first before running a package?

1 Answers  

---

What is clr ddl trigger?

1 Answers  

---

What is resource db in sql server?

1 Answers  

---

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 Answers  

---

What is the difference between executequery () and executeupdate ()?

1 Answers  

---

Do you know query execution plan?

1 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

Why we should not use triggers?

1 Answers  

---

how to invoke a trigger on demand? : Sql server database administration

1 Answers  

---