Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 07 5221
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?825
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram782
i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee
what are the critical issues you have resloved in your company789
What is RMS migrations?922
I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output9 5026
What is split brain scenario in DB mirroring?1 7176
how do we insert 100 records at a time in a table without using for loop in database1 3066
i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to email@example.com 3470
in how many ways we can use count()2 1163
How do use Having,Group by,Group function in SQL?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
ow to bring suspect mode datbase online from scratch
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
How much memory that we are using in Logshipping Concept?
how to do partition in sqlserver
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
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.
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
how to use DTS package in 2000,2005,2008 in sql server
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible