2
Answers

Select query without identy column

Abdu Rafeeq

Abdu Rafeeq

13y
1.3k
1
 i want  Select query without identy column..

can select data without identity column data?
Answers (2)
0
Suthish Nair

Suthish Nair

NA 38.4k 4.6m 13y
another duplicate
0
John Penn

John Penn

NA 4.2k 134.4k 13y
Yes.  You can create a select query that specifies the columns you want:

SELECT FirstName, LastName FROM Person

If "Person" has an identity column, you won't see it in the resultset.