check for any triggers on that table.

per BOL

http://msdn.microsoft.com/en-us/library/ms177523(v=SQL.90).aspx

WHERE

Specifies the conditions that limit the rows that are updated. There are two forms of update based on which form of the WHERE clause is used:

Searched updates...

itskumar2004 (9/29/2010)

---

Hi all,

I have table with name ABC

Table ABC:

columnname datatype

ID ...

BOL:

ntext, text, and image data types will be removed in a future version of MicrosoftSQL...

I was adding more examples to try and get the true requirement. 123.987, is that supposed to be 123.9? Make sense?

So,

123 is 12

123.987 is 123.9

0.91 is 0.9

.123 is .12?

Or, are you really after something like, get rid of...

inner join

Richard Holloway (9/15/2010)

---

I have two databases I need to join on. Issue is the project number on one is missing fist two digits. I need to append to...

INNER JOIN AfsMembership.dbo.aspnet_Roles aspnet_Roles1

ON aspnet_users1.ApplicationId = aspnet_Roles1.ApplicationId

...

The...

made2lastjj (9/10/2010)

---

I Need to compare two columns [PROP_FL_DT] < [PROP_MT_DT]

One Column is Varchar Data Type, the other is Date

the varchar data Type is mixed with Null, Date structure like '04/05/2010'...

How is this going to be used? Usually formatting...

SKYBVI (9/7/2010)

---

@cory

I couldnt get you?

Where should i write the tsql?

theres no option when i go thru data, external data source,sql server

it just asks for selecting the table and then...

SKYBVI (9/7/2010)

---

@ cory

Ya, If we go to data

then external data sources , we can get data from sql

but that data we get is inside the tables, i mean the columns,...

SKYBVI (9/7/2010)

---

Hey,

We are creating a documentation of our all databases and their tables, procedures,triggers etc.

We are making an excel file and writing all the...