Find Colum present in the table or not

Hi,

 

if((select @count=count(*) from sysobjects tab,syscolumns col where col.id=tab.id  and tab.Name=<tablename> and col.name=<columnname>)>0)
begin
              print 'Column present'
end
else
begin
                  print 'Column not present'
end

 

Regards,

Sasikumar D

 

Direct - +91 80 41041751

Mobile - +91 9986080299

iGATE is Ranked No. 3 in DQ-IDC best IT employer survey and Ranked No.6  by Business Today-Mercer Human Resource Consulting-TNS  in a cross industry survey of Best Companies to work for in India ----------------------------------------------------------------DISCLAIMER--------------------------------------------------------- Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual  or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under  applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or mailadmin@igate.com  and delete this EMAIL including any attachments

System restarts after i install Windows XP Service Pack 3

Good news is that Microsoft had released a service pack 3 for windows xp. as usual it comes with some problem . a week before i installed the service pack 3 after that it ask me restart then the problem starts it will boot and come till the welcome screen and then it will restarts .... even when i try thought the safe mode and all other modes which they had given nothing works .. then as usual gooooogleeee.. and found the solution , that’s is due to versioning problem to solve this

Put your windows cd and boot in repair mode and then copy the file gdi32.dll from c:\windows\servicepackfiles\i386\ to c: \ windows \ system32\ before coping this file make a backup of this file in c: \ windows \ system32\ this location and reboot it It works