随笔分类 -  DataBase

摘要：internal class AccessSchema { private Field GetAccessField(string connectionString, string tbName, DataRow r) { Field field = new Field(); field.AllowNull = ObjectHelper.GetBool(r["IS_NULLABLE"]); field.DefaultValue = ObjectHelper.GetString(r["COLUMN_DEFAULT"]); field.FieldDescn 阅读全文

摘要：internal class MySqlSchema { public bool GetSchema(Database database) { string str; string connectionString = database.ConnectionString; Match match = Regex.Match(connectionString, @"Database=(?<Database>[^\;]*);"); if (match.Success) { str = match.Groups["Database"].Value; 阅读全文

摘要：internal class SqlSchema { private string SqlForGetStoreProcedures = "select distinct(name) from sysobjects where type='p' "; public string SqlForGetViews = "select distinct(name) from sysobjects where type='v' "; private Database.DatabaseType type; public bool Ge 阅读全文

摘要：Sql 合并行如下：IDName1Tom1John2Carrier2Wendy1Rick要求显示下列结果IDName1Tom,John,Rick2Carrier,WendySql:select id,（SELECT STUFF(b.v.value('/r[1]','varchar(100)'),1,1,'')FROM(SELECT v=(SELECT ',' + Name FROM TableName where id=c.idFOR XML PATH(''),ROOT('r'),TYPE)) b） 阅读全文

摘要：1.获取Return返回值程序代码//存储过程//Create PROCEDURE MYSQL// @a int,// @b int//AS// return @a + @b//GOSqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString());conn.Open();SqlCommand MyCommand = new SqlCommand("MYSQL", conn);MyCommand.Comman 阅读全文

摘要：IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE XTYPE = 'U' AND NAME = 'AUTHORIZE_ORDER_HEADER')DROP TABLE AUTHORIZE_ORDER_HEADER 阅读全文

摘要：如下存储过程可以实现将SQL Server中的数据导出到脚本setANSI_NULLSONsetQUOTED_IDENTIFIERONGOALTERproc[dbo].[proc_insert](@tablenamevarchar(256))asbeginsetnocountondeclare@sqlstrvarchar(4000)declare@sqlstr1varchar(4000)declare@sqlstr2varchar(4000)select@sqlstr='select''insert'+@tablenameselect@sqlstr1=' 阅读全文