Hi,
What is the best way to convert data from ASCII file (numeric) into currency or float (and write him into SQL table)? Some user have different regional settings (point, comma, ...)?
Please, I need some tip....
Tnx, DaT
Hi,
I have a little stupid problem. I need transfer data from txt file (using visual basic application) direct to SQL table. The Date field in TXT table is in yymmdd format (for example: 051103). When I write into SQL data over ADO and convert date field into next format: '11/03/2005', I get in...
Hi,
I have a little stupid problem. I need transfer data from txt file (using visual basic application) direct to SQL table. The Date field in TXT table is in yymmdd format (for example: 051103). When I write into SQL data over ADO and convert date field into next format: '11/03/2005', I get in...
Hi,
i have realy silly problem. I create database in MS Sql server with wrong collation. I have to many tables in database; all tables are created with wrong collation. Have somebody idea how to change collation in all tables, not to manual changing fields in all tables?
Please, help me, my...
Hi,
i have realy silly problem. I create database in MS Sql server with wrong collation. I have to many tables in database; all tables are created with wrong collation. Have somebody idea how to change collation in all tables, not to manual changing fields in all tables?
Please, help me, my...
Hallo.
I have a little problem in MS Sql server. How cann i check when temporary table exist? I create more temp tables (create table #test_table ...) under some Sql connection; how cann i know, that this table not exist in connection?!
Please,help!
DaT
Hallo,
i need help. I have a writen a simple VB aplication to replicate a recordset from one server to another. I use ODBC connect to all servers. It's possible to geth information from the Server before i have open a connection to this server. In case, that server is not accesible, i geth...
Hi,
i need some sample, how to input a checkbox into datagrid. I use VB 6 wiht Datagrid control to get a recordsed from MS SQL Server. i need to give a user posibility to check some rows, and then, i will make some action only for checked rows.
Have a somebody a idea, how to handle this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.