What is the keyword for record no
Database
3
Posts
2
Posters
0
Views
1
Watching
-
Hello, I want to write a query something like the following UPDATE INCOMETABLE SET NAME ='PETER',AGE=30 WHERE RECORDNO = 10; In the above what should be the keyword of RECORDNO or there is another way of writing it THANKS Prithaa
Hi, There is not such a keyword in Sql Server. (There is one in Oracle, but it's a bad practice to use it in such a case) What you should do is to use a primary key in the INCOMETABLE table.
UPDATE INCOMETABLE SET NAME ='PETER',AGE=30 WHERE EMPLOYEEID = 10Uri
-
Hi, There is not such a keyword in Sql Server. (There is one in Oracle, but it's a bad practice to use it in such a case) What you should do is to use a primary key in the INCOMETABLE table.
UPDATE INCOMETABLE SET NAME ='PETER',AGE=30 WHERE EMPLOYEEID = 10Uri