adspace


What is the default value of CHAR type?

Answer Posted / yash

The default value of a variable of value type is the value
assigned in the default constructor. For simple types this
value corresponds to a bit pattern of all zeros:
• For integer types, the default value is 0
• For char, the default value is `\u0000' //Unicode
• For float, the default value is 0.0f
• For double, the default value is 0.0d
• For decimal, the default value is 0.0m
• For bool, the default value is false

Is This Answer Correct ?    26 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you append an identity column to a temporary table?

1076


How can I check that whether automatic statistic update is enabled or not?

1120


When should you use an instead of trigger?

1061


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1051


How efficient you are in oracle and SQL server?

1269


How do I find query history in sql server?

1033


what is the difference between openrowset and openquery?

1207


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1031


What are wait types?

1261


List out the different types of locks available in sql server?

1055


Why should you use or avoid select * statements?

1120


What is the difference between for xml raw and for xml auto?

1125


Can you index views?

958


Why we use the openxml clause?

1088


Disadvantages of the indexes?

1230