Keep it Simple and Smart
Question: Do we need any permission to create temp table in SQL Server? Or Question: Which permission is required to create temp table in SQL Server? Answer: No permissions are required to create temp tables. Any user can create temp table, as long as they can connect to the SQL Server. Example: As user does not have permission to create a regular table But user can create a temp table as Temp Table as
» Read moreError: ORA-01653: unable to extend table in tablespace Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated. Note: Change the table space name for that you need the information in the below Scripts (Script: 1 & 2) Solution: Script: 1 Execute the below query to find the Used Size, Free Size, Total Size of a table space select df.tablespace_name "Tablespace", totalusedspace "Used MB", (df.totalspace – tu.totalusedspace) "Free MB", df.totalspace
» Read moreThis 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” Select the Output file location and name You can also change the Schema (if required) Required Out file is ready with Insert statement as If you have any comment/suggestion please
» 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 script Click on the Advanced button. In the General category, go to Type of data to script. There are 3 options: Schema Only, Data Only, and Schema and Data. Select
» 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 SQL Server Import and Export Wizard. please check http://msdn.microsoft.com/en-us/library/ms141209
» 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 I have introduced the temp table. Now when I try export that data using select script that contain the local temp table the following error occurred. Now if I removed
» 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) RowNumber , FIRST_NAME,LAST_NAME into EMPLOYEE_backup1 FROM EMPLOYEE
» 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 Framework 4 You can choose any one solution as per the requirement. If any body have any other solution then please share as comment.
» 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 not in Use) Turn off WIFI (If not in Use) Turn off Bluetooth (If not in Use) Turn off Data network (If not in Use) Turn off the Background data and
» 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 editable.
» 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 understand VLOOKUP function Say we have two columns as We need to search/find each data value of column B in the all the data value of Column A So here
» 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 our IF condition if the data value of column A and column B are equal/matched then “True” value will be displayed in the Column C otherwise “False” will be displayed.
» Read more