Answer / bijoy vp

'\u0000'

Answer / 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

Answer / venky

Blank Space

Answer / mallesh

In Sybase the default value for Char is NULL
you can check it as

declare @val char(5)
select @val
o/p is NULL

Answer / foolishchild

'c'. where c represent any character.

Answer / samrat sen

In Sql Server 2000 the default value for char datatype is 10

Answer / satish

8

Answer / asha

Null

Answer / chiru

1

Answer / sujitha

1

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

What is trigger and different types of Triggers?

0 Answers   QuestPond,

About DTS usage ?

2 Answers   Cognizant, Wipro,

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

What is the maximum length of an alert name?

0 Answers  

Is it possible in sql table to have more than one foreign key?

0 Answers  

How do I start sql server agent automatically?

0 Answers  

How can you check the version of sql server?

0 Answers  

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

How to divide query output into multiple groups with the group by clause in ms sql server?

0 Answers  

How do I install sql server?

0 Answers  

What do you mean by data manipulation language?

0 Answers