Monthly Archives: April 2014

Determine a Varchar field containing any numeric data

Select * From [TableName] Where [ColumnName] Like ‘%[0-9]%’

Posted in WildCard Search | Leave a comment

ALTER DATABASE Compatibility Level (Transact-SQL)

ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = { 90 | 100 | 110 } Arguments database_name Is the name of the database to be modified. COMPATIBILITY_LEVEL { 90 | 100 | 110 } Is the version of SQL Server with which … Continue reading

Posted in Uncategorized | Leave a comment

Port for Sql Server

TCP/IP port numbers are which Microsoft SQL Server requires to communicate over a firewall. The default SQL Server port is 1433, and client ports are assigned a random value between 1024 and 5000.

Posted in Uncategorized | Leave a comment