|
Written by Stanislav Duben
|
|
Thursday, 23 April 2009 |
|
For some solutions in SSIS you may need to go over all
records from some SELECT and each record use in some subqueries. In this case
you want loop record per record in some task series. Best solution is to use
Looping through recordset. Because of SSIS is intuitive enough to create this
task, here is step by step overview. In this step by step tutorial, I am using
AdventureWorks database from Microsoft. This database was created for testing
purpose and is ideal for our example.
 Be first to comment this article |  Quote this article on your site | Views: 841 | Print
|
|
Read more...
|
|
|
Written by Stanislav Duben
|
|
Thursday, 17 April 2008 |
 In previous content I showed how to use the OUTPUT command for printing inserted or updated records in a T-SQL query. It's simple, it's powerfull and saves us lines of code. Usually we need use these values in some larger script and assigned them to variables or insert them into other tables. Let's see how to do it.
Be first to comment this article | Quote this article on your site | Views: 4544 | Print |
|
Read more...
|
|
|
Written by Stanislav Duben
|
|
Wednesday, 29 August 2007 |
In MSSQL 2005 is new T-SQL command OUTPUT, that was used only as output parameters in previous MSSQL version. Now you can use it in T-SQL commands to make data changes and see results by one command without using Triggers.
Comments (3) | Quote this article on your site | Views: 5422 | Print |
|
Read more...
|
|
|
Written by Stanislav Duben
|
|
Friday, 24 August 2007 |
 If you want search text not only in name of triggers and store procedures, using search object in query analyzer is not enough and in MS SQL 2005 there isn't any search object function. So you need other way how to do it.
Comments (1) | Quote this article on your site | Views: 4498 | Print |
|
Read more...
|
|
|
Written by Stanislav Duben
|
|
Friday, 20 July 2007 |
|
In query analyzer for
Microsoft SQL 2000 you can search objects easily, just open Query Analyzer and press F4. In Microsoft SQL Server Management
Studio for SQL 2005, this search functionality has been removed. (Microsoft said that nobody uses this function so it's useless), no comment for this reason. We need this functionality, so how to do
it?
Comments (3) | Quote this article on your site | Views: 8448 | Print |
|
Read more...
|
|
|
Written by Stanislav Duben
|
|
Friday, 20 July 2007 |
 Here is simple online convertor from CSV to SQL. You just insert CSV data to text area and table name. Script will generate SQL insert query for all records from CSV.
Comments (5) | Quote this article on your site | Views: 5854 | Print |
|
Read more...
|
|
|
|
