How do you find the error, how can you know the number of rows effected by last SQL statement?
1 4664Is 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 9740I 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 21666employee 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 7934
What is the current limitation of the size of SQL Azure DB?
How do I find query history in sql server?
How to convert a numeric expression from one data type to another?
What is default constraint in ms sql server?
Does group by or order by come first?
How do I completely remove sql server instance?
what is raid? : Sql server database administration
Can multiple columns be used in sql group by clause in ms sql server?
How many types of the database links?
Why SQL Agent is used?
What happens when converting big values to numeric data types?
Why it is recommended to avoid referencing a floating point column in the where clause?
Define cursor locking
Explain different types of collation sensitivity?
What is BLOCK statements in SQL?