Using Captcha Image in Claasic asp

...

Read More »

SQL SERVER 2005: Expot to Excel using OPENROWSET

Apart from using DTS and Export wizard, we can also use this query to export data from SQL Server2000 to Excel Create an Excel file named testing having the headers same as that of table columns and use these queries 1 Export data to existing EXCEL file from SQL Server table insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xls;', 'SELECT * FROM [SheetName$]') select * from SQLServerTable 2 Export data from Excel to new SQL Server table select * into...

Read More »

SQL SERVER 2005: How to enable ‘Ad Hoc Distributed Queries’ SQL SERVER 2005

Enabling  ‘Ad Hoc Distributed Queries’ SQL SERVER 2005 Frequently, we need to use OPENROWSET queries to connect to remote database servers. To enable this feature on SQL Server 2005, you should first configure the database to enable Ad Hoc Distributed Queries. We can Enable this feature by two ways: 1. SQL Server Surface Area Configuration. 2. by sp_configure option. Lets check with first...

Read More »