Sql
Sree Swetha from Hyderabad
This blog gives you information related to sql and sql server. You can also refer some important queries.
1
Visits today
Visits today
51
Total visits
Total visits
Recent Posts from "Sql"
Order By our specific order
4 Sep 08, 3:39 PMGenerally we can get the records in alphabetical or numeric order by default either in ascending or descending by specifying ORDER BY clause in the query. But s...
REPLICATE function
7 Aug 08, 5:58 PMRepeats a string value a specified number of times.Syntax:REPLICATE ( string , integer)string - what should be repeated or addedinteger - how many times string ...
Import Data from excel file to database
30 May 08, 12:22 PMSteps to import data from excel to the database:Step 1: Go to Sql Server Enterprise Manager > Right click on local database server > All Tasks > Import DataStep...
Important Queries
20 May 08, 9:58 PMTo find the nth row of a table In oracle:Select * from emp where rowid = (select max(rowid) from emp where rownum 2500To find nth maximum sal In oracle:Select *...
Triggers
5 May 08, 4:48 PMTriggers are special types of Stored Procedures that are defined to execute automatically in place of or after data modifications.They can be executed automatic...