Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Query hints specify that the indica
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Query hints specify that the indicated hints are used in ...
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Query hints specify that the indicated hints are used in the scope of a query. They affect all operators in the statement...
Applies to: SQL Server (starting with SQL Server 2012 (11.x)). Prevents the query from using a nonclustered memory optimized columnstore index. If the query contains the query hint to avoid the use of the columnstore index, and an index hint to use a columnstore index, the hints are in...
If your database collation is case-insensitive, you may want the functions to perform their matches in a case-insensitive manner as well. The explicit capture option may be required to reduce some resultsets. The multi-line option can allow you to create more precise pa...
--Execute a query to perform a case-insensitive--search on the case-sensitive dataSELECT*FROMdbo.TestCharacterWHERECSData='test data'COLLATE Latin1_General_CI_AS;--Try to execute a query that compares the two columns--that have different collations. this will fail--as the collation conflict...
Although these matching functions are very powerful, they are not complete. There are many possible options that determine the exact way matches are performed. If your database collation is case-insensitive, you may want the functions to perform their matches in a case-insensitive manner as well...
Usage: sqlcmd [flags] sqlcmd [command] Examples: # Install/Create, Query, Uninstall SQL Server sqlcmd create mssql --accept-eula --using https://aka.ms/AdventureWorksLT.bak sqlcmd open ads sqlcmd query "SELECT @@version" sqlcmd delete # View configuration information and connection strings...
The upper-case() function is used to make --the search case-insensitive. SELECT ProductModelID, CatalogDescription.query(' <Prod> { /pd:ProductDescription/@ProductModelID } { /pd:ProductDescription/pd:Summary } </Prod> ') as Result FROM Production.ProductModel where CatalogDescription.exist(...
The upper-case() function is used to make --the search case-insensitive. SELECT ProductModelID, CatalogDescription.query(' <Prod> { /pd:ProductDescription/@ProductModelID } { /pd:ProductDescription/pd:Summary } </Prod> ') as Result FROM Production.ProductModel where CatalogDescription.exist(...