If the field is already a string, this will work If you want nulls to show as ‘000’ It might be an integer — then you would want As required by the question this answer only works if the length <= 3, if you want something larger you need to change the string constant and … Read more
If you only want to return a few characters of your long string, you can use: See SQL Fiddle with Demo. This will return the first 15 characters of the string and then concatenates the … to the end of it. If you want to to make sure than strings less than 15 do not … Read more
should work
M.Ali’s answer could be modified as
You will need to post the table definitions for the source and destination tables for us to figure out where the issue is but the bottom line is that one of your columns in the source table is bigger than your destination columns. It could be that you are changing formats in a way you were … Read more
For queries like this it is always best to use an INFORMATION_SCHEMA view. These views are (mostly) standard across many different databases and rarely change from version to version. To check if a table exists use:
Try this and See CAST and CONVERT (Transact-SQL) for more details.
It means that no rows will be returned if @region is NULL, when used in your first example, even if there are rows in the table where Region is NULL. When ANSI_NULLS is on (which you should always set on anyway, since the option to not have it on is going to be removed in the future), any comparison operation where (at least) … Read more
How to delete all the records in SQL Server 2008?
It is a batch terminator, you can however change it to whatever you want