Data
WuOu
Coding,Design Pattern
展开
-
SQL Join sentence
student no‚name‚classid‚1‚ zdy‚2‚2‚huz‚2‚3‚yxx‚2‚4‚sss‚1‚classclassid‚classname‚2‚y2002‚3‚y2003‚1 .select * from student ‚ class where student.classid=class.classidno‚name‚classid‚classid‚cla原创 2008-03-19 15:38:00 · 877 阅读 · 0 评论 -
Sql server database cursor operating summary 02
1.Creating cursor.Syntax:DECLARE cursor_name [INSENSITIVE] [SCROLL] CURSORFOR SELECT_statement[FOR {READ ONLY|UPDATE [OF column_name [,...n]]}]DECLARE hpCamera_DelCursor CURSORFOR SELECT * F原创 2008-05-09 09:49:00 · 688 阅读 · 0 评论 -
SQL Server Stored Procedures for Beginners
SQL Server Stored Procedures for Beginners Learning something new is challenging. Learning something new on your own redefines challenging.Chances are, you arereading my article because you原创 2008-07-21 09:50:00 · 1138 阅读 · 0 评论 -
Using LINQ to SQL (Part 1)
Over the last few months I wrote aseries of blog posts that covered some of the new language featuresthat are coming with the Visual Studio and .NET Framework "Orcas"release. Here are pointers原创 2008-07-25 09:43:00 · 816 阅读 · 0 评论 -
A First Look at SQL Server 2005 for Developers:Introduction
Introduction SQL SERVER 2005 contains features that constitute the biggest change since the internal server rewrite of SQL Server 7.This is true from both programmability and data model viewpoints转载 2008-07-28 10:00:00 · 674 阅读 · 0 评论 -
SQL Server Stored Procedures instance
-- =============================================-- Author: Kelvin -- Create date: 2008-7-30-- Description: Test performance to insert 100,000 records.-- ==================================原创 2008-07-31 14:07:00 · 653 阅读 · 0 评论 -
CSharp读写SQL Server数据库中的Image列
数据库表结构:IF EXISTS (SELECT name FROM sysobjects WHERE name = ´Content´ AND type = ´U´) DROP TABLE ContentGOcreate table Content( --内容ID Id bigint IDENTITY(1,1) NOT NULL, --内容 data image default null, C原创 2008-08-01 10:21:00 · 1615 阅读 · 0 评论 -
SQL命令大全-中英文对照
-语 句 功 能 --数据操作 SELECT --从数据库表中检索数据行和列 INSERT --向数据库表添加新数据行 DELETE --从数据库表中删除数据行 UPDATE --更新数据库表中的数据 --数据定义 CREATE TABLE --创建一个数据库表 DROP TABLE --从数据库中删除表 ALTER TABLE --修改数据库表结构 CRE原创 2009-03-24 00:31:00 · 694 阅读 · 0 评论 -
Oracle数据库分区表操作方法
Oracle数据库分区表操作方法(2009-10-19 16:20:45) 标签:杂谈 摘要:在大量业务数据处理的项目中,能考虑使用分区表来提高应用系统的性能并方便数据管理,本文周详介绍了分区表的使用。 在大型的企业应用或企业级的数据库应用中,要处理的数据量通常能达到几十到几百GB,有的甚至能到TB级。虽然存储介质和数据处理技术原创 2010-03-04 20:29:00 · 845 阅读 · 0 评论 -
Sql server database syntax reference 02
GOTO label sentenceSyntax:label:GOTO label1.statement:DECLARE @count SMALLINTSELECT @count=1Restart:PRINT helloSELECT @count=@count+1WHILE @countgoto Restart2.results:output原创 2008-05-08 10:52:00 · 609 阅读 · 0 评论 -
Sql server database trigger operating summary 01
1.Creating a trigger:Syntax:CREATE TRIGGER trigger_name ON {table_name|view_name}[WITH ENCRYPTION]{ { {FOR|AFTER|INSTEAD OF} { [DELETE][,][INSERT][,][UPDATE] } [NOT FOR REPLICATION]AS[{IF原创 2008-05-09 14:53:00 · 758 阅读 · 0 评论 -
Sql server database cursor operating summary 01
1.Creating cursor.Syntax:DECLARE cursor_name [INSENSITIVE] [SCROLL] CURSORFOR SELECT_statement[FOR {READ ONLY|UPDATE [OF column_name [,...n]]}]DECLARE Camera_Cursor SCROLL CURSORFOR SELECT C原创 2008-05-08 15:08:00 · 623 阅读 · 0 评论 -
Retore database from a back up file.
RESTORE DATABASE [GZPSS] FROM DISK = NG:/DB bak/2008-5-03-15-48 WITH FILE = 1, NOUNLOAD, STATS = 10 ,REPLACE原创 2008-05-04 09:49:00 · 689 阅读 · 0 评论 -
Sql server database operating summary 01
SqlConnection sqlConnection=null;SqlCommand sqlCommand=null;string connectStr="server=172.31.112.200;Database=GZPSS;user id=sa;password=1234Qwer";sqlConnection=new SqlConnection(connectStr);sqlC原创 2008-05-06 09:09:00 · 659 阅读 · 0 评论 -
Sql server stored procedure operating summary 01
Syntax:GRANT CREATE PROCEDURE username /* assign to create stored procedure right to the username user*/CREATE PROCEDURE procedure_name [;version number][{@paramenter data_type}[VARYING][=defaul原创 2008-05-07 11:26:00 · 644 阅读 · 0 评论 -
Sql server database:create table-valued function
Syntax:CREATE FUNCTION [owner_name.] function_name([{@parameter_name[AS]scalar_parameter_data_type[=default]}[,...n])RETURNS TABLE[WITH {ENCRYPTION|SCHEMABINDING}][AS]RETURN [()SELECT-statem原创 2008-05-07 15:01:00 · 1291 阅读 · 0 评论 -
Sql server database stored procedure reference 01
Stored procedure://BEGINALTER PROCEDURE [dbo].[putpending](@cuuser nvarchar(1000), @iuser nvarchar(1000))ASDeclare @sql nvarchar(1000)SELECT @sql = INSERT INTO +@cuuser + (Pending) VALUES原创 2008-05-07 11:47:00 · 680 阅读 · 0 评论 -
Sql server database:create scalar-valued function
Syntax:CREATE FUNCTION [owner_name.]function_name ([{@parameter_name[AS] scalar_parameter_data_type[=default]}[,...n]])RETURNS scalar_return_data_type[WITH {ENCRYPTION|SCHEMABINDING}][AS]BEG原创 2008-05-07 14:12:00 · 1370 阅读 · 0 评论 -
Sql server database:create table-valued function 02
Syntax:CREATE FUNCTION [owner_name.] function_name([{@parameter_name[AS]scalar_parameter_data_type[=default]}[,...n]])RETURNS @return_variable TABLE({column_definition|table_constraint}[,...n])[原创 2008-05-08 09:29:00 · 891 阅读 · 0 评论 -
Sql server database syntax reference 01
IF...ELSE sentenceSyntax:IF boolean_expression statement[ELSE[IF boolean_expression] statement]1.statement:IF (SELECT MAX(Longitude) FROM Camera) > 23.0 BEGIN PRINT 经度的最大值大于23.0原创 2008-05-08 10:37:00 · 671 阅读 · 0 评论 -
海量数据(数据量比较大时)的处理分析
海量数据(数据量比较大时)的处理分析 海量数据处理问题是一项艰巨而复杂的任务。原因有以下几个方面:一、数据量过大,数据中什么情况都可能存在。如果说有10条数据,那么大不了每条去逐一检查,人为处理,如果有上百条数据,也可以考虑,如果数据上到千万级别,甚至过亿,那不是手工能解决的了,必须通过工具或者程序进行处理,尤其海量的数据中,什么情况都可能存在,例如,数据中某处格式出了问题,尤其在程序处理原创 2010-03-04 20:54:00 · 1221 阅读 · 0 评论