Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
How to get integer and string records from the existing table in sql server?

Posted On: 03/10/2012 19:13:56

To get only integer records SELECT * FROM TableName WHERE ISNUMERIC(ColumnName) = 1

To get non integer records. SELECT * FROM TableName WHERE ISNUMERIC(ColumnName) <> 1

MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us