plz send every query in sql server20001 3487
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?3 6736
Difference between Cluster and Non-cluster index?32 124123
What are sub-queries? Give example? In which case sub-queries are not feasible?4 7971
How do you measure the performance of a stored procedure?3 12823
Questions on identity?2 4563
Difference between writing SQL query and stored procedure ?15 63426
Define candidate key, alternate key, composite key.13 105481
What are the differences between stored procedure and functions in SQL Server 2000?25 97082
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....9 56137
HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE18 38907
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 18560
Write a query to delete duplicate records in SQL SERVER36 56385
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)5 6611
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?8 6227
what is the basic need for tech..test?
show answer/ calculate-1-2-4 ratio-concrete -cement-sand- metal-water - please brief calculation
What do you understand by an inner bag and outer bag in Pig?
In which code the the maximum height of concrete casting has been explained
what is the apt definitions for apparent power ,active power and reactive power?and explanation about different types of lamps?
What are the factor to be consider for CT selection in 132kV substation?
Name three reasons why the tester may choose to record in Context Sensitive mode.
Does functional module level configuration come under workbench request or customizing request?
how to decide choke rating for drive?
How to Save a Package as a Separate File?
Describe the difference between inline and code behind which is best in a loosely coupled solution?
Why do some of the latest 'single crystal' superalloys contain concentrations of the grain boundary strengthening elements, e.g. carbon and boron?
HOE WE CAN IMPROOVE BY USE OF CAPACITOR
What is diff b/w FIFA,FIPA,FIEA....?
Hai sd gurus can u tell me what are the roles and responsiblys in support projet as a sd consultant .thanks in advance