mike-939611 (8/26/2010)

---

ContentTitle varchar(128)

ContentTags varchar(128)

ContentShort1 ...

sqlusers (8/27/2010)

---

Hi,

In our Production database, sometimes back the data getting duplicated because of not deleteing the old records. At now only we have come to know that the data gets...

Do you have another server available? a test server?

Please go there, create table, populate a couple of rows and run update.

Log whole session and post.

jadeite100 (8/27/2010)

---

I am using Microsoft Sql 2005. I ran my ddl scripts in "Microsoft SQL Server Management Studio" and when the script

is completed and successfull, all I get is the...

zakariye88 (8/26/2010)

---

I have been IT field more than 10 years now -- mostly Networking and Server administration (both Linux and Microsoft servers). I am planning to become SQL administrator. I...

S Hodkinson (8/26/2010)

---

Sorry for the delay; I was waiting for a colleague to return from leave.

With the help of my colleague, we have got to the bottom of this.

When you...

tomiboy59 (8/26/2010)

---

So restarting it once a week does not help. I did a manual reboot today, and when my coworker tried to run a report later that day he got...

... meaning? :blink:

zhtway (8/24/2010)

---

I have table1 and table2 and wants to MOVE the selected (on condition) rows from table1 to table2 when the condition meets.

Which method is the best? Trigger method or...

Clustered/Non-Clustered

For sure it will be a non-clustered one.

Unique/NonUnique

In general I wouldn't expect to get duplicates on SSN... but, you...

Ninja's_RGR'us (8/23/2010)

---

That's about it, been googling for 1 hour and I found nothing besides the native windev Hyperfile sql which allows us to open the tables.

Is there any way to...

Is this homework? what do...

ALI-408105 (8/23/2010)

---

I am looking for one page image to show what happens when a query is submitted. Showing the difference between dynamic sql and stored proc will be a plus.

I...

abe.nito (8/22/2010)

---

I just want to know what would be the best dbms to use? especially for a new business or company. just really something that endusers would find easy to...

EdVassie (8/23/2010)

---

The world's most popular database by a long long way and well known as easy to use by end users is Excel.

The world's most troublesome database system for people...