Examples of using Select statement in English and their translations into Korean
{-}
-
Programming
-
Colloquial
-
Ecclesiastic
-
Ecclesiastic
-
Computer
Some past SQL select statement experience would also be helpful.
과거의 SQL select statement 경험도 도움이 될 것입니다.Logical Processing Order of the SELECT statement.
In its simplest form, a SELECT statement is select star from table name.
가장 단순한 형식의 SELECT 문은 테이블 이름에서 star를 선택합니다.This is referred to as optimizing the SELECT statement.
이것을 SELECT 문 최적화라고 하며This is referred to as optimizing the SELECT statement.The SELECT statement in the view cannot contain these Transact-SQL syntax elements.
뷰 정의의 SELECT 문에는 다음 Transact-SQL 요소가 포함되지 않아야 합니다.The results are returned by using a SELECT statement.
결과는 SELECT 문을 사용하여 반환됩니다. The results are returned by using a SELECT statement.The third example shows a SELECT statement that retrieves data from the table.
SELECT 문은 테이블에서 데이터를 검색합니다. The SELECT statement retrieves the data from the table.Values are inserted into each column and returned in the SELECT statement.
값은 각 열에 삽입되고 SELECT 문으로 반환됩니다. Values are inserted into each column and returned in the SELECT statement.OCIFetch() fetches the next row(for SELECT statements) into the internal result-buffer.
OCIFetch() 함수는 다음 열(SELECT 구문을 위해)을 내부 결과 버퍼(internal result-buffer)에 페치한다.The INSERT statement chooses any two rows returned by the SELECT statement.
INSERT 문은 SELECT 문에서 반환되는 행 중 5개를 선택합니다. The INSERT You can use the FOR XML clause in a SELECT statement to return results as XML.
SELECT 문에 FOR XML 절을 사용하여 결과를 XML로 반환할 수 있습니다. You can use the FOR XML clause in a SELECT statement to return results as XML.SELECT statements may lock database resources unnecessarily, and in some scenarios it may be necessary to use transactions for selects. .
SELECT 문은 데이터베이스 리소스를 불필요하게 잠글 수 있으며 일부 시나리오에서는 선택 작업에 트랜잭션을 사용해야 할 수 있습니다.The following steps show the logical processing order, orbinding order, for a SELECT statement.
다음 단계에서는 SELECT 문의 논리적 처리 순서(바인딩 순서)를 보여 줍니다. The following steps show the logical processing order, or binding order,for a SELECT statement.In the following query, the idx1 index is used when the first SELECT statement is executed. When the second SELECT statement is executed, the query plan is rewritten to use the idx2 index.
아래 질의에서 첫 번째 SELECT 문 수행 시 idx1 인덱스를 사용하지만, 두 번째 SELECT 문 수행 시 질의 계획을 재작성하여 idx2 인덱스를 활용하게 된다.The EXPLAIN statement can be used either as a synonym for DESCRIBE or as a way to obtain information about how MySQL will execute a SELECT statement.
EXPLAIN 명령문은 DESCRIBE에 대한 동의어로 사용할 수 있거나 또는 MySQL이 SELECT 명령문을 실행하는 방법에 대한 정보를 얻기 위한 수단으로 사용할 수가 있다.A SELECT statement is non-procedural; it does not state the exact steps that the database server should use to retrieve the requested data.
데이터베이스 서버가 요청한 데이터를 검색하는 데 사용해야 하는 정확한 단계를 지정하고 있지 않습니다.A SELECT statement is non-procedural; it does not state the exact steps that the database server should use to retrieve the requested data.This option has the same effect as setting HOLDLOCK(vs NOLOCK) on all tables in the SELECT statement.
이 옵션은 트랜잭션의 모든 SELECT 문의 모든 테이블에 HOLDLOCK을 설정하는 것과 같습니다. This option has the same effect as setting HOLDLOCK on all tables in all SELECT statements in a transaction.While views are limited to a single SELECT statement, user-defined functions can have multiple SELECT statements and provide more powerful logic than is possible with views.
뷰에서는 This option has the same effect as setting NOLOCK on all tables in all SELECT statements in a transaction.".
이 옵션은 트랜잭션에서 모든 SELECT 문의 모든 테이블에 NOLOCK을 설정하는 것과 같습니다. This option has the same effect as setting NOLOCK on all tables in all SELECT statements in a transaction.Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement.
DECLARE 문을 사용하여 일괄 처리나 프로시저의 본문에 변수를 선언하고 SET 또는 SELECT 문을 사용하여 값을 할당합니다. Variables are declared in the body of a batch or procedure with the DECLARE Large numbers of indexes can helpthe performance of queries that do not modify data, such as SELECT statements, because the query optimizer has more indexes to choose from to determine the fastest access method.
이는 쿼리 최적화 프로그램이 가장 빠른 액세스 방법을 결정할 때 선택할 수 있는 인덱스가 더 많기 때문입니다. Large numbers of indexes can help the performance of queries that do not modify data,such as SELECT statements, because the query optimizer has more indexes to choose from to determine the fastest access method.The following example shows the use of OPENXML in an INSERT statement and a SELECT statement.
다음 예에서는 OPENXML 및 INSERT 문에서 The basic steps that SQL Server uses to process a single SELECT statement include the following.
SQL ServerSQL Server가 단일 This does not include sort operations involving the creation of indexes, only sort operations within a query(such as an ORDER BY clause used in a SELECT statement).
인덱스 만들기와 연관된 정렬 작업은 포함하지 않으며 This option has the same effect as setting HOLDLOCK on all tables in all SELECT statements in a transaction.
이 옵션은 트랜잭션의 모든 SELECT 문의 모든 테이블에 HOLDLOCK을 설정하는 것과 같습니다. This option has the same effect as setting HOLDLOCK on all tables in all SELECT statements in a transaction.This does not include sort operations involving the creation of indexes, only sort operations within a query(such as an ORDER BY clause used in a SELECT statement).
여기에는 인덱스 만들기와 관련된 정렬 작업이 포함되지 않으며 SQL Server reads only the columnsrequired for the result, as referenced by a SELECT statement, JOIN predicate, or filter predicate.
SQL ServerSQL Server는 For an inline table-valued function,there is no function body; the table is the result set of a single SELECT statement.
인라인 테이블 반환 함수에는 함수 본문이 없으며 테이블이 단일 SELECT 문의 결과 집합입니다. For an inline table-valued function, there is no function body;the table is the result set of a single SELECT statement.This mechanism is also called“merry-go-round scanning” and demonstrates why the order of the results returned from a SELECT statement cannot be guaranteed without an ORDER BY clause.
이 메커니즘은 ORDER BY 절 없이 Export data from SQL Server as JSON, or format query results as JSON, by adding the FOR JSON clause to a SELECT statement.
