Auto Primary Keys in View

[smartaju420]

Hello Friends,

I've a table with no primary key. I want to create a View based on that table but I want a auto increamenting primary key in this View.

Does anybody know how to do this?

Plz help me..

Thanks in advance...

[ck9663]

Hello Friends,

I've a table with no primary key. I want to create a View based on that table but I want a auto increamenting primary key in this View.

Does anybody know how to do this?

Plz help me..

Thanks in advance...

Two things you need.

1. Here's the syntax to create view.

2. Your query inside your view can include a dynamic row number. Here's how you do that.

-- CK