摘要：
This article explains how to create a a stored procedure that will in turn create a simple column based report in PDF without using any external tools or libraries (and their associated licensing costs!). SQL2PDF makes a PDF report from text inserted in the table psopdf ( nvarchar(80) ). First a ... 阅读全文
摘要：
1、在SQL SERVER里查询Excel数据: -- ====================================================== SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$] 下面是个查询的示例，它通过用于 Jet 的 OLE DB 提供程序查询 Ex 阅读全文
摘要：
---------------------------------------------------------------------------- Author : htl258(Tony)-- Date : 2010-04-29 19:07:45-- Version:Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)-- Jul 9 2008 14:43:38-- Copyright (c) 1988-2008 Microsoft Corporation-- Developer Edition on Windows NT 阅读全文
摘要：
在SQL Server里可以调用DOS下的命令行工具bcp来实现把表里的数据或者SQL语句结果生成文本文件。BCP命令的参数格式:BCP {dbtable | query} {in | out | queryout | format} datafile[-m maxerrors] [-f formatfile] [-e errfile][-F firstrow] [-L lastrow] [-b batchsize][-n native type] [-c character type] [-w wide character type][-... 阅读全文