Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default value of CHAR type?
- 10 Answers
- 21517 Views
- Bosch, I also Faced
- E-Mail Answers
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 |
List the various tools available for performance tuning?
What command is used to rename the database?
How many types of cursors are there in SQL Server?
5 Answers 247Customer, CarrizalSoft Technologies,
What are the benefits of using stored procedures over sql statements?
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What are the differences between UNION and JOINS?
3 Answers CarrizalSoft Technologies,
What is a transact-sql statement batch in ms sql server?
Can we execute a stored procedure inside a trigger?
6 Answers BirlaSoft, CarrizalSoft Technologies, United Healthcare,
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is oltp (online transaction processing)?
How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
