Method to update LOB data with minimal log
Use the .WRITE (expression, @Offset,@Length) clause to perform a partial or full update of varchar(max), nvarchar(max), and varbinary(max) data types. For example, a partial update of
Category: sets
Data types
Data types and Precedence of convert types SQL Server associates columns, expressions, variables, and parameters with data types. Data types
Temporary Tables
Sometimes we need to use temporary tables to do aggregations, joins or to simplify the job. SQL Server supports a
The Meaning of “Set-Based”
The term set-based is used to describe an approach to handle querying tasks and is based on principles from the
Structured Query Language
By a “set” we mean any collection M into a whole of definite, distinct objects m (which are called the
Thinking in Sets
Thinkins in sets is a great book by Joe Celko’s. This book tell us about concepts how we need to
