Search results for query: *

suppose I have 2 forms. I need to call 2nd form from 1st form. when frm2.show() is given, I want to disable frm1. and when frm2 is closed, i need to enable frm1 again. How do I do this?

Can anyone pls tell me how to output contents of a table in sql server into a excel file pls

i have a table with one field set as autonumber. if i want to insert records into this table from another table using sql, insert into table1 select * from table2 will the autonumber field be updated automatically? how exactly should i give the sql to insert all the fields in table2 into...

can someone tell me the logic to use for this problem i have a table with about 1000 records. each record has many detail fields and an amount field. when the user gives a particular amount ,say 10000, i want to find all combinations of records in this table which will give me a sum of exactly...

my pc was upgraded from nt to xp. and now when i try to export from access to excel files, it is just not happening. can anyone please tell me what the problem could be and how to solve it.

can someone please help me with this problem i have a table with about 1000 records. each record has many detail fields and an amount field. when the user gives a particular amount ,say 10000, i want to find all combinations of records in this table which will give me a sum of exactly this...

using the package and deployment wizard, i've made a package of my software which uses Microsoft Scripting Runtime. when i install from the package, it says, cannot copy msvcrt.dll because it's in use. close all other applications. no other applications were open. when i ignored this message...

if i have a table in which the combination of 2 fields are supposed to be unique, thru an sql, i need to find the records which have these 2 fields with the same value, how can i do this?

if i have a number 0027 and i want it to have a length of 8 by adding 0s in front like 00000027, then what do i do? in oracle there is a function rpad. in sql server, is there any way to do this?

i export records from tables into excel files thru vb6. the code used is ********************* Dim rs1 As ADODB.Recordset Dim objFiled As ADODB.Field Dim objApp As Excel.Application Dim objBook As Excel.Workbook Dim objSheet...

how can i get the characters in a string to the 1st hyphen to 3rd hyphen in string eg:- if string is 345-895454-534443-3454354-4543 i need to get 895454-534443 can anyone please help

if there are about 1100000 records in a table of one database and i try to copy them into another table of another database, how long would it ideally take?

i have 2 tables in 2 different databases in sqlserver. i need to copy all records of one table in one database into another table of another database. now, i'm doing it this way...... 1)i copy all records of 1st table into one recordset using a connection to 1st databse and then, i close...

i need to concatenate a varchar field with a float field. for that i need to convert the float field to varchar using cast as follows select rtrim(sgln_description) + cast (round(sgln_blockamt,3) as varchar(30)) from table1 this works fine but when the values stored in float are very large...

i have a text file with about 60,000 lines. i need to transfer the records in the text file into 2 tables depending on whether the value of the field "product" is amoung the products of a master table with about 15 records only.the way i'm doing it now is as follows thru vb6 1)i upload all...

in my sql server database, when i have more than 100,000 records in a table, and i try to delete most of the records or all the records of that table, i get an error saying the transaction log is full and i need to empty it. if the number of records are not much, this doesn't happen. what could...

can anyone tell me how i can convert a number which is supposed to be a duration in seconds to look like hour:minute:second format

can you tell me the function in sql server which serves the purpose of lpad of oracle in oracle, lpad(x , 5 , '0') would return x always as a string of length 5 characters even if it's original length is lesser. 0 will be appended to it's left if it is of shorter lenght

in oracle trunc( x / 3600 , 0) returns the quotient alone of x when divided by 3600. but since trunc doesn't work in sql server, how do i get the quotient alone when a number is divided by another number

can anyone please tell me the code to export data from a table in sql server database to an excel sheet? using ado ideally. anything else otherwise