Search - Update

Search - Update - List

[SQL Server] 读写SQL中的image字段.zip DL : 0: 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
Date : 2009-04-21 Size : 3.05kb User : wuzhiyong_130@163.com
[SQL Server] 图书系统设计 DL : 0: 利用Visual C#建立一个数据库，对图书资料实行计算机管理。降低资料管理的成本，提高工作效率。同时也可大大降低手工录入时的繁重工作量以及减少录入时的错误及查询带来的不便。并且可灵活对图书资料进行插入、删除、更新等操作。-Visual C# to establish a database of information on the library computer management. To reduce data management costs and improve efficiency. It can also greatly reduce the manual input of the heavy workload and reduce input error and the inconvenience resulting from the inquiry. Flexibility and information on books, insert, delete, update, etc.
Date : 2026-01-23 Size : 321kb User : 黄斌
[SQL Server] 访问SQL DL : 0: 这个程序提供了能过VC对SQL访问的功能,可以进行查询,更新等-this procedure can be provided over VC visit to the SQL functions, can query, update, etc.
Date : 2026-01-23 Size : 107kb User : 吕玉华
[SQL Server] lunwentijiao DL : 0: 论文提交系统，采用jsp技术，实现数据库的连接，提交，查找，更新，等功能。-papers submitted, using jsp technology, database connectivity, submission, locate, update capabilities.
Date : 2026-01-23 Size : 6kb User : 杨阳
[SQL Server] simpleSQL DL : 0: 由visual basic编写的的简单SQL数据库系统，可以实现更新，插入等基本功能。对sql初步设计编程有很好的制导作用。-by visual basic preparation of a simple SQL database system, can achieve update Insert and other basic functions. Sql preliminary design of the program is very good guidance role.
Date : 2026-01-23 Size : 30kb User : 刘扬
[SQL Server] wangjiejob1 DL : 0: 一个数据库的小例子实现了查询修改更新闪出各种操作并能对基本表进行删除-a small example of database inquiries realized Update shining various operational and is able to delete the basic table
Date : 2026-01-23 Size : 1kb User : wangjie
[SQL Server] gz_pub DL : 0: 可以根据身份证查工资，可以通过EXCEL批量导入数据库，可以在线管理，添加、修改、批量删除记录，在线管理数据库文件，在线修改密码，首页说明 v1.5 修正版更新：完善了一些功能，修改了一些漏洞-under investigation wage identity, through Excel Batch into databases, and online management, adding, changes batch delete records, online document management database, online alter the code, covering note that version v1.5 Update : improved some function, and revised some loopholes
Date : 2026-01-23 Size : 606kb User : 国学
[SQL Server] notesystem1 DL : 0: 留言系统, 可以注册,管理,删除,更新,just do it!-Message System, you can register, manage, delete, update, just do it!
Date : 2026-01-23 Size : 261kb User : 许尚敏
[SQL Server] shujuku DL : 0: 根据事务需求（详见所给材料）中的每一项要求，写出相关的存储过程。说明： 1）“创建”记录就是在存储过程中使用Insert语句实现插入新记录的功能； 2）“维护”记录包括更新和删除数据库中的记录，要求完成更新功能，删除功能可选； 3）查询功能要求较多，灵活运用所学SQL编程知识来完成。 -In accordance with Service requirements (see the given material) in each of the requirements, write a stored procedure-related. Description: 1) create records in the stored procedure is used to achieve Insert statement to insert a new record function 2) preserve records including updating and deleting database records, the requirements to complete the update function, delete function optional 3) query the functional requirements of more flexible use of learned knowledge to the completion of SQL programming.
Date : 2026-01-23 Size : 9kb User : 赵珍
[SQL Server] sheji DL : 0: 根据事务需求（详见所给材料）中的每一项要求，写出相关的存储过程。说明： 1）“创建”记录就是在存储过程中使用Insert语句实现插入新记录的功能； 2）“维护”记录包括更新和删除数据库中的记录，要求完成更新功能，删除功能可选； 3）查询功能要求较多，灵活运用所学SQL编程知识来完成。 -In accordance with Service requirements (see the given material) in each of the requirements, write a stored procedure-related. Description: 1) create records in the stored procedure is used to achieve Insert statement to insert a new record function 2) preserve records including updating and deleting database records, the requirements to complete the update function, delete function optional 3) query the functional requirements of more flexible use of learned knowledge to the completion of SQL programming.
Date : 2026-01-23 Size : 8kb User : 赵珍
[SQL Server] jiaohu DL : 0: 1. 掌握SQL的数据定义、数据操纵功能 2. 利用SQL语句进行多表查询和嵌套查询 3. 掌握SQL数据定义中修改、删除表功能 4. 掌握SQL语句中数据更新相关操作 5. 掌握视图基本操作：定义、查询、更新视图。 -1. Grasp the SQL data definition, data manipulation functions 2. The use of SQL statements for multi-table query and nested query 3. Master modify SQL data definition, delete the table function 4. Grasp the SQL statement to update data related to operations 5. Master view basic steps: define, query, update the view.
Date : 2026-01-23 Size : 329kb User : 赵珍
[SQL Server] student DL : 0: 具有添加,删除,修改,更新的功能,用ado读ini文件访问数据库-With add, delete, modify, update function, using ado Reading ini file access database
Date : 2026-01-23 Size : 9.16mb User : 李真志
[SQL Server] DATABASETOOLS DL : 0: SQL数据库工具就是一种即可以进行数据浏览、添加、删除和修改等数据库管理操作，又可以数据库的备份和还原操作，还可以自动地根据需要产生各种SQL语句（包括了SELECT、UPDATE、DELETE、INSERT等SQL语句）的数据库工具，将为数据库管理员和数据库软件开发人员提供极大的方便。-SQL is a database tool for data that can browse, add, delete and modify operations, such as database management, but also database backup and restore operations can also be automatically generated according to the needs of a variety of SQL statements (including the SELECT, UPDATE, DELETE , INSERT statement, such as SQL) database tools for database administrators and database software developers to provide great convenience.
Date : 2026-01-23 Size : 49kb User : 车林
[SQL Server] DBClass DL : 0: 数据库操作接口类，提供数据库连接、记录插入、更新、删除等-Database operations interface type, to provide database connectivity, record insert, update, delete, etc.
Date : 2026-01-23 Size : 1kb User :
[SQL Server] MyTest1 DL : 1: 本实例是vc+SQL server小程序,具有数据库的简单查询，更新，删除记录等功能，本程序的查询功能是基于头部匹配的模糊查询。-This example is vc+ SQL server applet with a simple database query, update, delete records and other functions, the procedures for the inquiry is based on the fuzzy query matching head.
Date : 2026-01-23 Size : 410kb User : venus
[SQL Server] tushuguanlixitong DL : 0: 图书管理系统,读者可以实现对图书的浏览,查询等功能.管理员能够实现图书的添加,更新-Library management system, readers can be achieved on the books to browse, query and other functions. Administrators to realize a book to add, update
Date : 2026-01-23 Size : 105kb User :
[SQL Server] SQL1 DL : 0: 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语言是非过程化的语言、统一的语言、是所有关系数据库的公共语言。
Date : 2026-01-23 Size : 36kb User : zhangbo
[SQL Server] SQL_Examplt DL : 0: SQL语句语法讲解,比如Insert、Update等，有详细实例说明。-SQL statement on the grammar, such as Insert, Update and so on, there is a detailed example.
Date : 2026-01-23 Size : 30kb User : 和上
[SQL Server] update DL : 1: PB 和 SQL数据库自动上传和更新的例子，PB9-PB and automatically upload and update the SQL database example, PB9
Date : 2026-01-23 Size : 34kb User : asdasd
[SQL Server] Data-update DL : 0: 数据更新（插入、修改和删除）学会在企业管理器中对表进行插入、修改和删除数据操作。学会使用SQL语句对表进行插入、修改和删除数据操作。了解SQL语句对表数据库操作的灵活控制功能。 -Data update (insert, modify, and delete) The table to insert, modify and delete the data operation in enterprise manager. Learn how to use the SQL statement table insert, modify and delete the data operation. Understand the flexible control functions of the SQL statement on the operation of the .
Date : 2026-01-23 Size : 1.37mb User : Nancy

« 12 3 4 5 6 »