SQL server has some drastcally different techniques than one would use on MySQL. Here are the resources I have used to power through the projects I am assigned.
Truncation of insert when too large for field doesnt happen in SQL. It causes an error and the transaction is canceled.
http://www.mssqltips.com/sqlservertip/2857/silent-truncation-of-sql-server-data-inserts/
Here are the filter conditions for queries: http://msdn.microsoft.com/en-US/library/k58xx95s%28v=vs.80%29.aspx
The “text” datatype has been depriciated, need to use varchar(max)now.
to change a fields datatype definition.
ALTER TABLE dbo.YourTableHere ALTER COLUMN YourTextColumnHere VARCHAR(MAX)