How do you find the error, how can you know the number of rows effected by last SQL statement?
1 3228Is 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 8245I 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 5000
17 12797employee 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 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?