create index a on employee(dno) In this,which index was created?2 2541
How will u get 5 years back record?5 5503
What is a materialized view?3 5362
What is MSDE?2 2216
How can you see what type of locks used?1 2843
What is transcation?Plz give One example?2 2571
Plz tell about backup&recovery?3 2364
How to find the date and time of last updated table?3 13766
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...7 7391
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?1 2480
can you any body tell me why are go for the rebuild the master database.what is the reason?2 2193
How much memory that we are using in Logshipping Concept?
what exactly sql injuction.how to overcome.....
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
what are the Prerequisites for Replication?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How to trouble shoot if unable to connect SQL Server
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Why we need to use secondry database file? though, we can do same work using primary database file also.
If user is owning any SQL Objects, can we drop that user
OPTIMIZATION OF SP,CURSOR,TRIGGERS
what is the sql equivaent of the dataset relation object ?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
ow to bring suspect mode datbase online from scratch