Murat HOŞVER

T-SQL ile Excel dosyasını sorgulamak

December 11th, 2011 by ne0c0de |

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\Dev\test.xls', 'SELECT * FROM [Sayfa1$]');

• My name is

  

  Murat HOŞVER

• Recent Comments

  • ne0c0de: Hi Alejandro, "Truncate Table" is faster but you can not use this
  • Alejandro Pasagrante: But TRUNCATE TABLE is faster and uses fewer system and transaction
  • ne0c0de: rica ederim

• Kategoriler

  • MS SQL Server
  • Uncategorized

• Etiketler

  foreign key index defrag log truncate mssql search in stored SP sql sql server table sql server table size stored procedure t-sql table index transactional log truncate transaction log tsql

  WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.