摘要:
------------------------------列操作----------------------------------- --添加列 ALTER TABLE t ADD Mycolumn int identity(1,1)||not null default(0) --删除列 alter table t drop column Mycolumn --修改列 alter table... 阅读全文
摘要:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[L2U]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[L2U] GO CREATE FUNCTION dbo.L2U(@n_LowerMoney numeric(15,2),@v_Tr... 阅读全文
摘要:
Dim objConn As OracleConnection Dim objDataAdapter As OracleDataAdapter Dim strConn As String = "user id=scott;password=tiger;data source=orcl" Dim strSql As String ... 阅读全文