server tag

107 questions

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
129 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
103 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

2 answers
124 views
0

I want SQL server to connect multiple tables vertically

I have a question about the SQL table.[What I want to do] I want to connect all the tables (columns, etc.) vertically on SQL server(You can use UNION, but if you have 100 tables, for example, it's tro...

sql sql-server

2 years ago

1 answers
90 views
0

How do I use PIA on Windows Server 2012 R2?

Thank you for your help.I tried to install Office 2007 on Windows Server 2012 R2 and PIA for office 2007, but I couldn't.PIA for office 2007 may not support Windows Server 2012.Which version of Office...

windows-server

2 years ago

1 answers
99 views
0

SQL Server, one-to-many table call

WorktableID, task number...Work Details TableID, Task ID, Task Start Time, Task End Time...Work Details Table (Work Details Table 1 - Multi-Work Details Table)ID, Work Details ID, Work Description, Ac...

sql-server

2 years ago

1 answers
100 views
0

Error when reading SQL Server data from Django with a different database name

Django is writing a program to read data from SQL Server, but an object that is different from the actual database name is generated, resulting in an error.The contents of the error are as follows, bu...

python django sql-server

2 years ago

1 answers
76 views
0

Want to reduce the initial size of the SQL Server database

You are using a SQL Server database.We removed unnecessary records because there were more records in the table than transaction logs.(DELETE statement) However, the size of the mdf file did not chang...

sql sql-server

2 years ago

- 2 -

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