create index a on employee(dno) In this,which index was created?2 2584
How will u get 5 years back record?5 5562
What is a materialized view?3 5433
What is MSDE?2 2311
How can you see what type of locks used?1 2891
What is transcation?Plz give One example?2 2615
Plz tell about backup&recovery?3 2412
How to find the date and time of last updated table?3 13910
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 7499
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?1 2532
can you any body tell me why are go for the rebuild the master database.what is the reason?2 2230
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
your distribution database is full what will u do
Why do you want to join software field as you have done your BE in Electronics?
Call by value and call by reference in procedure and function, with NOCOPY.
What is the query optimization statistics?
what is checksum in sql server.........???
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
can any body tell me how to know the password of current user in sql server
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
If a stored procedure is taking a table data type, how it looks?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
System variable and temporary variables
how to overcome kernel isssues