Movatterモバイル変換


[0]ホーム

URL:


Sorry, we no longer support your browser
Please upgrade toMicrosoft Edge,Google Chrome, orFirefox. Learn more about ourbrowser support.
Skip to main content

Stack Exchange Network

Stack Exchange network consists of 183 Q&A communities includingStack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Loading…
Code Review

Questions tagged [sql-server]

Ask Question

Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It originated from the Sybase SQL Server codebase, which is why both products use the extension of SQL called Transact-SQL (T-SQL).

577 questions
Filter by
Sorted by
Tagged with
1vote
1answer
65views

I have table called cash_voucher it has some columns.I want to generate voucher number based location id.I mean generates voucher numbers starting from 1 for each locationFor example location id is ...
3votes
2answers
81views

I want a stored procedure that retrieves ID and PID from the invoice table with batchid as input parameter and based on the retrieved PID I want to retrieve sid from the log table.In total I want to ...
surya's user avatar
2votes
0answers
73views

I have a small SQL server database and VBA program that is used to automate tasks related to tennis students, programs, practices, performances, and student testing.I'm trying to learn db design and ...
Jason's user avatar
1vote
1answer
50views

dbfiddleGoalWithout repetition in the code, I want to filterBikeValuationList to only give theBikePriceId of the latest ...
J. Mini's user avatar
2votes
1answer
165views

I am trying to convert a SQL Server stored procedure to Pyspark code.This is my SQL Server query:...
Data writer's user avatar
3votes
1answer
140views

The SQL Server version I am using is SQL Server 2008.I've got an SQL query/script I've written which is to help simplify some things while our API is being rebuilt.Essentially, this script allows ...
level42's user avatar
3votes
2answers
136views

I have a transaction table let's call it Offers Table. Please don't read too much into the business but let's say a customer wants to buy a car and the customer searches variety of websites but at the ...
Cody's user avatar
2votes
1answer
78views

Background and use-caseI need to create a stored procedure where the input parameters will be: @sourceTable, @targetTable, @compositeKey. I'm using available fields for the composite key, since I ...
4votes
2answers
167views

I'm a newbie to PHP and other programming for that matter.I'm doing this simply to learn. Figured the code could be used to search through a police database or something.The statements are Microsoft ...
Luke Lenacio's user avatar
3votes
1answer
109views

ContextI was proud of this code for a little while, but the repetition wounds me. I know that the function name sucks, but the name and interface to this function are not under my control. ...
J. Mini's user avatar
2votes
2answers
144views

ContextI was proud of this code for a little while, but the repetition wounds me. I know that the function name sucks, but the name and interface to this function are not under my control. ...
J. Mini's user avatar
1vote
1answer
172views

The QuestionWhat is the percentage of customers who increase their closing balance by more than 5%?Source CodeThe database and all details can be found here.ERDMy Proposed Solution...
Mike's user avatar
  • 113
2votes
1answer
315views

I want to connect to MSSQL using ODBC (odbc-api) at the beginning of my server application created with hyper.rs.I want to have a connection pool and obtain a connection within each request, which ...
dertin's user avatar
0votes
1answer
138views

I have this stored Procedure that is passed in the data below that will building the SQL select that will get EXEC. The data that can be passed in can me null so I have three ...
Jefferson's user avatar
1vote
1answer
93views

I'm playing with data from a Time Use survey as a beginner SQL user.Gender is represented as 1's (Male) and 2's (Female), and the age of each participant is listed. I would like to divide them into ...
Erik's user avatar
  • 303

153050per page
1
2345
39

Hot Network Questions

more hot questions
Newest sql-server questions feed

[8]ページ先頭

©2009-2025 Movatter.jp