|
|
-
|
|
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......
|
|
-
|
|
Pinal Dave, in his site, posted an interesting solution on finding out maximum number between two numbers. Here are some alternate methods that I know
Method 1 : Use max function
declare @value1 decimal(5,2) = 9.22
declare @value2 decimal(5,2) = 8.34
select max(val) from
(
select @value1 as......
|
|
|
|