Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server

How to properly index a many-many association table?

How to find the first nearest value up and down in SQL?

sql sql-server

When to use Microsoft.Data.SqlClient.SqlException vs System.Data.SqlClient.SqlException?

c# sql-server

Need help to restore multiple databases/bak files from one folder

How to run a query multiple times with different parameters?

sql sql-server t-sql

SQL to JSON - Create a Json Array

Strip numbers from string after certain characters into a recursive table

SQL query to return roles and groups a user has that are not related to a toplevel role

sql sql-server

SQL Server uses high CPU when searching inside nvarchar strings

sql-server t-sql

How to script a unique index with included columns using SQL Server Management Objects (SMO)?

Accessing Azure SQL database from anywhere

sql-server azure

Docker: unixodbc.h no such file or directory. "pecl install sqlsrv" error with unixodbc-dev already installed

php sql-server docker sqlsrv fpm

MSSQL db JDBC performance properties

sql-server jdbc

Weird "Cannot use a CONTAINS or FREETEXT predicate on column 'Name' because it is not full-text indexed." error

Updating 100k records in one update query

How do I generate SQL database script using C# or SQL?

What is the equivalent type of SQL Timestamp in c#

DATEDIFF convert minutes to decimal

How to enforce a CHECK constraint across multiple tables

Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll'