Skip to content
#

sqlserver

sql-server logo

Microsoft's SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality. It originated from the Sybase SQL Server 4.x codebase and Transact-SQL dialect (t-sql), but it has forked significantly since then.

SQL Server is available in multiple versions (typically identified by release year), each of which are subdivided into editions to distinguish between product functionality. The latest released version is SQL Server 2019 which was released on November 4th, 2019.

Here are 1,329 public repositories matching this topic...

adrianvoica
adrianvoica commented Oct 7, 2020

Hello Maurits,
This is more of a request than it is an actual issue, but I think the value in this request is really high (for newcomers, especially - but not limited to).
Could you please add a COMPLETE application example of using the API (with user authentication, maybe even with the user-creation SQL script, table authorization, etc).
This would be really really helpful as a quickstart /

aion1998
aion1998 commented Jan 16, 2021

环境:

数据库:Sqlserver2014
网站程序:.Net5
Docker版本:Docker version 19.03.13,
.net5环境镜像源:mcr.microsoft.com/dotnet/aspnet:5.0-buster-slim
Centos版本:CentOS Linux release 7.9.2009 (Core)

使用原生方式进行测试

using (SqlConnection connection = new SqlConnection("Data Source=xxxxx;User Id=sa;Password=xxxxxx;Initial Catalog=xxxxxxxx;Pooling=true;Min Pool Size=1;"))
{
connection

simon-budin
simon-budin commented Sep 2, 2020

My local server has a user with an empty password. To connect to the server, passing -P "" does not work (i.e. the client prompts for Password anyway).
Also setting the environment variable MSSQL_CLI_PASSWORD to "" has the same effect.

Is there a way to pass an empty password without being prompted ?

SymmetricDS is a database and file synchronization solution that is platform-independent, web-enabled, and database agnostic. SymmetricDS was built to make data replication across two to tens of thousands of databases and file systems fast, easy and resilient. We specialize in near real time, bi-directional data replication across large node networks over the WAN or LAN.

  • Updated Jan 28, 2021
  • Java

Created by Sybase, Ashton-Tate, and Microsoft.

Released 1989

Wikipedia
Wikipedia

Related Topics

database