Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Auditing changes in all SQL tables
- I have an application that we purchased that accesses it's database in SQL Server 2000. I wanted to know what tables the application accesses when a certain function is performed. I thought that I could add a trigger to each table that would insert a flag into a...
- Tags: SQL Table, sql server, audit, tables, SQL, tool, paulhenriques@..., software, trigger, database, auditing, SQL Profiler
- Discussion threads 2006-07-19
Additional Resources
- Export Table to SQL for SQL server (exe)
- Export Table to SQL for Microsoft SQL Server helps to save table's data as a set of Insert SQL statements and optional create table statement. Predefined or custom separators like 'go', two identity support modes and a few options make this tool flexible. The program has easy to learn and...
- Tags: Microsoft SQL Server, Server, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2006-10-23
- Advanced SQL To RTF Table Converter (msi)
- Advanced SQL To RTF Table Converter is a relational database client utility that allows execution of SQL Structured Query Language statements on Microsoft SQL Server and MySQL databases. Resultsets returned by select statements are automatically persisted as RTF tables to a directory of your choice. Advanced SQL To RTF Table...
- Tags: SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2007-12-20
- Advanced SQL To PDF Table Converter (msi)
- Advanced SQL To PDF Table Converter is a relational database client utility that allows execution of SQL Structured Query Language statements on Microsoft SQL Server and MySQL databases. Resultsets returned by select statements are automatically persisted as PDF tables to a directory of your choice. Advanced SQL To PDF Table...
- Tags: Adobe PDF, SQL, Databases, Enterprise Software, Software, Data Management
- Software downloads 2007-12-20
- Upsizing Access 2003 to SQL
- I am trying to upsize a database with 6 tables from Access 2003 to SQL version 8. 5 of the tables upsize and link to the SQL database without any problems but one of the tables returns "table was skipped, or export failed" error. I have given the...
- Tags: colin-mackenzie@..., Microsoft Access, software, SQL
- Q&A 2006-02-02
- Can we clone a table structure to temp table in SQL server
- Can we clone a table structure to temp-table in SQL server stored procedure?If yes, how should we declare the temp table and the command the clone the table structure?or can provide us a sample codes on the above solution.ThanksAnnoyingly simpleselect * into #temptable from Tableif you only want the structureSelect...
- Tags: ysgoh3@..., Microsoft SQL Server, server
- Discussion threads 2007-05-09
- Using a PL/SQL Table in SQL
- A friend of mine called a fewdays ago with a question. He wanted to populate a PL/SQL table and useit to compare to some other data via a NOT IN subquery. He was having aproblem getting the data into the nested table and wasn't sure how toaccess it from SQL...
- Tags: PL/SQL, PL/SQL Table, SQL
- Blog posts 2006-08-10
- XML to Table
- Daily I am being sent an XML File that I need to integrate straight into a MS SQL Table, so far all the code seems to crash...Is there a simple way ???yupa simple 2 step way.write a script to turn the xml file's divs into a comma delimited file and...
- Tags: XML, XML file
- Discussion threads 2006-07-11
- Export Database to SQL for SQL Server (exe)
- Export Database to SQL for Microsoft SQL Server helps to save table's data as a set of insert SQL statements and optional create table statement. Predefined or cusrtom separators like 'go', two identity support modes and a few options make this tool flexible. The program has easy to learn and...
- Tags: Microsoft SQL Server, Server, SQL, OmBelt Solutions, Programming Languages, Databases, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware
- Software downloads 2008-08-13
- Introduction to Basic SQL, Part 2 - Joins
- In my last article, I introduced you to some basic SQL commands and some new concepts, mainly the data dictionary. Today we will get a little further into basic SQL by joining two tables in a single select statement. In the last article, I glossed over the difference between a...
- Tags: Programming languages, Databases, SQL
- Blog posts 2006-06-06
- SQL Find and Replace (exe)
- SQL Find and Replace is a utility made to search and replace content in cells of table columns in a SQL Sequel database. This .NET Find and Replace Utility can replace the data in a single cell or a range of cells automating the task of updating your database. Do...
- Tags: SQL, Cell, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2006-09-20
- Export Table to XML for SQL server (exe)
- Export Table to XML for Microsoft SQL Server helps to save table's data as XML document. Two identity support modes and a few options make this tool flexible. The program has easy to learn and to use wizard interface. This handy utility helps database developers and database administrators to create...
- Tags: Microsoft SQL Server, Server, XML, Databases, Enterprise Software, Software/Web Development, Web Development, Software, Data Management
- Software downloads 2006-10-23
- SQL generator (msi)
- Easy generate SQL code from an excel document, for generating tables with data. The queries wil be stored in an .sql file wich can be used by many databases (MySQL, SQL server). Create table and the insert statements will be generated automatically.
- Tags: SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2005-10-26
- Advanced SQL To HTML Table Converter (msi)
- Advanced SQL To HTML Table Converter is a relational database client utility that allows execution of SQL Structured Query Language statements on Microsoft SQL Server and MySQL databases. Resultsets returned by select statements are automatically persisted as HTML and CSS tables to a directory of your choice. Version 1.2 includes...
- Tags: HTML, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2007-12-20
- run SQL stored procedure from Excel
- I have a stored procedure in SQL2005 that builds7refreshes a table. I cannot use SQL Views due to highly complex programming that is needed. I have an excel pivot table that uses that table afterwards. I would like the user to be able to refresh the data in the pivot,...
- Tags: Programming languages, Microsoft Excel, highlander718, SQL
- Discussion threads 2007-08-09
- EASYSQL (exe)
- EasySQL Tool using MS ADO 2.0 is a SQL script building tool. It lets you build mssql server data objects SQL scripts, open table, view to browse data, and batch build data, objects SQL scripts, save batch build project, execute SQL scripts or check syntax simultaneously. EasySQL2.0 can build all...
- Tags: SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2005-12-08
- JDBC:does nt let me create 2 tables!
- I have made an awt interface.in that i have 2 buttons to create their respective tables in database.the problem is that when i create table B immediately after i create table a i get an sql exception.tab b has a foreign key of tab aid. i need to close my...
- Tags: Programming languages, Databases, SQL
- Q&A 2005-11-04
- ARIS Data Scripter (zip)
- ARIS Data Scripter creates T-SQL INSERT scripts with data from given table in just a few clicks inside SQL Server Management Studio. The product is fully integrated into SQL Server Management Studio Object Explorer: pick desired table and choose context menu item to generate file with INSERTS. Only first 500...
- Tags: Microsoft SQL Server, Product, ARIS Data Scripter, Databases, Enterprise Software, Software, Data Management
- Software downloads 2006-03-16
- Extending SQL Server Reporting Services With SQL CLR Table-Valued Functions
- A new feature of Microsoft SQL Server 2005 is its integration with the Microsoft .NET Framework common language runtime CLR. This allows .NET Framework classes and functions to be incorporated into Transact-SQL statements and queries. This white paper describes how to take advantage of SQL CLR table-valued functions to combine...
- Tags: Microsoft .NET Framework, Microsoft SQL Server, Server, SQL, Microsoft Corp., .Net, Databases, Enterprise Software, Software Development, Software/Web Development, Software, Data Management
- White papers 2007-02-01
- Microsoft Query
- I have created a sql query with table variables when I run the SQL in microsoft query it brings back the data, however when I try to return the data to excel it drops all the information & when I try to edit the query the SQL statement is blank.1....
- Tags: #SessionsByRegion, Microsoft Corp., Peter.mcauley@..., SessionsByRegion, software, SQL
- Q&A 2005-06-08
- << Previous
- page 1 of 1
- Next >>
