What is the default value of CHAR type?
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 26 Yes | 2 No |
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
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / samrat sen
In Sql Server 2000 the default value for char datatype is 10
Is This Answer Correct ? | 5 Yes | 6 No |
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
How do you find the error, how can you know the number of rows effected by last SQL statement?
Explain a differential backup?
ow to bring suspect mode datbase online from scratch
What is snapshot replication?
Can you leave a union at any time?
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
write the query for find the top 2 highest salary in sql server
36 Answers Cranes, Jayanti Software, Medi Assist, Rmax, TCS,
sql database suspect We have a sql database that is showing as suspect. How can we recover?
how many type of subquery?
Can two different columns be merged into single column? Show practically?
How can you control the amount of free space in your index pages?