In sql server create insert/update/delete triggers that insert primary keys and operation kind of changed records into a log table. Create and application that reads this log table joined to...

Maybe because he/she means the broader meaning of cursor.

Every select creates a cursor.

Comparing two tables is IMHO a bad solution, because over time there will be a lot of differences,...

Jeff Moden (3/28/2008)

---

Not quite... A table valued (table variable) UDF returns a memory table just like a temp table does... if the server decides it's getting too big, it jumps...

I knew it! 🙂

Well, with decimal the range matters, with float a lot less.

So, if you use calculations like this, you must use greater precision than 6.

DECIMAL(38,36) will give you...

Maybe by first learning relational database basics?

The error means you're inserting a primary key value that already exists in the table.

Kevin Durham (3/28/2008)

---

Thanks rbarryyoung,

You confirmed what I feared was true from what I had read elsewhere. If REAL only holds 7 digits, and the other 15 are lost, I have...

That's what they say, but is not necessarily true.

Try this:

create view dbo.vw_test1

as select 1 as A, 234234.234234 as B

go

create view dbo.vw_test2

as select * from dbo.vw_test1

go

select * from dbo.vw_test1

go

select * from...

Matt Miller (3/28/2008)

---

In the case of an un-indexed view, the view is never compiled on its own. The text of the VIEW gets inserted into the outer query calling...

Just noticed my posts were too bare bones.

So, views are preferable for several reasons:

- they're highly portable

- they're simpler

- server can better optimize query based on view as view is...

Of course, however, view plan is combined into query plan.

Derek Dongray (3/28/2008)

---

Actually, I thought it was poorly worded in a different way.

To me, the phrase "Only SQL Server 2000 SP3 or later" implies that SQL Server 2000 SP4 is...

Use functions/procedures only if your goal can't be done with view.

If it can't be done with view, you can use:

-stored procedure that returns resultset, if it's passed to client

-function returning...

Yet another poorly worded question.

You can't use "SQL Server 2000 SP 3 or later" or other older versions to upgrade to

SQL Server 2005.

You use "SQL Server 2005"...

column name is nvarchar, not varchar. nvarchar is unicode. UTF8 can have 1, 2 or 3 bytes per character, where lead byte determines how to decode other bytes. So, right()...

Are you sure they're all ansi chars?

Right() might count bytes or chars from right.