随笔分类 -  数据库编程

上一页 1 2 3 4 5 6 7 下一页
SQLSever,Oracle,PostgreSQL,MySQL,DB2,SQLite,MongoDB,HBase
Excel Metadata
摘要：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;u... 阅读全文
posted @ 2015-03-25 16:14 ®Geovin Du Dream Park™ 阅读(520) 评论(0) 推荐(0)
SQLite metadata
摘要：http://www.devart.com/dotconnect/sqlite/docs/MetaData.html https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.5.1 In this overload first p 阅读全文
posted @ 2015-03-24 12:35 ®Geovin Du Dream Park™ 阅读(607) 评论(0) 推荐(0)
DB2 Metadata
摘要：http://www.devart.com/dotconnect/db2/docs/MetaData.htmlInstead of specifying the metadata collection name as a string constant, you may use members of... 阅读全文
posted @ 2015-03-24 12:32 ®Geovin Du Dream Park™ 阅读(343) 评论(0) 推荐(0)
PostgreSQL Metadata
摘要：http://www.devart.com/dotconnect/postgresql/docs/MetaData.htmlIn this overload first parameter is name of a collection, and second parameter is the ar... 阅读全文
posted @ 2015-03-24 12:28 ®Geovin Du Dream Park™ 阅读(691) 评论(0) 推荐(0)
Oracle Metadata
摘要：http://www.devart.com/dotconnect/oracle/articles/metadata.htmlhttp://dcx.sybase.com/1101/en/dbprogramming_en11/ianywhere-data-sqlanywhere-saconnection... 阅读全文
posted @ 2015-03-24 12:26 ®Geovin Du Dream Park™ 阅读(484) 评论(0) 推荐(0)
MySQL Metadata
摘要：http://www.devart.com/dotconnect/mysql/docs/MetaData.html In this overload first parameter is name of a collection, and second parameter is the array 阅读全文
posted @ 2015-03-24 12:24 ®Geovin Du Dream Park™ 阅读(521) 评论(0) 推荐(0)
SQL Server Metadata
摘要：http://www.devart.com/dotconnect/sqlserver/docs/MetaData.htmlhttps://msdn.microsoft.com/en-us/library/ms254969.aspx SQL Server Schema CollectionsIn th... 阅读全文
posted @ 2015-03-24 12:23 ®Geovin Du Dream Park™ 阅读(392) 评论(0) 推荐(0)
sql:sql server,MySQL,PostgreSQL的表,视图,存储过程结构查询
摘要：sql server 2005: MySQL 6.7 #所有表的主键select * from information_schema.columns where table_schema='attend' and column_key='PRI'; PostgreSQL 8.4,9.3 sql se 阅读全文
posted @ 2015-03-21 14:51 ®Geovin Du Dream Park™ 阅读(1312) 评论(0) 推荐(0)
MySql:局域网和权限用户管理
摘要：MySql 5.6(XP)/5.7(win7) 添加用户和设置局域访问权限操作.请在http://sourceforge.net/ 下载MySql Control Center(不是安装版本).http://dev.mysql.com/doc/refman/5.7/en/grant.htmlMySq... 阅读全文
posted @ 2015-03-20 12:44 ®Geovin Du Dream Park™ 阅读(1062) 评论(0) 推荐(0)
sql:PostgreSQL
摘要：PostgreSQL sql script:-- Database: geovindu-- DROP DATABASE geovindu;CREATE DATABASE geovindu WITH OWNER = postgres ENCODING = 'UTF8' TAB... 阅读全文
posted @ 2015-02-12 15:23 ®Geovin Du Dream Park™ 阅读(720) 评论(0) 推荐(0)
csharp:SQLite and Access using C# code read data
摘要：SQLite sql script: SQLite 数据库连接字符 Csharp操作SQLite 添加返回值 Csharp操作Access添加返回值 https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki http 阅读全文
posted @ 2015-02-11 15:02 ®Geovin Du Dream Park™ 阅读(1018) 评论(0) 推荐(0)
sql:Mysql create view,function,procedure
摘要：create database Liber; use Liber; #顯示數据庫 20150210 Geovin Du 涂聚文 SHOW DATABASES; drop table BookKindList; #书目录 create table BookKindList ( BookKindID I 阅读全文
posted @ 2015-02-10 15:01 ®Geovin Du Dream Park™ 阅读(466) 评论(0) 推荐(0)
sql: MySQL and Microsoft SQL Server Stored Procedures IN, OUT using csharp code
摘要：MySQL存储过程:#插入一条返回值涂聚文注DELIMITER $$ DROP PROCEDURE IF EXISTS `geovindu`.`proc_Insert_BookKindOut` $$ CREATE PROCEDURE `geovindu`.`proc_Insert_BookKindO... 阅读全文
posted @ 2015-02-10 11:39 ®Geovin Du Dream Park™ 阅读(437) 评论(0) 推荐(0)
sql server or Oracle: table MS_Description
摘要：Oracle: 阅读全文
posted @ 2015-01-24 13:52 ®Geovin Du Dream Park™ 阅读(1669) 评论(0) 推荐(0)
sql: TRIGGER
摘要：--Common Table Expressions(CTE)WITH HighSample (SampleId,SampleTitle,SampleContent) AS( SELECT SampleId,SampleTitle,SampleContent From CompetitionS... 阅读全文
posted @ 2015-01-21 11:50 ®Geovin Du Dream Park™ 阅读(530) 评论(0) 推荐(0)
WHILE (Transact-SQL)
摘要：---循环declare @n intdeclare @rowcount int declare @name varchar(50)create table #temp( id int identity(1,1), ColumnNme nvarchar(100))insert into #temp ... 阅读全文
posted @ 2015-01-15 11:52 ®Geovin Du Dream Park™ 阅读(326) 评论(0) 推荐(0)
sql server query to get the list of column name in a table
摘要：--SQL Server 2005, 2008 or 2012:SELECT * FROM information_schema.tables--SQL Server 2000:SELECT * FROM sysobjects WHERE xtype='U' SELECT * FROM sysobj... 阅读全文
posted @ 2015-01-06 22:23 ®Geovin Du Dream Park™ 阅读(885) 评论(0) 推荐(0)
sql: T-SQL 统计计算（父子關係,樹形，分級分類的統計）
摘要：---sql: T-SQL 统计计算（父子關係,樹形，分級分類的統計）---2014-08-26 塗聚文(Geovin Du)CREATE PROCEDURE proc_Select_BookKindSumReportASDECLARE @temp TABLE( BookKindID IN... 阅读全文
posted @ 2014-08-26 12:54 ®Geovin Du Dream Park™ 阅读(801) 评论(0) 推荐(0)
sql: T-SQL parent-child function script
摘要：--Parent-Child reationship --涂聚文 2014-08-25 --得位置的子節點函數表（包含本身） if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetBookPlaceChild 阅读全文
posted @ 2014-08-25 16:09 ®Geovin Du Dream Park™ 阅读(282) 评论(0) 推荐(0)
Recursive sum in parent-child hierarchy T-SQL
摘要：---树形（父子关系类）分级类统计（父子统计）--涂聚文 2014-08-14drop table BookKindListcreate table BookKindList( BookKindID INT IDENTITY(1,1) PRIMARY KEY, BookKindName ... 阅读全文
posted @ 2014-08-14 16:21 ®Geovin Du Dream Park™ 阅读(364) 评论(0) 推荐(0)

上一页 1 2 3 4 5 6 7 下一页