`TRIM` is introduced in SQL Server (starting with 2017).

In older version of SQL Server to perform trim you have to use `LTRIM` and `RTRIM` like following.

    DECLARE @ss varchar(60)
      SET @ss = &#39; admin &#39;
    
      select RTRIM(LTRIM(@ss))


If you don&#39;t like using `LTRIM`, `RTRIM` everywhere, you can create your own custom function like following.

 

       CREATE FUNCTION dbo.TRIM(@string NVARCHAR(max))
        RETURNS NVARCHAR(max)
         BEGIN
          RETURN LTRIM(RTRIM(@string))
         END
        GO

Perhaps it&#39;s set to an earlier compatibility level. 

Use this to find out: 
    
    SELECT compatibility_level FROM sys.databases

SQL Server 2017 is _140_

If it&#39;s any lower then it won&#39;t recognize `TRIM`

To change the compatibility to SQL Server 2017

    ALTER DATABASE database_name   
    SET COMPATIBILITY_LEVEL = 140

For a list of supported compatibility levels for each SQL Server version check out  [ALTER DATABASE (Transact-SQL) Compatibility Level.][1]


  [1]: https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-2017

Based on comments below, your installed version of SQL Server is SQL 2016. You need to install SQL Sever 2017 to get `TRIM`

You can use this code for older versions:


    SELECT RTRIM (LTRIM (&#39; JKL &#39;)) AS Trimmed

Which results in `&#39;JKL&#39;`

I have a problem when adding components to the entry point, this error immediately pops up here, how to fix it?
I also try add only Main component but anyway i take that error, in main.jsx just class with render method return &quot;hello world&quot;

    _react.default.createContext is not a function

&lt;!-- begin snippet: js hide: false console: true babel: false --&gt;

&lt;!-- language: lang-js --&gt;

    // App.jsx

    import React from &#39;react&#39;;
    import { render } from &#39;react-dom&#39;;
    import { Provider } from &#39;react-redux&#39;;
    import { BrowserRouter } from &#39;react-router-dom&#39;;

    import &#39;react-select/dist/react-select.css&#39;;

    import configureStore from &#39;./Data/store/configureStore&#39;;
    import Main from &quot;./Templates/Main/Main&quot;;

    const store = configureStore();
    render(
        &lt;div&gt;
            &lt;Provider store={store}&gt;
                &lt;BrowserRouter&gt;
                    &lt;Main/&gt;
                &lt;/BrowserRouter&gt;
            &lt;/Provider&gt;
        &lt;/div&gt;,
        document.getElementById(&#39;app-root&#39;)
    );

&lt;!-- end snippet --&gt;

Webpack config

    &#39;use strict&#39;;
    
    var path = require(&#39;path&#39;);
    var webpack = require(&#39;webpack&#39;);
    var HtmlWebpackPlugin = require(&#39;html-webpack-plugin&#39;);
    
    module.exports = {
      devtool: &#39;eval-source-map&#39;,
      entry: [
        &#39;webpack-hot-middleware/client?reload=true&#39;,
        path.join(__dirname, &#39;src/app.jsx&#39;)
      ],
      resolve: {
        root: [
          path.resolve(__dirname, &quot;src&quot;),
        ],
        extensions: [&#39;&#39;, &#39;.js&#39;, &#39;.jsx&#39;, &#39;.css&#39;]
      },
      output: {
        path: path.join(__dirname, &#39;/public/&#39;),
        filename: &#39;[name].js&#39;,
        publicPath: &#39;/&#39;
      },
      plugins: [
        new HtmlWebpackPlugin({
          template: &#39;src/index.tpl.html&#39;,
          inject: &#39;body&#39;,
          filename: &#39;index.html&#39;
        }),
        new webpack.optimize.OccurenceOrderPlugin(),
        new webpack.HotModuleReplacementPlugin(),
        new webpack.NoErrorsPlugin(),
        new webpack.DefinePlugin({
          &#39;process.env.NODE_ENV&#39;: JSON.stringify(&#39;development&#39;)
        })
      ],
      module: {
        loaders: [{
          test: /\.jsx?$/,
          exclude: /node_modules/,
          loader: &#39;babel&#39;,
          query: {
            presets: [&#39;es2015&#39;, &#39;react&#39;]
          }
        }, {
          test: /\.css$/,
          loader: &#39;style!css&#39;
        }]
      }
    };

and dependencies

        &quot;react&quot;: &quot;^15.6.2&quot;,
        &quot;react-addons-update&quot;: &quot;^15.6.2&quot;,
        &quot;react-bootstrap&quot;: &quot;^1.0.0-beta.5&quot;,
        &quot;react-dom&quot;: &quot;^15.6.2&quot;,
        &quot;react-helmet&quot;: &quot;^5.2.0&quot;,
        &quot;react-redux&quot;: &quot;^6.0.0&quot;,
        &quot;react-router&quot;: &quot;^4.3.1&quot;,
        &quot;react-router-dom&quot;: &quot;^4.3.1&quot;,
        &quot;react-select&quot;: &quot;^1.0.0-beta13&quot;,
        &quot;redux&quot;: &quot;^4.0.1&quot;,
        &quot;redux-thunk&quot;: &quot;^2.3.0&quot;,
        &quot;sequelize&quot;: &quot;^3.20.0&quot;,
        &quot;sqlite3&quot;: &quot;^4.0.6&quot;

Google advises to upgrade to version 16 of the ract, but I do not think that this is the problem of the old version.

_react.default.createContext is not a function when using react-redux

I am using React SPA, Express, Express-session, Passport, and JWT.
I&#39;m confused about some of the different client-side storage options to store tokens: Cookies, Session, and JWT / Passport.

Do tokens have to be stored in cookies, even if I can store them in `req.sessionID`?

Many websites use cookies to store shopping cart tokens. So far I have stored shopping cart data based on the session ID without adding any cookies.

&gt; So when users visit my website, I will match it with their
&gt; `req.sessionID` and then retrieve the data in the database like shopping carts and user session.

Do I need to store cookies? I can access it via `req.sessionID` to get the data needed.

**And the second**

I have made authentication using a `passport-google-oauth20`.After I successfully login, the data is saved into the session. and to send it to the client I have to send it via the URL query `?token=&#39;sdsaxas&#39;`. 

&gt; in this case I get a lot of difference of opinion. someone saved it
&gt; into local storage and someone saved it into cookies by converting it to a token using JWT.

     jwt.sign(
            payload,
            keys.jwt.secretOrPrivateKey, 
            {
                expiresIn:keys.jwt.expiresIn // &lt; i dont know what is this expired for cookies or localstorage ?
            }, (err, token) =&gt; {
             
                res.redirect(keys.origin.url + &quot;?token=&quot; + token);
            });

**Can I indeed store everything related to the session by using sessionID (without cookies or localstorage)?**

Only by doing fetch once or every page refresh and retrieving the data and then saved into redux because I use React SPA.

Do I have to store tokens in cookies or localstorage or session?

 For the following code:

    DECLARE @ss varchar(60)
      SET @ss = &#39;admin&#39;
    
      select TRIM(@ss)

I&#39;ve got an error: 
&gt; &#39;TRIM&#39; is not a recognized built-in function name


  

TRIM is not a recognized built-in function name

For the following code:
<pre><code class="hljs language-less">DECLARE @ss varchar(60)
 SET @ss = 'admin'

 select TRIM(@ss)
</code></pre>
I've got an error:
> 'TRIM' is not a recognized built-in function name

* If you execute `SELECT -100/-100*10` the result is `0`.
* If you execute `SELECT (-100/-100)*10` the result is `10`.
* If you execute `SELECT -100/(-100*10)` the result is `0`.
* If you execute `SELECT 100/100*10` the result is `10`.

[BOL](https://docs.microsoft.com/en-us/sql/t-sql/language-elements/operator-precedence-transact-sql?view=sql-server-2017) states:

&gt; When two operators in an expression have the same operator precedence level, they are evaluated left to right based on their position in the expression.

And

    Level	Operators
      1  	~ (Bitwise NOT)
      2 	* (Multiplication), / (Division), % (Modulus)
      3 	+ (Positive), - (Negative), + (Addition), + (Concatenation), - (Subtraction), &amp; (Bitwise AND), ^ (Bitwise Exclusive OR), | (Bitwise OR)

Is BOL wrong, or am I missing something? It seems the `-` is throwing the (expected) precedence off.

A strange operation problem in SQL Server: -100/-100*10 = 0

I have a field which is a varchar(20)

When this query is executed, it is fast (Uses index seek):

    SELECT * FROM [dbo].[phone] WHERE phone = &#39;5554474477&#39;

But this one is slow (uses index scan).

    SELECT * FROM [dbo].[phone] WHERE phone = N&#39;5554474477&#39;

I am guessing that if I change the field to an nvarchar, then it would use the Index Seek.

Why is query with phone = N&#39;1234&#39; slower than phone = &#39;1234&#39;?

My Intelij IDE wont connect to my database server of MySQL Workbench, it specifies it as a timezone problem and wants me to go to advanced tab and set serverTimezone property manually.

I tried looking if there where a similar problem but i cant seem to find it.

Server returns invalid timezone. Go to Advanced tab and set servertimezone property manually

I am trying to setup the ms-sql server in my linux by following the documentation 
https://docs.microsoft.com/pl-pl/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-2017

The SQL server status is Active (Running).

I am getting the following error while executing the command 

    sqlcmd -S localhost -U SA -P &#39;&lt;YourPassword&gt;&#39;

**Error:**

&gt; Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider:
&gt; Error code 0x2746. Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL
&gt; Server : Client unable to establish connection.


I also tried by giving the command 

    sqlcmd -S 127.0.0.1 -U SA -P &#39;&lt;YourPassword&gt;&#39; 

But the same error is displayed. When I tried the wrong password it also displays the same error.

Content Type	Original Author	Original Content on Stackoverflow
Question	sathish	View Question on Stackoverflow
Solution 1 - Sql	PSK	View Answer on Stackoverflow
Solution 2 - Sql	Nick.McDermaid	View Answer on Stackoverflow
Solution 3 - Sql	SQL_M	View Answer on Stackoverflow

TRIM is not a recognized built-in function name

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Do I have to store tokens in cookies or localstorage or session?

_react.default.createContext is not a function when using react-redux

Attributions