Download
100% FREE
Office Document APIs for .NET
Online: 897
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Bookmarks
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Forums
>
ASP.NET
>
Loading ...
how to insert data valur in IsActive column in sql server
Posted by
Shanky11
under
ASP.NET
on 3/23/2013 |
Points: 10
| Views : 3003 | Status :
[Member]
| Replies : 8
Write New Post
|
Search Forums
|
Resolved Posts
|
Un Answered Posts
|
Forums Home
how to insert data value in IsActive column in sql server
data type is bit of that column
actually my table is consist of columns
message id message, chapter, session,word,IsActive
Reply
|
Reply with Attachment
Alert Moderator
Responses
Posted by:
Prateekagra
on: 3/23/2013
[Member]
Starter
|
Points: 25
0
what is Inactive it is columns name or it is any property of table
Prateek Agarwal
DBA
Shanky11
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Posted by:
Shanky11
on: 3/23/2013
[Member]
Starter
|
Points: 25
0
hi prateek
its IsActive column name data type bit
Shanky11
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Posted by:
Prateekagra
on: 3/23/2013
[Member]
Starter
|
Points: 25
0
then there is no issue to insert any int type values eg
insert into xyz values(1)
Prateek Agarwal
DBA
Shanky11
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Posted by:
Prateekagra
on: 3/23/2013
[Member]
Starter
|
Points: 25
0
hi Shanky
if you satisfy the answer then closed this closed mark as answered
Prateek Agarwal
DBA
Shanky11
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Posted by:
Shanky11
on: 3/23/2013
[Member]
Starter
|
Points: 25
0
i have to add this by manual insertion not by query
Shanky11
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Posted by:
Prateekagra
on: 3/23/2013
[Member]
Starter
|
Points: 25
0
then you have right false or true in the column
Prateek Agarwal
DBA
Shanky11
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Posted by:
Shanky11
on: 3/23/2013
[Member]
Starter
|
Points: 25
0
its showing error........................
Shanky11
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Posted by:
Prateekagra
on: 3/23/2013
[Member]
Starter
|
Points: 25
0
can you share the error message please and also let me know the structure of table and data you are trying to insert
which version of sql you are using
Prateek Agarwal
DBA
Shanky11
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Login to post response
Latest Posts
specific cast is not valid in linq query when compare two tables
(0)
New
SEO(Search Engine Optimization)
(0)
New
Dial Hotmail Customer service Number +1-800-518-0963
(0)
New
Best Assignment Help Services Provider
(0)
Updated
How can a video in the website explain the navbar values?
(1)
Updated
surge arresters price
(0)
New
small hot chamber die casting machine for sale
(0)
New
Hangzhou Lin'an Tianfu non-woven
(0)
New
More ...