新手常犯,常忘記的匹配問題。主要是轉碼,需要在like後面添加個N,
N轉換字符串爲nchar,nvarchar。

SELECT [Type] ,[Title] FROM [TableName] WHERE [Title] LIKE N'%標題%'
We use cookies to improve your experience on our site. By using our site, you consent to cookies.
Manage your cookie preferences below:
Essential cookies enable basic functions and are necessary for the proper function of the website.
Statistics cookies collect information anonymously. This information helps us understand how visitors use our website.
Google Analytics is a powerful tool that tracks and analyzes website traffic for informed marketing decisions.
Service URL: policies.google.com (opens in a new window)