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
- 4400 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreejith s t
Bit is used to store boolean values . It stores 0 , 1 and
NULL .
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is a document index?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is the advantage of sql server?
Do you know how to store and query spatial data?
Data table as parameter in sql server?
Explain primary key, foreign key and unique key?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is a non-clustered index?
What the class forname () does?
How to perform backup for certificates in sql server? : sql server security
Explain Geometry datatype in sql server 2008 with example
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
