sql-server tag

31 questions


2 answers
123 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...

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...

2 years ago

1 answers
99 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...

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...

2 years ago

2 answers
129 views
0
What is the definition (app.php) for CAKEPHP to connect to MS SQLServer?

Our development terminal has a track record of completing PHP 7.0 web applications without using a framework.This is a recognition that the connection was achieved by obtaining the necessary dll and a...

2 years ago

1 answers
106 views
0
Error establishing connection to SQL Server

from SSMS to a previously local SQL ServerI was able to access it, but I can no longer access itPlease tell me how to deal with itA network-related or instance-specific error occurred while establishi...

2 years ago

2 answers
87 views
0
Data retrieval from SQLserver results in "Invalid column name 'N'"

We are participating in the development of improved versions of existing services that have already been developed and operated.In order to create a development environment on the local PC, we cloned ...

2 years ago

2 answers
109 views
0
What is the validity of the SQL Server index when using EntityFramework?

This is the first development in the Entity Framework 6, ASP.NET (MVC) project (C#).DB is the Azure SQL database.We created a non-clustered index on age because the ID is the primary key and the membe...


4 answers
99 views
0
About Table Design

I'm working on a table design, but I'm having a hard time with my first training, so I'd like some advice.I won't give you any specific information, so it's an example.There is a table like the one ab...

2 years ago

2 answers
123 views
0
Unable to connect to internal SQLServer from outside the company via SSH

I'm going to connect to the internal Windows Server from outside the company via SSH (OpenSSH) PortForward and work with the SQLServer DB.The language used is C#.SQLServer is connected with SQLServer ...

2 years ago
« - 2 - »

© 2024 OneMinuteCode. All rights reserved.