In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;5 17991
What are Sql Reporting Services and analysis services? Can u Explain1 8303
what is differece between union and union all6 5817
Is trigger fired implicitely?2 3367
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.2 4295
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?8 15443
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
If a stored procedure is taking a table data type, how it looks?
How we create SQL Server 2005 Reporting Services ? Give me Sample
Delete duplicate rows without using rowid.
If the job running very slow what is the action you do
ow to bring suspect mode datbase online from scratch
Explain Capacity planning to create a database? and how to monitor it?
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
Issues related in upgrading SQL Server 2000 to 2005 / 2008
how to take backup bcp out for a column in table in sql server?
how to overcome kernel isssues
plss anybody specify tha constrian management system in dbms
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
your distribution database is full what will u do
what exactly sql injuction.how to overcome.....