I see this post is pretty old and there are some useful answers but this is a pretty crazy straight forward method… Select SUM(DISTINCT(n & 0x01)) + SUM(DISTINCT(n & 0x02)) + SUM(DISTINCT(n & 0x04)) as OrN From BitValues
SQL Server is following the ANSI/ISO standard for string comparison. The article How SQL Server Compares Strings with Trailing Spaces explains this in detail. SQL Server follows the ANSI/ISO SQL-92 specification… on how to compare strings with spaces. The ANSI standard requires padding for the character strings used in comparisons so that their lengths match … Read more
After communication in comments I can suppose that your main problem is the CN part of the certificate which you use. To have successful TLS communication for IIS Server one have no such strong restrictions like SQL Server has. Microsoft require (see here) that The name of the certificate must be the fully qualified domain … Read more
You almost never want to join sys.columns.system_type_id = sys.types.system_type_id. This will lead to duplicate records in the case of user-defined types. There are two JOINs which do make sense. Both of them work equivalently for built-in types. sys.columns.user_type_id = sys.types.user_type_id For a built-in type, it returns the built-in type. For a user-defined type, it returns … Read more
There are several ways that this can be done: A filter in the WHERE clause: select id, name, population from yourtable where population in (select max(population) from yourtable) Or a subquery: select id, name, population from yourtable t1 inner join ( select max(population) MaxPop from yourtable ) t2 on t1.population = t2.maxpop; Or you can … Read more
It enables you to use the $ROWGUID variable instead of the column name. It’s used mostly for merge replication. It doesn’t force the GUID column for PK, you can only declare PKs explicitly. The answer to your last question is no, unless you plan on implementing Merge Replication.
You cant really use mcr.microsoft.com/mssql/server:2019-latest containers on M1 because MSSQL DB does not support ARM architecture. The only way I found – is to use Azure SQL container that supports ARM and can be run on M1. Here my docker-compose.yml config example: version: “3.9” services: # Database instance mssql: image: mcr.microsoft.com/azure-sql-edge:latest volumes: – events_mssql:/var/opt/mssql ports: … Read more
Heap storage has nothing to do with these heaps. Heap just means records themselves are not ordered (i. e. not linked to one another). When you insert a record, it just gets inserted into the free space the database finds. Updating a row in a heap based table does not affect other records (though it … Read more
Assuming you have created a user in this database associated with the AD login, e.g. CREATE LOGIN [domain\user] FROM WINDOWS; GO USE your_database; GO CREATE USER [domain\user] FROM LOGIN [domain\user]; GO Then you merely have to follow the same syntax. Because \ is not a standard character for an identifier, you need to escape the … Read more
Is the “Script Unique Keys” option set to TRUE in your SSMS? In SSMS, Tools -> Options will get you to the pop-up window shown below.