Interested to Buy Any Domain ? << Click Here >> for more details...
what is bit data type? and what are the information that can
be stored inside a bit column?
- 2 Answers
- 4440 Views
- I also Faced
- E-Mail Answers
Answer Posted / meena kurade
Bit datatype is used to store boolean information like 1 or
0 (true or
false). Untill SQL Server 6.5 bit datatype could hold either
a 1 or 0
and there was no support for NULL. But from SQL Server 7.0
onwards,
bit datatype can represent a third state, which is NULL.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can I change procedure name in sql server?
What is row_number () and partition by in sql server?
What are commonly used mssql functions in php?
what is isolation level at dead lock?
How to list all user names in a database?
What is update_statistics command?
What is a hint?
What is query processing?
What is the difference between left and right outer join?
What is the sql profiler?
Can sql servers linked to other servers?
What is the command dbcc checkdb used for?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
