<dd id="yld2g"><track id="yld2g"></track></dd>

    1. <th id="yld2g"></th>

      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.

      Filter by
      Sorted by
      Tagged with
      -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 ...

      15 30 50 per page
      1
      2 3 4 5
      19822
      欧美日韩国产在线一区二区_午夜短视频在线观看_亚洲国产欧美日本视频_亚洲精品高清视频在线观看