Skip to content
#

sqlserver

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

ozkanonur
ozkanonur commented Apr 13, 2020

Issue type:

[x] question
[ ] bug report
[ ] feature request
[x] documentation issue

Database system/driver:

[ ] cordova
[x] mongodb
[ ] mssql
[ ] mysql / mariadb
[ ] oracle
[ ] postgres
[ ] cockroachdb
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo

TypeORM version:

[x] latest
[ ] @next
[ ] 0.x.x (or put your version here)

jtoberling
jtoberling commented Aug 28, 2019

As of first congrats for this package - I'm using it quite often & it's a great help.

I'd like to ask a feature request - add support for MSSQL DB.
The main official mode of connection recommended by MS is ODBC/PDO.
[https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017#microsoft-odbc-driver-17-for-sql-server](ht

liquibot
liquibot commented Apr 27, 2020

Context

As a reader of online docs, it is not clear when doing diff which database if the "reference" against which a "target" is compared. This makes it tough!

As a reader of online docs, hoping to do a diffchangelog, it is not clear how to set the url and referenceURL parameters if i want to apply the generated diffchangelog against one db to migrate it up to the other. Which is which?

R

2881099
2881099 commented Apr 23, 2020

本篇文章内容引导,如何在 asp.net core 项目中使用特性(注解) 的方式管理事务。

UnitOfWorkManager 只可以管理 Repository 仓储对象的事务,直接 fsql.Insert<T>() 是不行的!!

支持六种传播方式(propagation),意味着跨方法的事务非常方便,并且支持同步异步:

  • Requierd:如果当前没有事务,就新建一个事务,如果已存在一个事务中,加入到这个事务中,默认的选择。
  • Supports:支持当前事务,如果没有当前事务,就以非事务方法执行。
  • Mandatory:使用当前事务,如果没有当前事务,就抛出异常。
  • NotSupported:以非事务方式执行操作,如果当前存在事务,就把当前事务挂起。
  • Never:以非事务方式执行操作,如果当前事务存在则抛出异常。
  • Nested:以嵌套事
JanneIlonen
JanneIlonen commented Aug 28, 2019

Database log backup fails when some database is in middle of a restore

SQL Server version and edition
Microsoft SQL Server 2017 (RTM-CU12) (KB4464082) - 14.0.3045.24 (X64) Oct 18 2018 23:11:05 Copyright (C) 2017 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor)

*Version of the script

aberezin
aberezin commented Apr 22, 2020

I am running mssql-cli in a bash script in ubuntu and see hundreds of /tmp/foo files left lying around where foo is like
clr-debug-pipe-29415-136842019-out
clr-debug-pipe-29415-136842019-in

They are FIFO pipes I think, created by CLR.

kdefilip
kdefilip commented Jul 8, 2019

Option @printCmds states the following:
@printCmds defaults to 0 (do not print all commands to screen) or optionally 1 (print all commands to screen). Useful if you just want to see what commands would be executed.

It appears the @printCmds does print commands, but ALSO executes the commands against the DB.

In the absense of @Exec_Print, @printCmds does execute the code, contrary to the

SmartSql
Ahoo-Wang
Ahoo-Wang commented Jul 29, 2019
    [Cache("DateCache", "Lru", FlushInterval = 6000)]
    [Cache("LruCache", "Lru", FlushInterval = 6000)]
    [Cache("UserCache", "Fifo", FlushOnExecutes = new[] {"UpdateUserName"})]
    public interface IUsedCacheRepository
    {
        [ResultCache("DateCache", Key = "GetNow")]
        [Statement(Sql = "Select Now();")]
        DateTime GetNow();

        [ResultCache("Lru
tbls
mjpieters
mjpieters commented Apr 22, 2020

Currently, the README.md file lists all tables with their full table comment.

I'm putting a lot of info in some of my table descriptions, including SQL code blocks. These render rather badly in the comment column of the central Tables table, which treats markdown just a little different.

Perhaps the Tables table should only use the first paragraph of each table description.

E.g.

基于EF Core的Code First模式的DotNetCore快速开发框架,其中包括DBContext、IOC组件autofac和AspectCore.Injector、代码生成器(也支持DB First)、基于AspectCore的memcache和Redis缓存组件,以及基于ICanPay的支付库和一些日常用的方法和扩展,比如批量插入、更新、删除以及触发器支持,当然还有demo。欢迎提交各种建议、意见和pr~

  • Updated May 17, 2020
  • C#

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 May 22, 2020
  • Java

Improve this page

Add a description, image, and links to the sqlserver topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the sqlserver topic, visit your repo's landing page and select "manage topics."

Learn more

You can’t perform that action at this time.