CodeBus
www.codebus.net
Search
Sign in
Sign up
Hot Search :
Source
embeded
web
remote control
p2p
game
More...
Location :
Home
Search - c select
Main Category
SourceCode
Documents
Books
WEB Code
Develop Tools
Other resource
Sub Category
Oracle
SQL Server
MySQL
Other Databases
Search - c select - List
[
SQL Server
]
W2kSqlextendedproc
DL : 0
BCB 编写的一些简单函数用于SQL的扩展存储过程. -检查文件是否存在Select dbo.FileExist( c:\boot.ini ) --删除文件Select dbo.FileDelete( C:\X.txt ) --服务状态Select dbo.ServerStat( awhost32 ,1) --建立目录Select dbo.MKDIR( C:\Test\test ,1) --文件复制Select dbo.FileCopy( C:\boot.ini , c:\Boot\YYY.ini ,1) --删除目录Select dbo.RDDIR( C:\Text ,1) --锁定计算机Select dbo.LockPc() --结束程序Select dbo.KillPorg( Notepad.exe ) --执行程序Select dbo.StartPorg( Notepad.exe ) --得到IP地址Select dbo.GetIP() --分解字符Select dbo.TextPart( 123*456*789 , * ,0) QQ:254082939 Email:haihong5995037@163.com-BCB prepared by the simple function for the expansion of SQL stored procedures.- Check file exists Select dbo.FileExist (c : \ boot.ini file)-- Select dbo.FileDelete delete the file (C : \ X.txt)-- state services Select dbo.ServerStat (awhost32, 1)-- Select dbo.MKDIR build directory (C : \ Test \ test, 1)-- Select copy dbo.FileCopy (C : \ boot.ini file, c : \ Boot \ 9985360E. ini, 1)-- Select dbo.RDDIR delete directory (C : \ Text, 1)-- Computer Select dbo.LockPc lock ()-- Select dbo.KillPorg closing procedures (Notepad.exe)-- Select dbo implementation procedures. StartPorg (Notepad.exe)-- Select IP addresses to be dbo.GetIP ()-- Select decomposition characters dbo.TextPart (123* 456* 789*, 0) QQ : 254082939 Email : haihong5995037@163.com
Date
: 2025-12-23
Size
: 555kb
User
:
耿海瑞
[
SQL Server
]
200641016498311
DL : 0
1.先建立数据库HOTEL 2.选中HOTEL数据库,选择所有任务->还原数据库 选择数据库文件中的hotelBackup,还原数据库 3.将源程序中 C***App类中构造函数中,链接数据库的帐号和密码更改为你的密码 即可使用 4.本软件未完成,你可以根据需求,加入更丰富的功能。 5.Release目录下面的*.ssk 和*.dll不能删除,那是加载皮肤所需要的 -1. First establish a database HOTEL 2. HOTEL selected database, select all the tasks-
Date
: 2025-12-23
Size
: 561kb
User
:
李隆
[
SQL Server
]
dvsjkfjn
DL : 0
SQL中的单记录函数 1.ASCII 返回与指定的字符对应的十进制数 SQL> select ascii( A ) A,ascii( a ) a,ascii( 0 ) zero,ascii( ) space from dual A A ZERO SPACE --------- --------- --------- --------- 65 97 48 32 2.CHR 给出整数,返回对应的字符 SQL> select chr(54740) zhao,chr(65) chr65 from dual ZH C -- - -zxvc ascascaSCASCAS
Date
: 2025-12-23
Size
: 67kb
User
:
fwef
[
SQL Server
]
sqlCSLJ
DL : 1
C#环境下,和数据库相关的select,insert,update等基本操作的类。-C# environment, and databases related to select, insert, update, such as the type of basic operation.
Date
: 2025-12-23
Size
: 10kb
User
:
净
[
SQL Server
]
DistillSQL
DL : 0
本实例通过Visual C++实现了SQL数据库提取器的功能。运行本实例,可登陆当前选择的服务器,并获得服务器中所有数据库的信息,选择一个数据库及数据库中的数据表,该表的结构信息将显示在下方的列表中,并可以将该表的结构信息导入到WORD文档中和EXCEL表格中-In this instance by Visual C++ implementation of the SQL database extractor functions. Run this example can be found at the currently selected server, and get all the information in the database server, select a database and data in a database table, the table structure information will be displayed in the list below, and can form the structure of the information into WORD documents and EXCEL table
Date
: 2025-12-23
Size
: 287kb
User
:
周凡
[
SQL Server
]
5
DL : 0
Visual C#2008的SQL查询与图表技朮。包括多表连接条件查询,分组条件查询,排序查询,嵌套查询,视图在Select查询语句中的应用,存储过程在Select查询语句中的应用等。-Visual C# 2008 for SQL queries and chart technology. Conditions including multi-table join queries, grouping condition query, sort, query, nested query, view the query in the Select the application, the stored procedure in the Select the application of the query.
Date
: 2025-12-23
Size
: 652kb
User
:
caoyanling
[
SQL Server
]
Useful-SQL-statement
DL : 0
十分有用的SQL语句, select a.S# from (select s#,score from SC where C#= 001 ) a,(select s#,score from SC where C#= 002 ) b where a.score>b.score and a.s#=b.s#-Useful SQL statement select a.S# from (select s#,score from SC where C#= 001 ) a,(select s#,score from SC where C#= 002 ) b where a.score>b.score and a.s#=b.s#
Date
: 2025-12-23
Size
: 4kb
User
:
万成
[
SQL Server
]
Web-Select-Course-System
DL : 0
网上选课系统 C# AND Sql Server 实现学生网上选课的基本功能-Online Course Selection System C# AND Sql Server to achieve the basic functions of Students Online Course
Date
: 2025-12-23
Size
: 7.59mb
User
:
Louie.Wang
[
SQL Server
]
SQL2000SampleDb
DL : 0
数据库SQLSERVER2000后就不自带示例数据库了,这个是示例数据库的脚本 安装方法: 1、安装SQL2000SampleDb.msi后在C盘下有目录SQL Server 2000 Sample Databases,该目录下有instnwnd.sql、instpubs.sql脚本 2、打开SSMS,“文件---打开---文件”选择上面两个脚本即可创建示例数据库(After the database SQLSERVER2000, the sample database is not brought with it. This is the script of the sample database Installation method: 1, after the installation of SQL2000SampleDb.msi SQL Server 2000 Sample Databases directory in instnwnd.sql, C, instpubs.sql scripts in the directory 2, open SSMS, "file -- Open -- File" select the top two scripts to create the sample database)
Date
: 2025-12-23
Size
: 1.15mb
User
:
Vooyin
CodeBus
is one of the largest source code repositories on the Internet!
Contact us :
1999-2046
CodeBus
All Rights Reserved.