Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
Trim Function
–FOR SQL SERVER 2000: –FOR SQL SERVER 2005: Source: http://blog.sqlauthority.com/2007/04/24/sql-server-trim-function-udf-trim/
Latin1_General_CI_AS Error
Error: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. When you run into this error simply add “COLLATE Latin1_General_CI_AS” after the column name(s) that you are selecting or comparing and it will work.
Insert Into Table From Another Table
If the two tables structure match you can do this command
You must be logged in to post a comment.