If Delete Any Table In Back-End Then. What Are The Triggers will Fire Automatically(Those Triggers Are Back-End Triggers Only)?
Latest Answer: Clustered Index:- A Clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table may have only one clustered index.Non-Clustered Index:- A Non-Clustered index is a special type of index in ...
Latest Answer: The simplest way to implement this in SQL 2000/OracleSelect * from table1Create a temp table with No of columns = No of rows in table 1No of rows = No of columns in table 1and insert the data into the temp table using a loop logic. ...
Given an unnormalized table with columns:Name,Phone number,Address You notice that some records in Name column are duplicate. Write a T-SQL statement to delete all duplicate record under Name column.
Latest Answer: Actually the query returns an error like "expected NUMBER got CHAR" ...
Why do i get "Invalid Cursor State" errors when I insert/update/delete data with execute Query()?
Latest Answer: varchar and varchar2 are both data types in SQL (Oracle, MySQL, Microsoft SQL
Server, DB2) which accept numeric as well as alphabetic values. Only difference
is that varchar2 reduces wastage of space as it sets the length of character
during run ...
Latest Answer: We can do it by the following command:create or replace directory as 'c:\tmp' ...
Latest Answer: Database is simply a collection of related data nothing else. It can be manual or automatic both.DBMS is collection of application programs which enables a user to define, create and manipulate database. ...
Latest Answer: Eqiui join is totally differene from unions Equijoin depends on a condition involving columns of both tables but where as in Union you can specify a condition based on a columns of the individual tables ...
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
