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 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...

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...

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 @@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

Could someone tell me why my execute statement gives me an error 'Error converting data type nvarchar to datetime.' Here's the statement: execute insert_Contact1_1 'A50824380140',getdate The first field is a nvarchar data type and second is a date type. Somehow it does not recognize the...

I am trying to test the IIF statement and it does not work. select iif(isnull(regions),'A','B') from customers Could someone help me on this?

I used the DTS Import wizard to import data from Microsoft Accesss. In one of the tables , I have column(lastdate) which is of Date type in Access. When i import this to SQL server it gives me an Overflow Error. I am importing this field as a DateType field in SQL. It works when I change the...

I would like to backup the Transaction Log of my database. When i do a backup I see the Transaction log option is grayed out. I read that I need to change the recovery model of the Model database. How could i do this? Thanks in advance.