syntax for deleting the database in T SQL5 4742
How are SQL Server databases physically stored under Windows 2000?1 2659
internal language used in sql server 2000?2 2542
What types of integrity are enforced by a foreign-key constraint1 3414
How do you find the error, how can you know the number of rows effected by last SQL statement?1 3228
Which virtual table does a trigger use?3 6461
Name three version of sql server 2000 and also their differences?1 2630
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)1 8245
can you any body tell me which service pack is installed in the sql server?3 2804
can you any body tell me the how to decrease the logfile4 3561
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 500017 12797
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.3 5679
what is difference between having and where clause ?3 3642
Accidentally i deleted my table. How can i get that table?4 6325
how can i view structure of table in sql server? tell me that query.10 12808
What are statistics?
Find columns used in stored procedure?
What is the difference between seek predicate and predicate?
What are the different types of data sources in ssrs?
What is table value parameters (tvp)?
Why transaction is important?
What are the properties of primary key?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Differentiate between ms sql server reporting services vs crystal reports?
Explain features and concepts of analysis services?
What is a trigger what are the advantages of trigger?
What is a trace frag? Where do we use it?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
How to encrypt Strored Procedure in SQL SERVER?
What is temporary table in sql server? Why we use temp table?