Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server, Excel Rss

   Items 1 to 3 of 3   
 

Create INSERT statements from Excel

Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.  Read more...
By Arun Mallick 2011/05/02 | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 5,121 reads

How to find unused Stored Procedures in SQL Server 2005/2008

Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database  Read more...
By Ronny Dahl 2010/04/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 26,165 reads

Create INSERT statements from Excel

Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.  Read more...
By Arun Mallick 2011/05/02 | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 5,121 reads
   Items 1 to 3 of 3   
 
Tags
insert (1)    
pivottable (1)    
sheet (1)    
stored procedures (1)