- 博客(2)
- 收藏
- 关注
原创 sql server清日志
USE [master]GOALTER DATABASE WPM SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE WPM SET RECOVERY SIMPLEGOUSE WPMGODBCC SHRINKFILE (N'WPM_Log' , 11, TRUNCATEONLY) GOUSE [master]GOALTER DATABASE WPM S...
2018-06-18 22:42:46 120
原创 查询表结构sql语句
select t2.comments as 字段中文名,t1.column_name as 字段名, t1.data_type||'('||t1.DATA_LENGTH||')' as 字段类型,'是' as 必填项, t2.comments as 取值范围及描述from user_tab_columns t1left join user_col_comments t2on t1.TABLE_NA...
2018-06-18 22:26:12 9575
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人