I want to store IP number in a column in db but which column type should I use? Of course I can use string but isn't this a waste of storage space? Can I not store IP nr in another type in db that saves space?
View Complete Post
is there a way to do the above, for example...I have a text column, Column A containing "172671-08-7892", I need 7892 to be extracted to another column of the type number, from there I need to divide by 2. If the remainder is 0, Column C will
be updated as Female, if the remainde is 1, Column C will be updated as Male
am try to generate a auto increment column for my SharePoint list of type number type?
=TEXT(1000+ID,0) , when i use this formula it works some time and some time it doesn`t increment?
do you know any out of box way to do this?
Thanks in Advance
Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.
Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.
MSDN Magazine February 2001
MSDN Magazine December 2000
Hi guys. I have two little problem.
I have database with one table and it has 4 rows.
1. I want to show a zero in front of all number. Actually i added but it doesn't show.
2. If i don't put any value in column is it possible to have minus for example instead of 0?
I post it like that because i can't see how to post pics directly.
P.S. The columns with numbers have checked "allow nulls".
I draw in paint so it's not so good but i think it's understandable.
10x in advance.
i am creating a column in the list while creating a column i will have an option for choice field on selecting choice i can see dropdown, radiobutton, Checkbox to select and can enter list of values. and on clicking ok i will get a column with
radiobutton. in newform.aspx and also in editform.aspx
so i need to create the similar functionality with my custom radio button, so on create column i need to show my custom choce on selecting this i need to show my custom radiobutton and can enter list of values then on selecting it then click
ok to create a column, in edit form and new form i need to show a radio buttons with values.
Thanks in advance