|
|
-
16
Liked
| 18
Learned
| 3
Comments
|
|
Recently I got a requirement to display groups along with number of products in the group, where cost of product falls in certain range. Additional requirement is, even if a group doesn’t have any items in the range; still show that group with the Numb......
|
|
-
18
Liked
| 18
Learned
| 7
Comments
|
|
I just learned that while working in SSMS if you have a doubt you can ask in msdn forum using
the toolbar "Community > Ask a question" and the forum web page opens right within Books Online.......
|
|
-
16
Liked
| 17
Learned
| 10
Comments
|
|
One of the problems I always faced when storing multi-line text into a SQL Server table is the trouble in retrieving it and analysing it in SSMS. If I take output to Grid, I will lose the line breaks and formatting. If I take output to text, it is trunc......
|
|
-
16
Liked
| 17
Learned
| 8
Comments
|
|
Often in forums, we will see this question, "How to calculate running total?". There are various complex methods available for this and this is one of often discussed topic. Now In SQL Server 2012, OVER clause has been enhanced to calculate running tota......
|
|
-
19
Liked
| 17
Learned
| 8
Comments
|
|
The WRITETEXT statement is used to update a column of datatypes text, ntext and image. However it will not fire INSERT or UPDATE triggers......
|
|
-
18
Liked
| 17
Learned
| 4
Comments
|
|
[code]
The maximum number of parameters in a stored procedure is 2100.
The maximum number of local variables in a stored procedure is limited only by available memory.
Depending on available memory, the maximum size of a stored procedure is 128 megab......
|
|
-
19
Liked
| 17
Learned
| 6
Comments
|
|
KEEPIDENTITY applicable only in an INSERT statement when the BULK option is used with OPENROWSET. Specifies that the identity value or values in the imported data file are to be used for the identity column. If KEEPIDENTITY is not specified, the identit......
|
|
-
17
Liked
| 16
Learned
| 8
Comments
|
|
In SQL Server 2008, We have a feature to select multiple lines with specific characters.
In SQL Server 2012, we can append the same text to multiple lines.
Below images will give the clear picture to understand this feature.
Some times we need to add s...
|
|
-
14
Liked
| 16
Learned
| 3
Comments
|
|
All of us like Keyboard Shortcuts and use it frequently but memorizing them might be painful and we get to remember them after we use it over a period of time. I just found a very easy way to learn and remember the Keyboard Shortcuts in SQL Server Manag...
|
|
-
23
Liked
| 16
Learned
| 4
Comments
|
|
We had a contract dba who was asked to create a database.From outside look the database looked normal, but for some reason code would not recognize it and we kept getting error that database does not exist or user does not have permissions. We tried put......
|
|