Location:
Search - sql update
Search list
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: 601863 |
Author: 余辰 |
Hits:
Description: Use Master
exec sp_configure allow updates ,1 reconfigure with override
go
update sysdatabases set status = 32768 where name = sposmis
go
exec sp_dboption sposmis-Use Master exec sp_configure allow update s, a reconfigure go with override update sysdatab ases set status = 32768 where name = sposmis go ex ec sp_dboption sposmis
Platform: |
Size: 78837 |
Author: yang |
Hits:
Description: 这个程序提供了能过VC对SQL访问的功能,可以进行查询,更新等-this procedure can be provided over VC visit to the SQL functions, can query, update, etc.
Platform: |
Size: 110054 |
Author: 吕玉华 |
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: 133531 |
Author: zhangbo |
Hits:
Description: Private Declare Function DeleteFile Lib "kernel32" Alias "DeleteFileA" (ByVal lpFileName As String) As Long
'*************************************************************
Public Function ImportPhoto(sPicFile As String, sEmpID As String) As String
Dim rcsPic As ADODB.Recordset
Dim sMax As String
Dim sInsertPic As String
Dim rcsTemp As New Recordset
Dim sTempSQL As String
If Trim(sPicFile) = "" Then Exit Function
On Error GoTo ErrorImportPhoto
Set rcsPic = New ADODB.Recordset
rcsPic.CursorType = adOpenKeyset
rcsPic.LockType = adLockOptimistic '
rcsPic.Open "T_PPICTURE ", AstDbCnt, , , adCmdTable 'astdbcnt 替换为你连接方式
Set mstream = New ADODB.Stream
mstream.Type = adTypeBinary
mstream.Open
mstream.LoadFromFile sPicFile
rcsPic.AddNew
rcsPic.Fields("PERS").Value = sEmpID
rcsPic.Fields("PIC").Value = mstream.Read
rcsPic.Update
mstream.Close
Set mstream = Nothing
rcsPic.Close
Set rcsPic = Nothing
Exit Function
ErrorImportPhoto:
ImportPhoto = "FALSE"
End Function
'注意要将 AstDbCnt 替换为你的oracle 连接
Public Function DisplayPhoto(oPicture As PictureBox, sPicID As String)
Dim rcsDisplay As ADODB.Recordset
Set rcsDisplay = New ADODB.Recordset
Dim mstream As ADODB.Stream
Dim mc0 As String
rcsDisplay.Open "Select * from T_PPICTURE where PERS = '" & sPicID & "'", AstDbCnt, adOpenKeyset, adLockOptimistic
If rcsDisplay.EOF Then
oPicture.Picture = LoadPicture()
Exit Function
End If
If IsNull(rcsDisplay.Fields("PIC").Value) Then
oPicture.Picture = LoadPicture()
Exit Function
End If
Set mstream = New ADODB.Stream
mstream.Type = adTypeBinary
mstream.Open
mstream.Write rcsDisplay.Fields("PIC").Value
strclose = App.Path & "\AstPhoto_temp"
DeleteFile (strclose)
mstream.SaveToFile strclose
mstream.Close
Set mstream = Nothing
rcsDisplay.Close
Set rcsDisplay = Nothing
oPicture.Picture = LoadPicture(strclose)
End Function
Private Sub Command1_Click()
Set cn = New ADODB.Connection
cn.Open "Provider=SQLOLEDB;data Source=IWP2;Initial Catalog=T213;User Id=sa;Password=sql123"
Set rs = New ADODB.Recordset
rs.Open "Select * from QB_T213PMPD where DT=2006080818", cn, adOpenKeyset, adLockOptimistic
Set mstream = New ADODB.Stream
mstream.Type = adTypeBinary
mstream.Open
mstream.Write rs.Fields("MPI").Value
mstream.SaveToFile "P:\T213_data\ShowMPI\T213_3.mpi", adSaveCreateOverWrite
rs.Close
cn.Close
End Sub
Private Sub Command2_Click()
Set cn = New ADODB.Connection
cn.Open "Provider=SQLOLEDB;data Source=;Initial Catalog=pubs;User Id=;Password="
Set rs = New ADODB.Recordset
rs.Open "Select * from pub_info", cn, adOpenKeyset, adLockOptimistic
Set mstream = New ADODB.Stream
mstream.Type = adTypeBinary
mstream.Open
mstream.LoadFromFile ""
rs.Fields("logo").Value = mstream.Read
rs.Update
rs.Close
cn.Close
End Sub
Platform: |
Size: 3123 |
Author: wuzhiyong_130@163.com |
Hits:
Description: 这是个SQL语句和代码生成向导，当写字段较多的SQL语句时很省事，适用于Delphi、C++Builder。
通过本程序可以方便快速的生成对Oracle单表的Insert、Update、Delete语句和对应的Delphi组件。
如果你想对Oracle表进行Insert、Update、Delete操作，那么只要把通过本向导产生的组件和代码
粘贴在程序里就可以直接运行。
---------------------------------------
使用者须知：因为Oracle to_date函数写法太麻烦，所以我偷懒把所有日期时间型字段都用普通
字符串传递给Oracle，所以您必须在您的工程文件或者FormCreate等事件里显式调用
SQL语句 alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss。当然，如果你是个勤奋的
家伙也可以修改源码，全部加上to_date('yyyy-mm-dd hh24:mi:ss....:)
---------------------------------------
完善者须知：开发语言Delphi7，数据库连接方式：ADO
---------------------------------------
已知的BUG：因为C++Builder里不支持常量字符串相加，所以有时候编译不通过，小BUG，本人鄙视之，故没修改。
---------------------------------------
小技巧：在所有列表中都可以通过敲键盘来增量查找一个字符串；通过Ctrl+C键来复制列表内容。
---------------------------------------
如果有人修改此代码，希望发给我一份最新代码 :)。
帅帅软件出品，2005
http://www.handsomesoft.com
Platform: |
Size: 467191 |
Author: 15305709759@189.cn |
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: 一． （1）创建market数据库。
（2）创建客户表customer、供应商表supplier、商品信息表goods、订单信息表order、信誉等级表creditgrade和商品类型表goodstype。
（3）分别向以上各表输入数据。
（4）用INSERT语句向表中插入数据。
（5）用UPDATE语句更改表中数据。
（6）用DELETE语句删除表中数据。
-one. (1) the creation of the database market. (2) create client Table customer, vendor table supplier, commodity information table goods, orders for information table order, creditgrade credibility scales and the type of commodity goodstype table. (3) respectively to the above table data entry. (4) to use INSERT statement to insert the data table. (5) a UPDATE statement to change the data in the table. (6) a DELETE statement to delete data in the table.
Platform: |
Size: 16384 |
Author: |
Hits:
Description: 这个程序提供了能过VC对SQL访问的功能,可以进行查询,更新等-this procedure can be provided over VC visit to the SQL functions, can query, update, etc.
Platform: |
Size: 109568 |
Author: 吕玉华 |
Hits:
Description: 掌握SQL四条最基本的数据操作语句：Insert，Select，Update和Delete。
练掌握SQL是数据库用户的宝贵财 富。在本文中，我们将引导你掌握四条最基本的数据操作语句—SQL的核心功能—来依次介绍比较操作符、选择断言以及三值逻辑。当你完成这些学习后，显然你已经开始算是精通SQL了。
-master four basic SQL data manipulation statement : Insert, Select, Update and Delete. Training master SQL database users is a valuable asset. In this paper, We will guide you master the four basic data manipulation statements- the core functions of the SQL-were introduced to compare operator , and three choices asserted valued logic. When you are finished learning Obviously, as you have already started a proficient SQL.
Platform: |
Size: 10240 |
Author: h |
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: 对PL-SQL进行了介绍。包括基本的查询、更新、删除语句以及存储过程的编写。-Of PL-SQL are introduced. Including basic query, update, delete statements as well as the preparation of the stored procedure.
Platform: |
Size: 4117504 |
Author: lihui |
Hits:
Description: 自动更新程序演示
SectionStr = Updatefiles
SourcePath = http://192.168.1.39/SQL/update.ini
mainurl = http://192.168.1.39/-Automatic Update presentation
Platform: |
Size: 225280 |
Author: 李涛 |
Hits:
Description: SQL语句语法讲解,比如Insert、Update等，有详细实例说明。-SQL statement on the grammar, such as Insert, Update and so on, there is a detailed example.
Platform: |
Size: 30720 |
Author: 和上 |
Hits:
Description: 功能完善的自动升级系统
可以支持文件升级、数据库升级、升级文件处理三种功能
文件升级是通过文件复制来更新文件
数据库升级是这SQL脚本来进行更新
升级文件处理是执行一个升级包中的工具进行处理，此文件应为是一个EXE程序，是一个无界面的WIN32程序，用户可处理任务功能，比如文件清理，INI结构处理等。
本系统还提供了一个升级包制作工具，可以将需要文件通过可视化界面生成升级包
本系统还支持版本号管理，升级工具会识别最小升级版本号。-A update system with full funtions.
Platform: |
Size: 2015232 |
Author: 王志峰 |
Hits:
Description: PB 和 SQL数据库自动上传和更新的例子，PB9-PB and automatically upload and update the SQL database example, PB9
Platform: |
Size: 34816 |
Author: asdasd |
Hits:
Description: 数据定义
模式的创建和删除
基本表的创建、修改和删除
索引的创建和删除
数据操作
各类更新操作（插入数据(n) 、修改数据(1) 、删除数据(1) ）
各类查询操作（单表查询 、连接查询、嵌套查询 、集合查询）
视图操作
视图的创建、删除 、查询 、更新
-Data creation and deletion patterns define the basic table creation, modify and delete the index creation and deletion of data various operations update operations (insert data (n), modify the data (1), delete the data (1)) various types of queries ( single-table queries, join queries, nested queries, a collection of query) view action view to create, delete, query, update
Platform: |
Size: 2435072 |
Author: |
Hits:
Description: Labview Sql Toolkit 读研的时候，研究所老师花钱买的 外面下不到 需要的童鞋们有福了-The SQL Toolkit allows users to access and update databases from LabVIEW. LabVIEW interacts with a database through a database driver- the toolkit ships with drivers for many databases such as dBASE and FoxPro. A user is not limited to using the drivers that ship with the SQL Toolkit. For instance, if they already have Excel, they should configure their database to use the Microsoft supplied Excel driver. The SQL Toolkit establishes a database connection based upon information stored in the ODBC Administrator. ODBC is a database standard that specifies connectivity between database vendors. The ODBC Administrator is a Microsoft Utility that ships with the SQL Toolkit. It is also installed with other Microsoft Programs such as Excel or Access. The ODBC Administrator keeps track of databases through their DSN- data source name. Additional connection parameters (user name and password) and database attributes such as file cache size and locking can be specified in the ODBC Administrator a
Platform: |
Size: 3339264 |
Author: ganard |
Hits:
Description: 本课程主要介绍了高级子查询及SQL开发中级一测试知识。其中高级子查询主要包括单列子查询、多列子查询、相关子查询、Exists操作符、相关更新/删除、with子句。语言通俗易懂，概念清晰、深入浅出，易于学习。(This course mainly introduces the advanced sub query and the middle level test knowledge of SQL development. One senior sub query includes single query, multi query, Liezi Liezi related sub query, Exists operator, update / delete, with clause. The language is easy to understand, clear concept, easy to understand, easy to learn.)
Platform: |
Size: 4492288 |
Author: 黑茶某
|
Hits:
Description: 根据给定条件，自动生成insert/update语句(Automatically generate insert/update statements based on a given condition)
Platform: |
Size: 3072 |
Author: 昵称是个屁 |
Hits:
« 12
3
4
5
6
7
8
9
10
...
17
»