Thanks Thom,

But this would just disappear the warning. Let me make it more clear about what i am looking for

create table TEST_INSERT
(id...

Lynn Pettis (8/8/2014)

---

funooni (8/8/2014)

---

Lynn Pettis (8/8/2014)

---

There are other issues with your query, but lets not worry about that just yet. Another question, what edition of SQL Server are you...

Lynn Pettis (8/8/2014)

---

There are other issues with your query, but lets not worry about that just yet. Another question, what edition of SQL Server are you running?

Also, is the...

Jeff Moden (8/8/2014)

---

I have to get to work but here's a 60,000 ft view of what I would do...

1. DO A FULL BACKUP!!!!!!!!!!!!

2. MAKE SURE POINT-IN-TIME BACKUPS ARE...

Ahan , so that's why it did not go the way I thought. SSMS entire query is getting rolled back

When I cancelled the Running Query, shouldn't the SQL Server rollback only the rows of last transaction. But it is rolling back the rows which are deleted and committed in...

around 150 million rows will be kept i.e. last three months data.

I am thinking about taking those rows into another table and then truncating/dropping the table and renaming the actual...

Hi guys,

Linked server can be used to insert data from SQL SERVER 2005 to Oracle. However, you need to install Oracle's Data Access Components installed on the same system having...

No it gives the same error message

however i was just trying some commands and i found that the following works and returns all the tables.

exec sp_tables_ex @table_server = 'ORCNOTNS'

I...

Hi

Did anyone solve the problem? i tried using .Net framework 2.0 but still its the same error and my assemblies are not created.

My dll is very simple just contain mathematics...

Hi

Can you please give me some tips about posting the data from SQL Server 2005 to Oracle?

I need to populate a table in Oracle on an hourly basis.

I...

Thanks to all.

Concepts cleared.

All marks go to Lutz 😉

Well i just checked it and it does work.

The DAY built-in function returns just the day date part of the supplied...

Going further from Eralper's idea;

You can use

select DATEPART(WEEK,DAY(getdate()))

to get the week of the month.

GETDATE() can be replaced by any datetime variable or even a string like '2010-12-07' ;...

Hi there

Well it seems that you need to study some XML stuff

Check this link as well

As far as your query , i have just done a test and here's...