Keep it Simple and Smart
This is very quick way to generate the Insert Statement for all of the data in your table. Let us take an example; we have a table as shown below… Right click on the Result Grid and go to Option à Export Dataset Select the Export Format as “Insert Statement”
» Read moreThis is very quick way to generate the Insert Statement for all of the data in your table. This is really very useful feature of SQL Server Summary: Right click on the database and go to Tasks -> Generate Scripts Select the tables for that you want to generate the
» Read moreThe SQL Server Import and Export Wizard provides the simplest method of copying data between data sources. In this article given an example to copy the data from SQL Server to Oracle database. Click here to download the full PDF version of this article. After this article,for more detail about
» Read moreI had a requirement to export the data from SQL Server to Oracle using SQL Server Import/Export wizard. In the SQL Server, I have created a SQL Script that fetch the required data that I need to export in Oracle database. Because of some business logic, in the select script
» Read moreHow to Generate the Row Number in Select and Select into script? Using IDENTITY for Select Into SELECT RowNumber=IDENTITY(int,1,1),FIRST_NAME,LAST_NAME into EMPLOYEE_backup FROM EMPLOYEE Using Row_Number() for Select SELECT ROW_NUMBER() OVER (ORDER BY ID ASC) RowNumber, FIRST_NAME,LAST_NAME FROM EMPLOYEE Using Row_Number() for Select into SELECT ROW_NUMBER() OVER (ORDER BY ID ASC)
» Read moreSSIS Import/Export Wizard throws up “Unexpected Unrecoverable Error”. Error message dialog box have three buttons – Abort, Retry, and ignore all cause the wizard to close. The reason I found of this: Installation the .Net Framework 4 Client Profile Solution: Uninstall the .Net Framework 4 Client Profile Or Install Extended .NET
» Read moreIf you are facing the problem of your mobile low battery life then this post will help you to solve the problem of low battery life. With the help of these tips you can increase/improve the battery life. Lower down the screen brightness Remove Live/Animated Wallpaper Turn off GPS (If
» Read moreIf you want to update your select result in toad, just add the ROWID is your select statement. Once you select the records with ROWID then you can edit/update your result grid. You can also see the Green indicator as shown in the below screenshot that means your records are
» Read moreVLOOKUP function is very useful function if you are dealing with large excel sheet. With the help of this function one can search/find the data value from one or more columns. The V in VLOOKUP stands for vertical. Syntax: VLOOKUP (lookup_value, table_array, col_index_num, range_lookup) Let‘s take a simple example to
» Read moreSometime we need to compare the data of two different columns in excel. Here is very simple solution with the help of IF Function. Syntax: IF (logical_condition, value_if_true, value_if_false) Example: Say we have two columns as Now we can use the IF function as IF (A1=B1, TRUE, FALSE) According to
» Read moreVarinder Sandhu is using WP-Gravatar