sql-server tag

31 questions

1 answers
329 views
0

How do I hide SQL Server version information?

environmentOS:Microsoft Windows Server 2012 R2SQL:Microsoft SQL Server 2008 R2 ExpressWhat do you want to doPort scanning tools such as nmap display version information.Could you please let me know if...

sql-server

1 years ago

1 answers
152 views
0

Rewrite from oracle's external binding expression (+) to left join is not successful

The format of the sql statement currently used in Oracle has been changed so that it can be used in sqlserver.Therefore, I am trying to rewrite the following sql statements.The select result is not th...

sql sql-server oracle

2 years ago

1 answers
82 views
0

Configuring User Permissions for SQL Server Management Studio

I would like to set up a login user in SQL Server Management Studio to run a stored procedure, but not to change it or view the source code of the procedure. Which role should I set and change?Please ...

sql-server

2 years ago

2 answers
129 views
0

The ASP.NET Core MVC always fails with the Scaffolding command.

I am a beginner at ASP.NET Core MVC.As the title says, I can't do the scuffolding.Run the following command: dotnet ef dbcontext scaffoldServer=.; Database=testdb; Trusted_Connection=True;Microsoft.En...

c# sql-server asp.net-core

2 years ago

2 answers
81 views
0

Subsequent scripts do not work when object is returned using SQL statement execution results to determine if statement conditions

browsers:IE8sqlserver:Microsoft SQL SERVER 2008The following Javascript functions are called from the ASPX file and processed.If the SELECT result for sqlServer is an [object] that does not exist in t...

javascript sql-server

2 years ago

1 answers
103 views
0

partial match search for integer fields

I would like to write a SELECT statement that considers an integer field (the range of values is 0 to 99) to be a string and searches for a partial match.For example, if you specify 7, 17 or 73 will b...

sql postgresql sql-server oracle

2 years ago

1 answers
128 views
0

SQL Server Management Studio will no longer be able to deploy database folders.

Database Folder Does Not Open in SQL Server Management Studio (Deploying... or Expanding...) State Does Not Go environmentWindows 10 Pro x64 2004 (updated from 1903)SQL Server 2012 SP4, 2014, and 2016...

sql-server

2 years ago

1 answers
102 views
0

Microsoft Access Overflows When I create a link table from SQLServer and try to calculate it in a query

A table linked to Microsoft Access from SQLServer SQL calculates and tries to display, causing overflow This will result in an error.I was able to calculate normally when using the local table without...

sql-server ms-access

2 years ago

3 answers
116 views
0

How do I set the primary key when I insert a record in SQL server?

I'd like to insert a record in SQLserver, but I'm worried about how to set the main key.I used to use max (main key) +1, but with this method, when multiple processes are inserted at the same time, Yo...

sql sql-server

2 years ago

1 answers
134 views
0

The visual studio cannot connect to the server.

Using Visual studio 2017, I tried to write and verify programming with a simple WebFormApplication to verify connectivity with SQL Server, but the test connection and build went well, but when I actua...

c# visual-studio sql-server

2 years ago

- 1 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656