摘要： To, Import/Export data To/From Excel (.xls) need Microsoft.Jet.OLEDB.4.0 and for Excel 2007 (.xlsx)need 2007 Office System Driver: Data Connectivity Components. You can download from here.Export Data to Excel fileCreate an Excel file named testing having the headers same as that of SQLServerTable co 阅读全文

摘要： 需要在Reporting Services Configuration Manager中的Database选项中的'Current Report Server Database Credential'中点击'change Credentials' 然后修改即可 阅读全文

摘要： -----------获取当前数据库所有表的外键创建脚本、获取指定表的创建脚本,包括表和字段的属性、外键----------------------- 1 CREATE PROCEDURE [dbo].[sp_HelpTable](@TableName sysname) 2 AS 3 SET NOCOUNT ON 4 DECLARE @ObjectID int 5 DECLARE @TableScript table(Iden int IDENTITY(1, 1), ScriptLine nvarchar(4000)) 6 SET @ObjectID = object_id(@TableNam 阅读全文