Location:
Search - sql select
Search list
Description: （转载）Use this utility to write your database table structure to a word file. You can select tables, or write all tables. In the word file you will be able to see complete details of the table(FieldName,Datatype,size,AllowNulls) with databse name and server name. 使用这个工具可将你的数据库表格结构编写为一个word文件。你能选择表，或者编写所有的表。在word文件中你能看到带有数据库名称和服务器名称表格的详细信息(域名，数据类型，大小，AllowNulls)。 来源: http://www.freevbcode.com/ShowCode.Asp?ID=5459
Platform: |
Size: 8608 |
Author: |
Hits:
Description: sql常用查询 本人为在校生 内容粗浅 但涉及查询均为典型情况 代码自写 编译通过-sql inquiries I used to the school as shallow involving inquiries are typical of the code was compiled through since
Platform: |
Size: 2132 |
Author: 李剑 |
Hits:
Description: 功能: 自动绘制循环报表说明: 以可视化的方法自动绘制循环报表 可以任意指定对象属性, 属性支持原有表达式 支持SQL Select和外部数据源作用: 将繁琐的不可视代码调试转化为轻松愉快的可视化绘制 开发时间由以天为单位计算缩短为以分钟为单位-functions : automatic mapping cycle statements Note : Visualization of the automatic mapping cycle returns to be arbitrarily designated object properties, attributes to support the original expression of support for SQL Select and external data sources role : the cumbersome visual debugging code into a visual delight, drawing from a development time as days shorten terms for a minute as a unit
Platform: |
Size: 56320 |
Author: 123456789 |
Hits:
Description: VB实现交互式组合SQL查询的例子（SELECT aaa FROM bbb WHERE ccc ORDER BY ddd）-VB portfolio interactive SQL Query example (aaa SELECT FROM WHERE bbb ccc ORDER BY ddd)
Platform: |
Size: 75776 |
Author: 闫成明 |
Hits:
Description: 在Windows系统的管理工具中，选择Internet信息服务，进入web页面管理界面。设置默 认web站点的路径为本目录的绝对路径。 确保您的机器上安装了SQL Server 2000或以上的版本，建立一个新的数据库ASPData，再将 存放在datasource子目录下的mydb_1文件导入到新建的数据库中，并进行还原备份。-on Windows systems management tool, select Internet Information Services, access web pages management interface. Web site set up by default the path to catalog the full path. To ensure that your machine installed SQL Server 2000 or more versions, the creation of a new database ASPData and then stored in a subdirectory under the datasource mydb_1 documents imported into the new database, backup and restore.
Platform: |
Size: 703488 |
Author: paul |
Hits:
Description: 内容如下：
1.The history of the computerized database
2.SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database example statements include select, update, insert, and delete
3.SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints
4.How data sets can interact with queries
5.The importance of subqueries
6.Data conversion and manipulation via SQL s built-in functions
7.How conditional logic can be used in Data Statements-read as follows : 1.The history of the computerized database 2.SQL Data Statements-- those used to create, manipulate, and retrieve data stored in your database example statements include select, update, insert, and delete 3.SQL Schema Statements-- those used to create database objects, such as tables, indexes, and constraints 4.How data sets can interact with queries 5.The importance of subqueries 6.Data conversion and manipulation via SQL s built-in functions can 7.How conditional logic be used in Data Statements
Platform: |
Size: 601088 |
Author: 余辰 |
Hits:
Description: sql常用查询 本人为在校生 内容粗浅 但涉及查询均为典型情况 代码自写 编译通过-sql inquiries I used to the school as shallow involving inquiries are typical of the code was compiled through since
Platform: |
Size: 2048 |
Author: 李剑 |
Hits:
Description: 获取汉字拼音和拼音首字母的功能函数；
--函数GetHzFullPY(string)用于获取汉字字符串的拼音
--select GetHzFullPY( 中华人民共和国 ) from dual
--返回：ZhongHuaRenMinGongHeGuo
--函数GetHzPYCAP(string)用于获取拼音首字母
--select GetHzPYCAP( 中华人民共和国 ) from dual
--返回ZHRMGHG-Access to Chinese characters and phonetic alphabet the first letter of the performance function - function GetHzFullPY (string) for access to Chinese Pinyin string- select GetHzFullPY (People s Republic of China) from dual- to return to: ZhongHuaRenMinGongHeGuo- function GetHzPYCAP (string) to use access to the first letter in the alphabet- select GetHzPYCAP (People s Republic of China) from dual- to return to ZHRMGHG
Platform: |
Size: 131072 |
Author: Aier |
Hits:
Description: SQL(Structured Query Language，结构查询语言)是一个功能强大的数据库语言。SQL通常使用于数据库的通讯。ANSI（美国国家标准学会）声称，SQL是关系数据库管理系统的标准语言。SQL语句通常用于完成一些数据库的操作任务，比如在数据库中更新数据，或者从数据库中检索数据。使用SQL的常见关系数据库管理系统有：Oracle、 Sybase、 Microsoft SQL Server、 Access等等。虽然绝大多数的数据库系统使用SQL，但是它们同样有它们自立另外的专有扩展功能用于它们的系统。但是，标准的SQL命令，比如"Select"、 "Insert"、 "Update"、 "Delete"、 "Create"和 "Drop"常常被用于完成绝大多数数据库的操作。MS SQL Server 就是用的Transact- SQL。SQL语言有着非常突出的优点，SQL语言是非过程化的语言、统一的语言、是所有关系数据库的公共语言。
Platform: |
Size: 133120 |
Author: zhangbo |
Hits:
Description: 动态sql语句基本语法
1 :普通SQL语句可以用Exec执行
eg: Select * from tableName
Exec( select * from tableName )
Exec sp_executesql N select * from tableName -- 请注意字符串前一定要加N
2:字段名，表名，数据库名之类作为变量时，必须用动态SQL
eg:
declare @fname varchar(20)
set @fname = FiledName
Select @fname from tableName -- 错误,不会提示错误，但结果为固定值FiledName,并非所要。-Basic grammar dynamic sql statement one: ordinary SQL statement Exec can be used to implement eg: Select* from tableName Exec (select* from tableName) Exec sp_executesql N select* from tableName Please note that the string must be added before the N 2: field names, table name, database name, such as variables, we must use dynamic SQL eg: declare @ fname varchar (20) set @ fname = FiledName Select @ fname from tableName error will not prompt an error, but the result for the fixed value FiledName, not to be.
Platform: |
Size: 70656 |
Author: 风尘小子 |
Hits:
Description: 用sql语言完成包括计算列、求和、最大、最小值、各类选择条件、字符匹配、分组和排序，连接查询、嵌套查询及EXISTS查询等，体会各种查询的异同及相互之间的转换，体会各种查询的执行过程，为简单综合应用打下良好的基础-sql select
Platform: |
Size: 17408 |
Author: kun |
Hits:
Description: 第三部分 操作数据：SQL
本部分内容
SQL基础
中级SQL
高级SQL
-SELECT email FROM email_table WHERE name="Bill Gates" OR
name="president Clinton"
Platform: |
Size: 48128 |
Author: twtay1 |
Hits:
Description: An SQL Query parser which allow you to see the route of the SQL select command.
Platform: |
Size: 1441792 |
Author: Noam |
Hits:
Description: 一、实验目的
1）理解视图的概念。
2）掌握创建视图的方法。
3）掌握更改视图的方法。
4）掌握用视图管理数据的方法。
二、实验内容
3、用T-SQL语言创建、管理视图 （以下题目需提交）
（1）创建视图
1）创建一个名为stuview2的水平视图，从数据库XSGL的student表中查询出性别为“男”的所有学生的资料。并在创建视图时使用with check option。（注：该子句用于强制视图上执行的所有修改语句必须符合由Select语句where中的条件。）
T-SQL语句为：
Create view stuview2
As
Select *
From student
Where sex= 男
-1, experimental purposes 1) understand the concept of view. 2) to master the method to create the view. 3) control to change the view method. 4) The master with the view of management data. Second, the contents of three experiments, using T-SQL language to create, manage view (the following topics should be submitted) (1) create a view of a) Create a file called stuview2 level view of the student table from the database query XSGL the gender as " male " All the students information. Used in the creation of the view with check option. (Note: This clause is used to force all the modifications performed on the view must be consistent with statements by the Select statement where the condition.)
Platform: |
Size: 200704 |
Author: kice |
Hits:
Description: SQL Server MFC ODBC 多记录集查询的一个实例-SQL Server MFC ODBC record set more than one instance of the query
Platform: |
Size: 48128 |
Author: |
Hits:
Description: SQL子查询语言笔记:子查询的分类 单行的语法 select 字段 from 表 where 字段 >[单行] (子查询)多行
in ,all,any
in:表示在一个区间内
select * from emp where ename in (
select ename from emp where sal>2000
)
-SQL:select * from emp where sal>(Select SAL From EMP Where ENAME= ALLEN
)
Platform: |
Size: 1024 |
Author: 鲁媛 |
Hits:
Description: 该源码的主要功能：采用ADO+SQL Server技术实现模糊查询，风格规范，值得借鉴。-The main function of the source: Using ADO+ SQL Server technology fuzzy query, style specifications, worth learning from.
Platform: |
Size: 131072 |
Author: 李晨旭 |
Hits:
Description: LABView实现使用SQL语句操作数据库(The LABView implementation uses the SQL statement to manipulate the database)
Platform: |
Size: 21504 |
Author: wendylsr
|
Hits:
Description: 一个嵌套代码块中的语句使用四个空格的缩进。（上述代码中的多行 SELECT 语句是一个 SQL 语句。）在同一语句中开始新行时，使 SQL 关键字右对齐。将代码编辑器配置为使用空格，而不是使用制表符[每个制表符对应为4个空格，请在SQL编辑器中进行设置。]。这样，不管使用何种程序查看代码，格式都是一致的。(A statement in a nested block of code that uses four spaces for indentation. The multiline SELECT statement in the above code is a SQL statement When you start a new row in the same statement, make the SQL keyword right justified. Configure the code editor to use spaces instead of tabs. [each tab corresponds to 4 spaces. Set it in the SQL editor. ]. Thus, the format is consistent regardless of which program is used to view the code.)
Platform: |
Size: 379904 |
Author: 哦嚯嘢哒哨
|
Hits:
Description: SELECT语句的执行顺序大家比较少关注，下面将为您详细介绍SQL语句中SELECT语句的执行顺序，供您参考，希望对您能够有所帮助。(SELECT statement execution order We are less concerned about the following will give you a detailed introduction of the SELECT statement in the SQL statement execution order, for your reference, I hope for your help.)
Platform: |
Size: 40960 |
Author: lxy987 |
Hits:
« 12
3
4
5
6
7
8
9
10
...
17
»