Which type of cursor is used to execute the dml statement?
What is clustered index sql?
What are schema-level triggers?
Fetch an entire row from the employees table for a specific employee ID:
suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.
7 Answers Geometric Software, IBM,
How can I see all tables in sql?
If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
What are pl sql procedures?
What are inbuilt functions in sql?
how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000
What is denormalization in a database?
how to do backup entire database? : Transact sql
Which one is faster ienumerable or iqueryable?