sqlserver
Here are 1,084 public repositories matching this topic...
-
Updated
May 11, 2020 - TSQL
-
Updated
May 19, 2020 - Java
nopCommerce version: 4.30 Beta
Steps to reproduce the problem:
Add any item to wishlist
Go to wishlist page
Click on Email a friend button
See here, personal message input is a textbox. it would be good it have textarea
We have Javadoc published for each patch release, e.g.:
- https://www.jooq.org/javadoc/3.13.0/org.jooq/org/jooq/conf/RenderQuotedNames.html
- https://www.jooq.org/javadoc/3.13.1/org.jooq/org/jooq/conf/RenderQuotedNames.html
The latest version of the Javadoc for a minor release is currently using an x
for the patch release number:
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
Describe the bug
SQL Server supports assigning a value to a variable from a selected expression.
For example:
DECLARE @var INT;
CREATE TABLE tableName (id INT);
SELECT @var = 1;
SELECT @var = id FROM tableName;
To Reproduce
assertSqlCanBeParsedAndDeparsed("SELECT @var = 1");
System
- SQL Server 2017
- JSqlParser 3.1
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
本篇文章内容引导,如何在 asp.net core 项目中使用特性(注解) 的方式管理事务。
UnitOfWorkManager 只可以管理 Repository 仓储对象的事务,直接 fsql.Insert<T>() 是不行的!!
支持六种传播方式(propagation),意味着跨方法的事务非常方便,并且支持同步异步:
- Requierd:如果当前没有事务,就新建一个事务,如果已存在一个事务中,加入到这个事务中,默认的选择。
- Supports:支持当前事务,如果没有当前事务,就以非事务方法执行。
- Mandatory:使用当前事务,如果没有当前事务,就抛出异常。
- NotSupported:以非事务方式执行操作,如果当前存在事务,就把当前事务挂起。
- Never:以非事务方式执行操作,如果当前事务存在则抛出异常。
- Nested:以嵌套事
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
-
Updated
May 15, 2020 - C#
ebean should automatically direct read request to reader instance of aws aurora cluster and write request to writer instance
developer should have an option of enable/disable using properties file.
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.
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
[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
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.
-
Updated
May 17, 2020 - C#
-
Updated
Nov 4, 2019 - F#
-
Updated
May 11, 2020 - C#
-
Updated
May 22, 2020 - Java
-
Updated
Apr 20, 2020 - C#
-
Updated
May 22, 2020 - C#
Hi,
I just had a suggestion around documentation around the CLI, specifically with regards to passing a response file.
If possible, under the Examples subheading could we label the contents of the args.txt file to make it explicit.
Just adding a simple "Contents of args.txt:" I feel would be helpful.
Thanks
Improve this page
Add a description, image, and links to the sqlserver topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the sqlserver topic, visit your repo's landing page and select "manage topics."
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)