Answer / Anand Pandey

"A schema in SQL Server is a container object that holds database objects such as tables, views, and stored procedures. Schemas provide a logical organization of these objects and can improve security by allowing you to control access at the schema level. To create a new schema in SQL Server 2005, you can use the CREATE SCHEMA statement followed by the name of your new schema and any database objects (if desired). For example: CREATE SCHEMA MySchema; CREATE TABLE MySchema.MyTable (...);"n

How can I create a new template for import ? : sql server management studio

1 Answers  

---

What are dml triggers and types of dml triggers?

1 Answers  

---

How will u get 5 years back record?

5 Answers  

---

Why do you want to join software field as you have done your BE in Electronics?

1 Answers   Cap Gemini, HCL,

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1 Answers  

---

can primery key be a non clustered index?

10 Answers  

---

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---

What is the difference between the 2 operating modes of database mirroring?

1 Answers  

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1 Answers  

---

What are constraints?

1 Answers  

---

What is set nocount on and what is set nocount off?

1 Answers  

---

What are subqueries in sql server? Explain its properties.

1 Answers  

---