March 19, 2015byGeeks Hangout The below SQL script will return a list of tables in a database along with the table sizes in MB. Code (double click to select all for copy): 1 2 3 4 selectobject_name(id) [TableName], [TableSize] =convert(varchar, dpages * 8 / 1024) +'MB' ...
Try this for T-SQL script change the database name of course! ;) prettyprint USE <databasename>; GO SET NOCOUNT ON DBCC UPDATEUSAGE(0) -- DB size. EXEC sp_spaceused-- Table row counts and sizes. CREATE TABLE #t ( [name] NVARCHAR(128) , [rows] CHAR(11) , reserved VARCHAR(18)...
select count(*) from tvb ; SELECT * FROM TABLE(dbms_xplan.display('PLAN_TABLE','abc','ALL')); set linesize 200 pagesize 1400; select /* FINDSQLID */ SQL_ID,SQL_FULLTEXT from V$SQL where SQL_TEXT LIKE '%&SQLTEXT%' and SQL_FULLTEXT NOT LIKE '%FINDSQLID%' union all select SQ...
%msg&sql(CREATEGLOBALTEMPORARYTABLETempEmp(EMPNUMINTNOTNULL,NAMELASTCHAR(30)NOTNULL,NAMEFIRSTCHAR(30)NOTNULL,CONSTRAINTEMPLOYEEPKPRIMARYKEY(EMPNUM)))ifSQLCODE=0{w!,"表创建"}else{w!,"SQLCODE=",SQLCODE,": ",%msg}}
createtableDepartment-( --创建部门编号;int代表整数类型;primary key代表主键;identity(1,1)代表从1开始步长为1自增长; DepartmentIdintprimarykeyidentity(1,1), --创建部门名称;nvarchar(50)代表长度50的字符串;not null代表不能为空; DepartmentName nvarchar(50)notnull, ...
[ REFERENCES table (reffield-commalist) ] [ DEFAULT [(]default-spec[)] ] [ ON UPDATE update-spec ] [ COMPUTECODE { ObjectScript-code } [ COMPUTEONCHANGE (field-commalist) | CALCULATED | TRANSIENT ] ] } , } [{ [CONSTRAINT uname] UNIQUE (field-commalist) }] [ [CONSTRAINT pkname]...
sqlcmd -v ColumnName ="LastName" -i c:\testscript.sql 有关脚本变量名和变量值的原则 为脚本变量命名时,请考虑以下原则: 变量名不能包含空格字符或引号。 变量名不能与变量表达式(如$(var))具有相同的形式。 脚本变量不区分大小写。 备注 如果没有为sqlcmd环境变量分配任何值,则将删除该变量。 在不设置...
[REFERENCEStable(reffield-commalist)][DEFAULT[(]default-spec[)]][ONUPDATEupdate-spec][COMPUTECODE{ObjectScript-code}[COMPUTEONCHANGE(field-commalist)|CALCULATED|TRANSIENT]]},}[{[CONSTRAINTuname]UNIQUE(field-commalist)}][[CONSTRAINTpkname]PRIMARYKEY(field-commalist)][{[CONSTRAINTfkname]FOREIGNKEY(...
an edit icon to enable the script to be loaded into the script editor, the script name, the script owner, when the script was last updated and by who, the size in bytes, the number of times the script has been run linked to the run results, and an icon to enable the script to be...
动态脚本语言(DSL,Dynamic Script Language)解析框架。可广泛用于动态 SQL(即 DSQL)等场景的解析,DSQL 也是目前 DSL 最成功的应用领域,具体包括 Flink SQL(如 Clink)、Spark SQL(如 sparktool)和 JDBC(如 sqltool)。 展开 收起 DSL SQL DSQL script 暂无标签 README Apache-2.0 使用Apache-2.0 开...