arthi.anan (10/24/2012)

---

Thanks a lot...

I got it right..

Here in this procedure i have a problem with date formats. In my data the format is DD-MM-YYYY (13-Aug-1951)

I should declare in my temp...

Nice question!

--

-- Side Effects:Import/Export of BLOBS

--

--This code is copyrighted and has-- limited warranties.Please see http://

-- http://www.1SQLStreet.com/xq/ASP/txtCodeId.498/

-- lngWId.5/qx/vb/scripts/ShowCode.htm--for details.--**************************************

-- ...

You have your table with...

Nils Gustav Stråbø (10/19/2012)

---

Aaaaarg!!! Got it wrong because of the unclustered index options.

I know that SQL Server enforces unique constraints by creating unique indexs, but I wasn't sure if this...

Solution with set-based statement

select * from temp

insert into employee(employee_id,first_name,middle_name,last_name,title,sex)

select employee_id,first_name,middle_name,last_name,title,sex

from temp

insert into employee_details(employee_id,from_date,to_date,grade_code,manager_id)

select employee_id,from_date,to_date,grade_code,manager_id

from temp

select * from employee

select * from employee_details

Regards

IgorMi

Hi,

Try this worked fine on my local database.

CREATE TABLE [dbo].[temp](

[employee_id] [char](7) NOT NULL,

[first_name] [char](50) NOT NULL,

[middle_name] [char](50) NOT NULL,

[last_name] [char](50) NOT NULL,

[title] [char](5) NOT NULL,

[sex] [char](1) NOT NULL,

--add here more...

Very good question!

IgorMi

Hi,

There are too many tools for that. If you need it for some days just download a trial and compare databases you need. It is more visible and...

Oh, I needed it once and used it. It was working fine, but i didn't keep on digging about the dis/advantages...

If you find out something please share it...

Thanks

IgorMi

Hi,

You have plenty of them. Find them on

http://www.red-gate.com/

http://www.idera.com/Content/Home.aspx

http://www.quest.com/

...

Some are free, some are trial and/or restricted with functionality...

you can find articles about monitoring server performances...

Hi,

Yes it is. Check this article: http://www.sqlservercentral.com/articles/MySQL/88366/

Regards

IgorMi

beebkhan (10/18/2012)

---

to the reply from igor to my post earlier. I didnt say delete the table. I was talking about removing the referenced data e.g

Table A

TableAID int PRIMARY Key IDENTITY(1,1),

data...

beebkhan (10/17/2012)

---

you need to find the table that is referencing the data in your rolemaster table and remove it before you remove it. otherwhilst you will have a lot of...

Hi, check you use a user that has rights on the table you're trying to update.

declare @sql varchar(1000)

SET @sql = 'UPDATE TableA SET image_name = ''NewName''...