Questions tagged [sql-server]
Microsoft SQL Server is a relational database management system (RDBMS). Use this tag for all SQL Server editions including Compact, Express, Azure, Fast-track, APS (formerly PDW) and Azure SQL DW. Do not use this tag for other types of DBMS (MySQL, PostgreSQL, Oracle, etc.). Do not use this tag for issues on software and mobile development, unless it is directly related to the database.
297,325
questions
-2
votes
1answer
10 views
Column 'Book.Title' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
I'm creating a Library Management System and in the database I want to display book ISBN, Title and No. of copies of each book with their located library.
Here's the code I tried :
CREATE VIEW ...
-3
votes
0answers
17 views
increase the number of rooms by 1 [closed]
Friends, I have a dormitory automation project, I want it to increase the number of active people by 1 when enrolling in the rooms section, and reduce it by 1 when the person is deleted from the room, ...
-3
votes
1answer
17 views
How to copy new data from one table to another table [closed]
How to copy new data from one table to another table in SQL.
Example:
There are 4 rows in one table and then we added 2 more rows now how to copy that two rows only from one to another table, we don't ...
-1
votes
0answers
30 views
Executing stored procedure taking parameter value from driving table
I am using SQL SERVER 2016.
The Child Stored Procedure looks like below.
CREATE PROC [dbo].[usp_InventProduct_Test]
@FilterDate date,
@Schema nvarchar(100),
@RolloutName nvarchar(100),
...
0
votes
0answers
16 views
Event Log track Module issue
I am working with Drupal 8.9.11 and Microsoft-SQL and Nginx
I installed the Event Log track Module using composer
this module has many Sub-Modules like Event Log track File, Event Log track User ...
0
votes
3answers
48 views
Prevent duplicate data in using After Insert Trigger
I can detect duplicate records, but when I'm inserting new data it will detect it as a duplicate record even if doesn't already exist.
Here is my code:
ALTER TRIGGER [dbo].[SDPRawInventory_Dup_Trigger]...
-2
votes
0answers
30 views
Give the numbers to all month which are as string in my database, and next row to be autofill when user select any month [closed]
I want to make this "month_no" field autofill, when the user sends or inserts data in the previous field which for_month as the month in string format I want month_no to be filed ...
-1
votes
1answer
28 views
SQL Query for the condition 0 AND 0 [closed]
I have 2 tables in Database
I want to fetch the records except (sales=0 && quantity-0) from sales table and (stock=0 && quantity=0) from stock table.
Using the select query with ...
-1
votes
2answers
48 views
Query to calculate sum of time with above 24 hours interval
I have time like 25:00:00, 10:00:00, 30:00:00 and I want to calculate the sum of the values from database. How can I do that the current query for calculating sum is
SQL query:
SELECT
CAST(FORMAT(...
0
votes
1answer
40 views
How to make sure sp_xml_removedocument is always run
I would like to run a query to release the space held by XML parsing created by sp_xml_preparedocument before the session is killed. My code is like:
DECLARE @idoc INT, @result XML
SELECT @result = ...
-1
votes
1answer
37 views
Transpose fixed number of rows in columns
I have a dataset(one column , multiple rows) mentioned below. I want to transpose first 5 rows in columns - 1st row, next 5 rows in 2nd row's column and so on. Can anyone help me with SQL query to ...
0
votes
0answers
9 views
Intalling mssql-tools and unixodbc-dev on Ubuntu 20
I have tried to install SQL Server command-line tools, but I get the next error
sql-tools unixodbc-dev
Reading package lists... Done
Building dependency tree
Reading state information... Done
...
0
votes
1answer
42 views
Current Month, Previous Month, Next Month
This is my query
select *
from RDR1 A
where Year(A.shipdate) = '2021'
and (
Month(A.shipdate) = Month(CURRENT_TIMESTAMP) - 1
or Month(A.shipdate) = Month(CURRENT_TIMESTAMP) + 1
or Month(...
1
vote
1answer
24 views
PHP: cannot connect to localhost // “target machine actively refused it”
I am trying to connect to a mssql database which is hosted on localhost via PHP code. In a browser (either firefox or edge) I run: "http://localhost/demo.php" and receive this error:
...
-1
votes
0answers
25 views
Connect HTTP response to SQL database [closed]
I need to use SQL and Asp.net to make a system that sends the HTTP response / Request response to a site, shows the data retrieved from the SQL server and then, shows what they have received after ...
欧美日韩国产在线一区二区_午夜短视频在线观看_亚洲国产欧美日本视频_亚洲精品高清视频在线观看