Answer / swapna

User defined datatypes let you extend the base SQL Server
datatypes by providing a descriptive name, and format to
the database. Take for example, in your database, there is
a column called Flight_Num which appears in many tables. In
all these tables it should be varchar(8).

In this case you could create a user defined datatype
called Flight_num_type of varchar(8) and use it across all
your tables.

Explain transaction server auto commit?

0 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---

what is an sql server?

1 Answers  

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

---

---

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

---

What is the purpose of the master database?

0 Answers  

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

How do I create a stored procedure in sql server?

0 Answers  

---

One table how may column and Primary key

3 Answers  

---

What is the difference between row_number and dense_rank?

0 Answers  

---

Can we hide the definition of a stored procedure from a use?

0 Answers  

---