|
|
-
|
|
Without running the query, can you guess the answer?
Query
select 100.-89_90
Answers
Answer 1 : Incorrect syntax near .
Answer 2 : _79
Answer 3 : Incorrect syntax near 89_90
Answer 4 : 11
......
|
|
-
|
|
One of my friends asked me to ask him a very different and tricky interview question. I asked him to come up with the code that passes parameter to getdate() function ie use any code where getdate(something) is part of the code. Although it is very interesting he did not come up with an answer. Here......
|
|
-
|
|
Pinal Dave, founder of www.sqlauthority.com, started a new series of posts in which a question will be asked each day. Two persons will be chosen randomly to get a book. Answering these questions are not only helping you to improve your knowledge, but also will make you to win a book. So visit this ......
|
|
-
|
|
As I have informed you earlier in this post, there are some interesting tips I have contributed in July 2011. You may find them interesting if you follow them. The following are some of my tips I posted there
Most Learned Posts of all time
Google is also a calculatorYou can drop multiple tables us......
|
|
-
|
|
As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to filter the objects in the object explorer.
Suppose you have many tables in the database......
|
|
-
|
|
As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to Connect to msdn forums or submit your feedback to connect item
Connecting to msdn forums......
|
|
-
|
|
Without running this query, can you guess what would be the answer?
Query
select 3+-+-+-++4
Choose the correct Answer
Answer 1 An error which says incorrect syntax near -
Answer 2 7
Answer 3 -1
Answer 4 None of the above
......
|
|
-
|
|
As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to change the value of the option SELECT Top N rows
Sometimes you may need to view some sam......
|
|
-
|
|
As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to enable/disable IntelleSense.
IntelliSense, which was introduced in SQL Server 2008, allo......
|
|
-
|
|
As I have informed you earlier in this post, there are some interesting tips I have contributed in June 2011. You may find them interesting if you follow them. The following are some of my tips I posted there
Tips related to SQL Server
SSMS Allows you to ask a question in the MSDN forum directly f......
|
|