Virtual University Of Pakistan Network
|Question Title||Data Types in SQL Server|
Let suppose you are working as a database controller in a renowned company which has a huge database system that change recurrently. A lot of transactions, searches and DML operations are being processed daily. It is obvious that these operations facilities are being provided by different types of query languages.
Following are the two cases;
For above mentioned cases, you are asked to create columns (table) of database with suitable data types meeting to the following conditions.
Suggest the suitable Data Types, NCHAR, NVARCHAR, CHAR and VARCHAR, for the above mentioned situations with reasoning; so that the retrieval of information from the column (tables) would be fast enough.
Note: In the above scenario you only read from columns (table) and not write to columns (table).
For every situation explain your answer with suitable arguments.