Category Archives: Microsoft SQL Server

Text data type can not be ordered or unioned

It was astonished for me that databases like MS SQL and Sybase do not support ordering and union by columns of the TEXT type (and some other data types, in short big data blobs). It seems the reason is logical. … Continue reading

Posted in Microsoft SQL Server, Sybase | Leave a comment

Unary Negative in MS SQL

Occurred that ┬áMS SQL also is not so perfect. Recently I was pointed to rsdn.ru where was shown a mathematical feature of the MS SQL: ref A. SELECT 20.0 / -2.0 / 5.0 * 3.0 results into -16.666666 ref B. … Continue reading

Posted in Microsoft SQL Server | Leave a comment

Drop a sql schema with its referencing objects

As you may know if you want to drop a schema in sql you have to drop all its objects by hands first (tables, views, procedures, functions). Of course this restriction is essential to avoid loosing of data. But if … Continue reading

Posted in Microsoft SQL Server, T-SQL | Leave a comment

dm_sql_referenced_entities and aliases

sys.dm_sql_referenced_entities is a system function of Microsoft SQL Server that allows to get dependencies which an object has. E.g. you can find out what tables and store procedures are used within a body of a stored procedure named ‘dbo.foo’ you … Continue reading

Posted in Microsoft SQL Server | Leave a comment