| Author: Anil Kumar Pandey 04 Nov 2009 | Member Level: Diamond | Rating:  Points: 2 |
suppose i want to check the ID value then get its count..
Select count(*) where Id=10
if it is grater than 0 means the value is already present and if it is 0 you can use INSERT statement.
Thanks & Regards
Anil Kumar Pandey
|
| Author: Lalji 04 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
try this link
http://blog.ysatech.com/post/2009/08/11/How-to-check-if-column-exists-in-SQL-Server-table.aspx
|