Wednesday, 7 September 2011

SQL SERVER some System Defined Important functions

Select db_id('master') // Get order of that Database 

Select db_name(4) //Get a 4th order of name in a database

Select isdate('02/31/2005') //Date is availabe or not Here 
output comes '0' or '1' 

Select isnumeric(15s) // Value is mumeric or not Here output comes '0' or '1'

No comments:

Post a Comment