Search results for query: *

I have created the following Activexdll in vb6: Class: our_csharp Public Function Show() MsgBox ("Message box created by using Visual Basic") End Function I have compiled the above project and set the porject compatibility to Binary. Now when i invoke this from asp.net(set...

hi, How could I extract only the date from a Datetime field? Example: "12/22/2005 12:00:00" I need only 12/22/2005. thanks in advance.

Hi, I want like to create a package which would export data to a word document. I don't see this option under the DTS wizard. Is it possible to import/export to word? Thanks

Hi, I want to create a package which would export data to a word document. I don't see this option under the DTS wizard. Is it possible to import/export to word? Thanks

I wanted to know if this the following task was possible using DTS. I have database "MMX". I have couple of tables in it. I want to execute a series of queries in the current database to populate a table. Can i achieve this using a DTS package. If so how? I have no data transfer from one...

I need to convert this Access query to SQL. There's no DistinctRow keyword in SQL. Could someone help me on the syntax? UPDATE DISTINCTROW IRtest SET IRtest.[File #] = Right([File #],6); Thanks

I need to convert this Access query to SQL. There's no DistinctRow keyword in SQL. Could someone help me on the syntax? UPDATE DISTINCTROW IRtest SET IRtest.[File #] = Right([File #],6); Thanks

Hi, I wanted to know if there's any way to execute a bunch of queries in the DTS Package. I use the execute SQL Task to run the queries against a database. But I would like to run 15 queries all at once very similar to the Batch process. Basically wanted to know if I could have a series of SQL...

Hi, I am creating a package to transfer data from MS Access to SQL Server. I used the connection object to specify the Source and Destination. I know the Transfer Data task would transfer data from each of the tables from Ms Access. However I wanted to know if the DTS had the capability to...

Hi, I am creating a package to transfer data from MS Access to SQL Server. I used the connection object to specify the Source and Destination. I know the Transfer Data task would transfer data from each of the tables from Ms Access. However I wanted to know if the DTS had the capability to...

Hi, I found the problem. These fields were already defined in the table. so please ignore this post. Thanks Hlpch

Hi I want to Alter couple of tables and add a new column "Lastupdated". Here' what I did. Create Procedure [Sample] As ALTER TABLE[Test] ADD LastUpdated DateTime NULL go ALTER TABLE[Test1] ADD LastUpdated DateTime NULL go ALTER TABLE[Test2] ADD LastUpdated DateTime NULL Go The above...

Hi, Could some tell me the syntax to change the backup settings to Full Recovery mode? My Transaction log button is disabled and I guess if I change the Recovery mode to Full ,I could activate this option. Alter database Test < recovery_option > ::= RECOVERY { FULL } I tried the above...

Thanks. It worked. CS

Hi, Could someone tell me what function I need to use to get the system Time? I know that the Getdate() only gives the currentdate plus time. But I only need the time portion in the format hours:minutes:seconds Thanks CS

I have a stored Procedure with couple of Insert statements. Insert into Contact1(field1,field2)values(value1,value2) Insert into Contact2(field1,fields2)values(value1,value2) Both the tables contact1 and contact2 have an Identity field. My insert fails because at a given time I could only set...

Great.Thanks for all the replies.

Hi, I have couple of insert statements in the stored procedure. After i execute the stored procedure, how could i check if each one of them were successfull? Basically i want a flag inside the stored procedure which gives me the status of the updates. Thanks

Select ident_current('orders') The above gave me the last generated number. Thanks. I tried this on the orders table located on the Northwind database.

Select @@identity as orderid from orders. I tried executing this and no value came up. I tried it on the Northwind .Orders.How could i get the last generated number? Thanks