sqldatatypes
ADO Data Types (adParamInput vs adParamOutput)
Can somebody please tell me what the difference is between adParamInput and adParamOutput? I\'m using parameters in a Classic ASP/MySQL environment.[详细]
2023-04-12 21:07 分类:问答Mapping java.long to oracle.Number(14)
I have db column whose datatype is Number (15) and i have the corresponding field in java classes as long. The question is how would i map it using java.sql.Types.[详细]
2023-04-10 01:42 分类:问答Datatype/structure to store timezone offset in MySQL
Which would be the proper datatype/structure to store timezone offsets in MySQL? I just want to store the numeric value (the city and countr开发者_如何学Goy are obviously stored in other columns).[详细]
2023-04-09 17:27 分类:问答Can I get types from an arbitrary query in Postrges?
I\'ve got a situation building a data analysis tool where my users can write SQL query (including joins, calculations, etc) and I need to be provide options to the user based on the data types of the[详细]
2023-04-07 23:58 分类:问答How to send a table-type in parameter to T-SQL while using C# IDataReader?
I wrote a t-sql sp that gets a table as parameter. I tried to call it from c#, but didn\'t know what type to use:[详细]
2023-04-07 15:46 分类:问答Is there a CLR data type to Sql data type translation method?
I was going through the MVC material over at asp.net, and came across the 5 minute introduction video:[详细]
2023-04-07 01:00 分类:问答How to get the SqlType of a column in a DataTable?
I have a DataTable obtained from a SQL DataBase, like this: using (SqlCommand cmd = new SqlCommand(query, _sqlserverDB))[详细]
2023-04-06 08:36 分类:问答SQLServer choosing primary key type
I have a list of objects each of its own id and I need 开发者_如何学Goto create a table for them in a database. It\'s a good idea to use their ids(since they are unique) as a primary key in the table[详细]
2023-04-05 07:12 分类:问答Save video stream into the database's table
I want to save a stream video into my database, I want to know what data type in SQL-Server is suitable to save video开发者_如何学运维 stream ?[详细]
2023-04-02 09:46 分类:问答Column with Numeric DataType returns a value with decimal upon using Crystal Report
SQL Server 7.0 VB 6.0 Crystal Report 8 Column Name: myColumn Data Type: numeric Length: 9 Precision: 10[详细]
2023-04-01 19:15 分类:问答