Tuesday, April 12, 2011

What are user defined datatypes and when you should go for them?

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.

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Explain the different parts that constitute ASP.NET application.

Content, program logic and configuration file constitute an ASP.NET application. Content files Content files include static text, images ...

  • Define your own namespace
    Namespace MyNamespace      Public Class  Class2      End Class End  Namespace Namespace MyNamespace      Public Class  Class1      ...
  • Use Namespace
    Namespace MyApp.Info      Module Main          Sub  Main ()              Dim  objHW  As  New MyApp.Info.Utilities              objHW.Dis...
  • Add two integers together
    Module Tester     Sub  Main ()        Dim  firstNumber, secondNumber  As  String        Dim  number1, number2, sumOfNumbers  As  Intege...