Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : SQL Server question

[creativeartist]

2 questions related to SQL server

How to get the id of current inserted row using SQL server?

Procedure or view which will be fast for a (select * from operation)

[REMX]

INSERT INTO Users (FirstName) VALUES ('John');
SELECT ID AS LastID FROM Users WHERE ID = @@IDENTITY;

Or you can just use

SELECT @@IDENTITY

Not sure about the second one sorry

[plumsauce]

The indexing will determine what works best for a select.

select * is a very bad idea, always explicitly select columns by name

[CoderJosh]

Originally Posted by plumsauce

select * is a very bad idea, always explicitly select columns by name

Indeed, you should really avoid this.