1. query all tables in SQL:Select TABLE_NAME FROM database name. INFORMATION_SCHEMA.TABLES Where TABLE_TYPE = 'base table' after execution, you can see the names of all tables created by yourself in the database.2. query all tables and columns in SQL:Select dbo. sysobjects. name as Table_name, dbo. syscolumns. name AS Column_name FROM dbo. syscolumns inner join dbo. sysobjects ON dbo. syscolumns. id = dbo.
Label:Next: T-SQL Dynamic Query (3)--Static SQLObjective: There's a lot of talk about dynamic queries, and this article describes some of the ways to use dynamic SQL to solve dynamic queries.Why use Dynamic sql: in many projects, dynamic SQL is widely used and even misused,
Grade> = 90
-- Use "logical expression" as the query condition ......
/*
Logical expressions in SQL:
Not: non
And: corresponds
Or: or
*/
Select * from Student
-- Query the student table for a 19-year-old male student.
Select * from Student where Sage = 19 and Ssex = 'male'
-- Query the student whose age is 19 or 20 in
Tags: SQL statement electronic win style SPAN different statement column DTS --Connect remote SQL or insert data with OPENROWSET
--if only temporary access, you can directly use OPENROWSET
--Query Example
Select * from OpenRowset('SQLOLEDB'
,'SQL Server name';'User name';'Password', database name. dbo. Table name)
Routine collection of commonly used SQL query statements and SQL statements
Common SQL query statements are as follows:
1. Simple query statements
1. view the table structure
SQL> DESC
Advanced query technology is mainly related to multiple tables linked query technology, embedded SELECT statement subquery technology, the combination of multiple queries combined technology.
1. Connection Query
You need to retrieve data from two or more tables at the same time. A link allows you to retrieve data from two tables or more than two tables at the s
SQL, Structured query Language Structured Query Language , is a database query and programming language for accessing data and querying, updating, and managing relational database systems. SQL language contains 4 sections:※ data definition language (DDL) create ,
), variable length, can hold photos, files, etc.
int, integer field. Example: Userage int
float, floating-point data is approximate. Example: Userresults float, the approximate numeric data type used to represent floating-point numeric data.
datetime, Date type. Example: Createdatetime datetime
Bit, Boolean type. Can be set to True is male, false is schoolgirl
If the content is very much, indeterminate length (such as article), can be used: nvarchar (max) 6. Save the tabl
Steps for Oracle to execute SQL query statements and oraclesql query statements
Steps for Oracle to execute SQL query statements
If you enter the following query statement in SQL * Plus
Optimization of SQL massive data query and non-use like processing solutions, data query like
1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.
2. Try to avoid null value determination on the field in the where clause. Otherwise, th
Optimization of SQL massive data query and non-use like processing solutions, data query like
1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.2. Try to avoid null value determination on the field in the where clause. Otherwise, the
How can I convert Oracle queries to queries in the SQL database? The following describes how to convert an Oracle query to an SQL query. If you are interested in Oracle query, take a look.
Oracle's TO_CHAR function can convert the n-bit NUMBER data type to the VARCHAR2 data
Label:IntroductionSee a popular blog today. NET Senior Engineer face questions of SQL, asked to find the highest score of each department, and by the department number, the student number in ascending order. This query is more complex, but also more typical, since the use of ORM, a long time did not write SQL statements, so I studied the next, I also wrote a: w
Select *from t1left join T2 on T2.sysno =t1. Asysnoleft join T3 on T3.sysno =t2. Asysnoleft join T4 on T4.sysno =t3. Asysnoleft join T5 on T5.sysno =t4. Asysnoleft join T6 on T6.sysno =t5. Asysnoleft join T7 on T7.sysno =t6. Asysnowhere t1.name like '%aaa% 'In the absence of any indexes, fuzzy queries, such SQL performance is the worst, such SQL for the Federated que
Label:Original: SQL Server 2012:SQL Server architecture--The life cycle of a query (part 1th)To reduce the scope of the read operation, this article first looks at a simple select query and then introduces additional procedures related to performing the update operation. Finally, you will read that
appear in the where) B. If the SELECT statement contains both group BY, have, order by, then the order by IS group BY, have, order by. C. In the Select column, if there are columns, expressions, and grouping functions, the columns and expressions must appear in the GROUP BY clause, or an error will occur. Using GROUP BY is not a precondition for having a having. 3. Multi-Table Query Sql>select e.name,e.sal
How does PHP query an SQL query that matches the value of a string and an array field? if it directly queries the records of pt = $ rpt, it is like this $ SQL = quot; SELECT * FROM 'user' wherept = {$ rpt} quot; now the pt field is an array. how does PHP query an
where) B. If the SELECT statement contains both group BY, have, order by, then the order by IS group BY, have, order by. C. In the Select column, if there are columns, expressions, and grouping functions, the columns and expressions must appear in the GROUP BY clause, or an error will occur. Using GROUP BY is not a precondition for having a having. 3. Multi-Table Query Sql>select e.name,e.sal,d.dname from
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.