Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpx
Starting Member
4 Posts |
 Posted - 2007-08-28 : 12:09:33
|
| Hello expertsI'm trying to enter some data into a table to run some tests. Whenever I open the table, I can enter data into all my fields *except* for the fields that I defined as Binary data types. I've tried to enter 0, 1, true, false... I always get the same error..."Invalid value for cell...The changed value in this cell was not recognized as valid.Error Message: You cannot use the Result pane to set this Field data to values other than NULL"Any ideas on this? I thought Binary was True or False? Is it the way I'm trying to enter data? I'm not familiar with SQL code and I just need to get a few rows filled up with data so I can test using gridview to pull the data onto a webpage.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-28 : 12:14:32
|
| Why don't you just use INSERT and UPDATE statements instead?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
jpx
Starting Member
4 Posts |
Posted - 2007-08-28 : 12:22:18
|
| Just because my main focus was to get some data entered to test viewing it on the website. I've written exactly 0 SQL statements before. I'm already feeling overwhelmed learning ASP.NET and C# at the same time... I was hoping to put off jumping into SQL until I got the website framework complete.But I guess that wasn't the best plan of action, eh? Sink or swim, I suppose!Thanks for you input! |
|
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2007-08-31 : 11:31:42
|
| If you are attempting to track True/False results use a Bit field. Binary is the field type for storing BLOBs, or Binary Large Objects, such as files.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
|
|
|
|
|
|
SQL Server Management Studio - Entering field data