SQL Server :: Data Type Of Storage Used For Male And Female?
Mar 10, 2011What data type of storage used for male and female?
View 2 RepliesWhat data type of storage used for male and female?
View 2 Repliesi have a folder on the server which contains jpeg files,mp4 files and also xml files...........
i would like to transfer the folder to a centralised storage server ,i would like to pass the credentials from the web page itself,,,,,,,,
what do i use for it
the storage server is within the network and all it needs is credentials to copy the folder which i m ready to pass....but i dont know the code which has to be used......
whether to use system.io.move
or
httpwebrequest.
Currently, I am storing images and video clips in my database as a varbinary(max).
The problem is that when my front-end goes to retrieve and play the video, it takes an excessive amount of time to download.
For example, I have a video file: test.avi (5mb). If I attempt to read from database and play avi, it takes about 40 seconds. If I attempt to play this test.avi from the filesystem, it takes about 10 seconds to load.
I have investigated compression/decompression, but those seem to be as time-consuming as just loading up the raw data from the database.
Should I scrap storing video clips in the database, and go for a file system approach. I would really like to keep everything clean, secure, and organized. Which is why I am storing images, video clips, etc. in database.
In my C# website i want to add some speech which should be in UK English British Male Voice, how can i do that, and from where i may get that voice. Is there any way to do that?
View 1 RepliesI've seen some explanations of these, but nothing that really compares where they start, end, or overlap, or good examples of their use.
What is the life span of each of the following data collections? And am I missing any?
Application
Session
ViewData
TempData
I have data for Visa, Mastercard, moneybookers, etc. .. How do you propose to store data? In each table separately or not? You might like: 1 table that stores all the data and then call the information according to Visa, Mastercard, moneybookers, etc. Example: a table stored all data has deposit_options from each payment, or payments for each option do I need to each payment separately.
View 4 RepliesI'm thinking of using 3 layered architecture in my web site.Kind of classic layers - Presentation, BL, DAL and BO - business objects, just like in this great article http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=416I will have 4 projects according to levels.I'm goung to store data in xml files and my question is where should those files be located? In App_Data folder of web site? Then how DAL will know path where to find files to parse?
View 4 RepliesHow save and display data from local storage with angular..I want save this data example
View 1 RepliesI am looking for opinions and best coding practices.I need to get info from a database with a query such as SELECT this, that FROM MyDB (returning 2 fields). Would it be wrong to use a hashtable for temporary storage?Is there a better way to accomplish the same thing? What about if I am returning more than 2 fields, would it be best to step up to a DataSet or something?
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
GetData();
[code]...
I want to use XML file as a data source for my application.
View 2 RepliesI need to do edit funtionality for registration forms (5 in number) in a trading system. Requirment is to do it in a way that user edit details in a form and click next or previous button and data will be saved somewhere until user reach last form and click save button. On this click all changes will be updated to database table. where I should hold this temporary data ? I cant use database tables for this. There come many options in mind like cach, session and application variables. But I am confuse which way will best performance wise. There are 5 forms and every form has 15 to 25 fields in it. I dont know expected no of users but hoping a good count.
View 8 RepliesI want to know what are the ms sql datatype and when to use..
Its very important when to use all the ms sql datatype
how can specified nvarchar data type without N''?
View 2 RepliesHere Am Using This Query to
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME = 'TableName')
But Am getting Total Records instead of i need Specific Columns.....
I use a ntext data type for all kind of data save in one field, but when i save byte (that converted from image) follwing message is shown "Operand type clash: varbinary(max) is incompatible with ntext". Is ntext suitable for all kind of data type or what will be compatible for all data type support?
View 2 RepliesI have a database that has several timestamp fields. One is addTime, another is editTime, and the final one is subTime. depending on which part of the web application the user uses, it will update one of these fields. I know in a sql command in the code behind you can use the getDate() function to populate a value, but will the sql command automatically parse it to the SmallDateTime datatype in the database?
View 2 RepliesThere are 2 tables in sql server 2008. I am updating 2nd table with 1st table data. one of the column data type in the 1st table is char(10) and the same field in other table is varchar(10).
On updation I m using bcp utility to export to txt file from table 2.
But data exported is exported with spaces at the end.
Is there any way to remove these spaces.
I have the following:
[code]....
I keep getting this error:
Message = "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."
What i'm trying to do is group by ContentObjectId and then get StartDate that is greater than today.
I'm using entity framwork and MS SQL2008
How to i convert the data type in the address field? i keep getting an error
here is my code:
[Code]....
I have a huge form control in my asp.net application and i need to pass all value to SQL procedure.I am looking some ready function which can check each input data if it have the below format.
Char,
Numeric,
Decimal,
Bool,
DateTime
accordingly i can format the string and send to the procedure.
http://forums.asp.net/p/1625331/4177299.aspx#4177299?Is+Identity%3f+in+table+definition+not+available
I tried all that was suggested in the above link..but I just cannot see the Identity data type option in the drop down. How can I set one field as a Identity data type if I dont see it?
I'm trying to create a control out of a class I found, and one of the overridden functions is the following:
protected override void PerformDataBinding(IEnumerable data)
However, when I try to build the control I'm getting the error as shown in the subject. I've tried searching, and it seems the signature for the original function matches the one I have, and all other solutions I've seen uses the same signature.
I have a table in my SQL Server db with fields of money datatype. It seems as though SQL Server likes to have 4 decimal places for the money datatype, but is there any way in the settings of this table or that money field to change this to 2? I know how to programmitically trim the last two zeros, if I can manually set something so I don't have to do this every time I retrieve the money datatypes from the database table.
View 3 RepliesHow To convert String Data Type to Smalldatetime field in vb.net
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
<Conversion failed when converting the varchar value 'ID' to data type int.>am trying to insert datavalueField for a drop down list into a table column, its type is int. am using this syntax
[Code]....