![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SqlServer
Lechar0327
只有不断的突破自我,才是真正的无懈可击
展开
-
SQL还原数据库代码
RESTORE DATABASE xxx FROM DISK = 'E:\DB\xxx.bak' --bak文件路径 with replace, MOVE 'xxx' TO 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\xxx.mdf', --mdf文件路径 MOVE 'xxx_log' T原创 2014-12-21 23:03:29 · 890 阅读 · 0 评论 -
快速查询数据库表字段名,存储过程
ALTER PROC [dbo].[sp_help_table] @tableName NVARCHAR(50) AS BEGIN SELECT a.colorder 字段序号,a.name 字段名,b.name 字段类型,b.length AS 字段长度,g.[value] AS 字段说明 FROM syscolumns a left join systypes原创 2017-02-21 17:37:59 · 435 阅读 · 0 评论