|
|
-
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......
|
|
-
19
Liked
| 16
Learned
| 2
Comments
|
|
Just learned about these from the article "SQL Server All, Some and Any Operators" in the website "blackwasp.co.uk". Though these things are basic, its worthy to remember again.
The SOME and ANY operators provide equivalent functionality. SOME and ......
|
|
-
18
Liked
| 18
Learned
| 4
Comments
|
|
Just learned from Pinal's blog that you can open a web page within SQL Server Management Studio. You can even split the main window where on one side you can type your TSQL code and on the other half you can view web pages. This can be extremely helpful......
|
|
-
18
Liked
| 15
Learned
| 3
Comments
|
|
In SQL Server Management Studio, we can select text and press SHIFT+CTRL+U and SHIFT+CTRL+L to change the selected text to upper case and lower case respectively. I have been looking for a similar option in Microsft word and just learned that this can b...
|
|
-
18
Liked
| 21
Learned
| 5
Comments
|
|
Careful! If you are using your old scripts to create database in SQL 2012, It might fail. In SQL Server 2012, Minimum database size is increased to 3MB. In before versions it is 2MB. So, if you run the same script with initial size specified as 2MB, it ......
|
|
-
18
Liked
| 12
Learned
| 10
Comments
|
|
There are no non-logged user database operations. The only non-logged operations are the version stores in tempdb
TRUNCATE TABLE is minimally-logged:
1) Metadata changes are always logged at TRUNCATE time
2) Extent/page deallocations may be logged......
|
|
-
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......
|
|
-
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.......
|
|
-
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...
|
|
-
17
Liked
| 11
Learned
| 4
Comments
|
|
I saw today, in someones code, something like this:
GO 100
At first, I thought that was some typing mistake, but then I found that GO has not only function of ending batch, but also it can execute that batch many times, as specified in:
GO [c...
|
|