sqlserver数据库相关

来源：互联网发布：福建农林大学网络编辑：程序博客网时间：2024/06/05 19:52

SQLServer控制用户访问权限表：http://www.cnblogs.com/yxyht/archive/2013/03/22/2975880.html

图解PowerDesigner通过数据源生成物理数据模型：http://jingyan.baidu.com/article/ceb9fb10b68abd8cad2ba0eb.html

jdbc执行sql 不支持“variant”数据类型：

 select top 100 [value] from sys.extended_properties   出现Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 不支持“variant”数据类型。

改成下面几个 select top 100 cast([value] as varchar(500)) [value] from sys.extended_properties

SQL Server 2008 中收缩数据库(DUMP,TRANSACTION,TRAN,无效,语法错误)

ALTER DATABASE 数据库名 SET RECOVERY SIMPLE
ALTER DATABASE 数据库名 SET RECOVERY FULL
DBCC SHRINKDATABASE(数据库名, 0)

删除重复数据，保证一条

  delete  from [bjnkquji].[dbo].[tb_o_monitorData_Histroy] where (stcd+CONVERT(varchar, receiveTime, 120 )) in  (  select stcd+CONVERT(varchar, receiveTime, 120 ) from [bjnkquji].[dbo].[tb_o_monitorData_Histroy]  group by stcd,receiveTime  having count(*)>1    )  and id not in  (  select MAX(id) from [bjnkquji].[dbo].[tb_o_monitorData_Histroy]  group by stcd,receiveTime  having count(*)>1  )

SQL Server数据库日志已满的解决方法总结篇：http://database.51cto.com/art/201108/281840.htm

阅读全文

0 0