Location:
Search - select from
Search list
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: 76191 |
Author: 闫成明 |
Hits:
Description: 顺序统计select算法。从s个元素中找出第k个大的元素。- The order counts the select algorithm. Discovers the kth big
element from s element.
Platform: |
Size: 964 |
Author: 颜小佳 |
Hits:
Description: request类
取代ASP中的Request对象。新Request2对象与原Request对象相比，增加了防SQL注入功能，集成了无组件上传功能。
使用方便，新旧对象使用方法极为类似。比如原来的写法是Request.Form(\"aa\")，现在的写法是Request2.Form(\"aa\")；原来的写法是Request.QueryString(\"bb\")，现在的写法是Request2.QueryString(\"bb\")；原来的写法是Request(\"cc\")，现在的写法是Request2(\"cc\")。
增加了防SQL注入功能。直接写Set rs = Conn.Execute(\"select * from tb where dd= \"&Request2.Form(\"dd\")&\" \")即可。
集成了无组件上传功能。如果表单中含有<input type=file name=ff>，则可以直接通过Request2.Form(\"ff\")得到上传的文件对象，并通过Request2.SaveAs方法将客户端上传的文件保存在服务器上，也可以使用Request2.AutoSave方法自动更名保存。
Ver 2.0 版本增加了Form2集合，用于处理表单元素多值的情况，例如checkbox的多选取值。-request to replace the ASP Object Request. New Request2 Object Request with the original target, an increase of anti-function SQL injection, Non-component integrated upload function. Easy to use, use of old and new object is very similar. For example, the original wording of the Request.Form ( "aa") the current wording of the Request2.Form ( "aa"); the original wording of the Request.QueryString ( "bb") the current wording of the Request2.QueryString ( "bb"); the original wording of the Request ( "cc") the current wording of the Request2 ( "cc"). Increased anti-function SQL injection. Direct write Set rs = Conn.Execute ( "select * from tb wher e dd = "
Platform: |
Size: 28862 |
Author: mars |
Hits:
Description: 一个vb开发,可以动态生成SQL的\"拼装类\".
例如:
sql.strsql=\"select ? from ? \"
sql.setFieldEx \"field1\"
sql.setFieldEx \"tbl\"
debug.print sql.strsql
输出:select field from tbl-a vb development, dynamically generated SQL "assembled category." For example : sql.strsql = "select from" sql.setFieldEx "fi eld1 "sql.setFieldEx" tbl "debug.print sql.s trsql output : select field from tbl
Platform: |
Size: 3740 |
Author: 张正立 |
Hits:
Description: f exists (select * from dbo.sysobjects where id = object_id(N [dbo].[IBP_T_EA_IBP_T_User_FK1] ) and OBJECTPROPERTY(id, N IsForeignKey ) = 1)
ALTER TABLE [dbo].[IBP_T_User] DROP CONSTRAINT IBP_T_EA_IBP_T_User_FK1
GO-f exists (select * from dbo.sysobjects where id = object_id (N [
dbo ]. [ IBP_T_EA_IBP_T_User_FK1 ]) and OBJECTPROPERTY (id, N
IsForeignKey) = 1) ALTER TABLE [ dbo ]. [ IBP_T_User ] DROP CONSTRAINT
IBP_T_EA_IBP_T_User_FK1 GO
Platform: |
Size: 556839 |
Author: lidonghui |
Hits:
Description: 自己做的边缘提取方面的源码。适于学生大作业。-themselves from the edge of the source. Suitable for most of the students work.
Platform: |
Size: 197684 |
Author: 王豫东 |
Hits:
Description: JoSQL 1.5的源代码。JoSQL(SQL for Java Objects)为Java开发者提供运用SQL语句来操作Java对象集的能力.利用JoSQL可以像操作数据库中的数据一样对任何Java对象集进行查询,排序,分组。比如要查找所有的Html文件：SELECT * FROM java.io.File Where name $Like \"％html\"
-JoSQL 1.5 source code. JoSQL (SQL for Java Objects) to provide Java developers using SQL language sentence to operate a set of Java objects capacity. JoSQL can use as operational data in the database, like any J ava object set to conduct inquiries, sorting, grouping. For example, to find all the Html documents : SELECT * FROM java.io.File $ Like Where name "% h Page 13 13 "
Platform: |
Size: 371923 |
Author: vkuang |
Hits:
Description: <％@ LANGUAGE=\"VBSCRIPT\" ％>
<!--#include file=\"conn.asp\" -->
<％
ProductClass_2=request(\"ProductClass_2\")
set rs=server.createobject(\"adodb.recordset\")
sqltext=\"select * from Product\"
if request(\"Product_Name\")<>\"\" then
sqltext=sqltext &\" where Product_Name like ％\"& request(\"Product_Name\") &\"％ \"
else
sqltext=sqltext &\" where Product_Name like ％\"& \"\" &\"％ \"
end if
if request(\"Product_Class\")<>\"\" then
sqltext=sqltext &\" and Class_1 like ％\"& request(\"Product_Class\") &\"％ \"
end if
Platform: |
Size: 3531 |
Author: 金立犇 |
Hits:
Description: <％@ LANGUAGE=\"VBSCRIPT\" ％>
<!--#include file=\"conn.asp\"-->
<％
set rs=server.createobject(\"adodb.recordset\")
sqltext=\"select * from RegUser where UserId= \" & request.form(\"uid\") & \" \"
rs.open sqltext,co
Platform: |
Size: 6078 |
Author: 金立犇 |
Hits:
Description: 利用WMI监视进程的创建
Private Sub StartMonitorCreateProcessEvent()
Set CreateProcessEvent = New SWbemSink
Set objSWbemServices = GetObject(\"winmgmts:\\\\.\\root\\cimv2\")
objSWbemServices.ExecNotificationQueryAsync CreateProcessEvent, \"SELECT * FROM __InstanceCreationEvent WITHIN 1 WHERE TargetInstance ISA Win32_Process \"
End Sub
Platform: |
Size: 2298 |
Author: 风飞雪 |
Hits:
Description: using System
using System.Collections.Generic
using System.Text
using DataAccess
using System.Data
namespace Business
{
public class SalesTable
{
DataOperate temp = new DataOperate(\"server=. uid=sa pwd=sa database=pubs\")
public DataTable GetSales()
{
try
{
string sql = \"select * from sales\"
return temp.GetDataBySql(sql, \"sales\").Tables[\"sales\"]
}
catch (Exception ex)
{
throw new Exception(ex.Message)
}
}
}
}
Platform: |
Size: 7133 |
Author: 兜兜 |
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: 顺序统计select算法。从s个元素中找出第k个大的元素。- The order counts the select algorithm. Discovers the kth big
element from s element.
Platform: |
Size: 1024 |
Author: 颜小佳 |
Hits:
Description: 通信工程ＭＡＴＬＡＢ仿真
从Simulink的Sources中选择From Workspace，用鼠标将其拖到设计窗口中；
从Simulink的Sources中选择Sine Wave，用鼠标将其拖到设计窗口中；
从Simulink的Math中选择Product，用鼠标将其拖到设计窗口中；
从Simulink的Sinks中选择Scope，用鼠标将其拖到设计窗口中-Communication Engineering from the Simulink of MATLAB simulation Sources Select From Workspace, use the mouse to drag the design window
Platform: |
Size: 8166400 |
Author: yangzhen |
Hits:
Description: mysql的接口实现
执行sql语句
example: select * from t_text -mysql interface to achieve the implementation of sql statement example: select* from t_text
Platform: |
Size: 3072 |
Author: genser |
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子查询语言笔记:子查询的分类 单行的语法 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: SELECT * FROM table_name
Platform: |
Size: 3072 |
Author: name |
Hits:
Description: 从5个人中选取2个人作为礼仪
要从5个人中选取2个人作为礼仪，其中每个人的身高范围为160-190，要求2个人的身高差值最小（如果差值相同的话，选取其中最高的两人），以升序输出两个人的身高。
-Select from five people in two individuals as a liturgical five individuals selected from two individuals as a ritual in which each person' s height in the range of 160-190, the height difference between two individuals requires minimal (if the difference is the same, then select one of the highest two), in ascending order of height of the two outputs.
Platform: |
Size: 888832 |
Author: 吴少华 |
Hits:
« 12
3
4
5
6
7
8
9
10
...
48
»