MSSQLTips

Hi, I want to trnasfer data from one database to another at regular interval. This should be also automated. Example: Database A and Database B Both database are identical. I want to transfer data from Database A to Database B. So everytime if there is any entry in Database A it should also make that...

Hi, I wanted to split one column data into 3 column data. Example: TABLE NAME: TRY Column Name: Full Name Data: ABCD XYZ S TO TABLE NAME: TRY1 Cloumn Name: FirstName LastName MiddleName Data: ABCD XYZ S Please let me know the sql statement that I have to run. Thank you in advance.

I wanted to know if we can automate the SQL process at particular time everyday sending an email with Excel Document attachment. I have a SQL Statement which will provide a particular result, which I want to see and would like to email directly to xyz, abc person automated process in excel format. Please...

Hi, I have taken the full backup of ABC database from SQL Server 2005 and I want to restore in SQL Server 2000. But I am not able to restore, it gives me an error 3241: The media famil on device 'D:\...\ABC.bak' is incorrectly formed. SQL Server cannot process this media family. RESTORE FILELIST...

Hi, I have one table and need to move all data to other 3 tables in different database tables. Eg: Database: ABC TableABC 1 - (Last Name, First Name, Address, Phone No.) to Database: XYZ TableXYZ 1 - (Last Name, First Name) TableXYZ 2 - (Address, Phone No). In TableXYZ 1 and TableXYZ 2 there are also...

dguillory, Have you tried the code in this tip - http://www.mssqltips.com/tip.asp?tip=1070 . Thank you, The MSSQLTips Team

Thanks for the reply again!!! Ok Sir let me say in detail what we want. The table is filled by one application and after it fills other application comes and starts accessing the records. In this application we are having multiple threads to make the process fast and it does not matter how the records...

Thanks for the reply. I need the select statement as I need that record in my application so I need the select statement. And sir right now my table doesn't have any primary key nor the clustered index. I need to get the record from the table based on the PersonName and not the primary key. The table...

Thanks sir for your reply. I have used rowcount because i'm having in mytable one lakh record and I want to use just 5 records per thread and for the same I'm going for multi threaded application and hence I'm using rowcount so that it will retriev just five or one records depending onthe...

Hi all, I'm using SQL 2005. I want to establish a lock in the select statement. For the same i've made a procedure as follows: " CREATE procedure [dbo].[Select_SendNo5ByPersonName](@PersonName nvarchar(50)) as begin set rowcount 1 select * from SendNo where PersonName = @PersonName delete...