IN Oracle we can Use Rowid.. I need Sql Server equivalent and
IN Oracle when we insert a record and then select it is display in the last
records.
I Need same in sql server how to make same features.
Selva,
Possibly IDENTITY (CREATE TABLE) or NEWID(). Not sure what the Rowid does
in Oracle.
HTH
Jerry
"Selva" <Selva@.discussions.microsoft.com> wrote in message
news:ED62696B-B651-41FC-B1CC-AF08BFEE3F35@.microsoft.com...
> IN Oracle we can Use Rowid.. I need Sql Server equivalent and
> IN Oracle when we insert a record and then select it is display in the
> last
> records.
> I Need same in sql server how to make same features.
sql
Showing posts with label lastrecords. Show all posts
Showing posts with label lastrecords. Show all posts
Wednesday, March 28, 2012
Rowid-insert a record
Labels:
andin,
database,
display,
equivalent,
insert,
lastrecords,
microsoft,
mysql,
oracle,
record,
rowid,
rowid-insert,
select,
server,
sql
Rowid-insert a record
IN Oracle we can Use Rowid.. I need Sql Server equivalent and
IN Oracle when we insert a record and then select it is display in the last
records.
I Need same in sql server how to make same features.Selva,
Possibly IDENTITY (CREATE TABLE) or NEWID(). Not sure what the Rowid does
in Oracle.
HTH
Jerry
"Selva" <Selva@.discussions.microsoft.com> wrote in message
news:ED62696B-B651-41FC-B1CC-AF08BFEE3F35@.microsoft.com...
> IN Oracle we can Use Rowid.. I need Sql Server equivalent and
> IN Oracle when we insert a record and then select it is display in the
> last
> records.
> I Need same in sql server how to make same features.
IN Oracle when we insert a record and then select it is display in the last
records.
I Need same in sql server how to make same features.Selva,
Possibly IDENTITY (CREATE TABLE) or NEWID(). Not sure what the Rowid does
in Oracle.
HTH
Jerry
"Selva" <Selva@.discussions.microsoft.com> wrote in message
news:ED62696B-B651-41FC-B1CC-AF08BFEE3F35@.microsoft.com...
> IN Oracle we can Use Rowid.. I need Sql Server equivalent and
> IN Oracle when we insert a record and then select it is display in the
> last
> records.
> I Need same in sql server how to make same features.
Labels:
andin,
database,
display,
equivalent,
insert,
lastrecords,
microsoft,
mysql,
oracle,
record,
rowid,
rowid-insert,
select,
server,
sql
Subscribe to:
Posts (Atom)