摘要： CREATE PROCEDURE ProGetColumnInfo(TableName varchar(50))returns (TableCode VARCHAR(50),FIELDNAME VARCHAR(20),ID INT,TYPENAME VARCHAR(20),LEN INT,SCALE int, SUBTYPE INT,IsPrimary INT)ASbegin FOR SELECT a.RDB$RELATION_NAME, b.RDB$FIELD_NAME , b.RDB$FIELD_ID , d.RDB$TYPE_NAME , c.RDB$FIELD_LENGTH/2... 阅读全文

摘要： select * from sqlite_masterSELECT name FROM sqlite_temp_masterPRAGMA table_info('warehouse') --表字段信息PRAGMA cache_size =80000 pragma default_cache_size=80000 阅读全文

摘要： 读取图片 DimfsAsFileStream=NewFileStream("e:\Net.jpg",FileMode.Open,FileAccess.Read)Dimb()AsByte=NewByte(fs.Length){}fs.Read(b,0,Convert.ToInt32(fs.Length))fs.Close()DimmsAsMemoryStream=NewMemoryStream(b,0,CType(b.Length,Integer))Me.PictureEdit1.Image=System.Drawing.Image.FromStream(ms)保存图片 Di 阅读全文

摘要： FLOOR 返回小于或等于指定数值表达式的最大整数。 CEILING 返回大于或等于指定数值表达式的最小整数。 round是四舍五入 阅读全文

摘要： DisplayFomrat={0:#.##} 阅读全文

摘要： DECLARE @NAMES VARCHAR(1000)SELECT @NAMES = ISNULL(@NAMES+',','')+ColumnCode FROM DB_TableColumnsWHERE TableCode='faFixedAssets' ORDER BY UIDselect @NAMES 阅读全文

摘要： --创建生成流水号的触发器CREATE TRIGGER [dbo].[T_arDtl_INSERT] ON [dbo].[arDtl]INSTEAD OF INSERTASDECLARE @ID INTSELECT * INTO #TB FROM insertedSELECT @ID=max(RUID) FROM TESTif @ID is null SET @ID=0update #TB SET @ID=@ID+1,RUID=@ID WHERE RUID=0 OR RUID IS NULLINSERT INTO TEST SELECT * FROM #tb 阅读全文

摘要： 这是2005的SELECTTableName=CASE WHEN C.column_id=1 THEN O.name ELSE N'' END,TableDesc=ISNULL(CASE WHEN C.column_id=1 THEN PTB.[value] END,N''),Column_id=C.column_id,ColumnName=C.name,PrimaryKey=ISNULL(IDX.PrimaryKey,N''),[IDENTITY]=CASE WHEN C.is_identity=1 THEN N'√'ELSE 阅读全文

摘要： backup log Appdata with NO_LOGbackup log Appdata with TRUNCATE_ONLYDBCC SHRINKDATABASE(Appdata) 阅读全文

摘要： SELECT * FROMOPENROWSET('MSDASQL','DRIVER={SQL Server};SERVER=192.168.0.1;UID=sa;PWD=1234',ERP.dbo.Employee) 阅读全文