|
|
-
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......
|
|
-
21
Liked
| 16
Learned
| 8
Comments
|
|
While trying to retrieve the select top count dynamically, initially tried this way
[code]
Declare @noOfRowsPerChunk int
set @noOfRowsPerChunk = 5
select top @noOfRowsPerChunk RecordID from myTable
[/code]
which throwed the syntax error.
Fix:......
|
|
-
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 ......
|
|
-
|
|
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 characte...
|
|
-
15
Liked
| 15
Learned
| 5
Comments
|
|
If you write a lot of dynamic TSQL queries, you might have experienced the problem of query text getting truncated when you try to print them for diagnostic purposes. A SELECT instead of PRINT will help, but you will loose formatting when the result str......
|
|
-
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...
|
|
-
17
Liked
| 15
Learned
| 7
Comments
|
|
1) Transaction log are not recorded for table variables so they are transactional neutral or you can say that they are out of scope of transaction mechanism. Whereas temp tables participate in transactions just like normal tables
2) Table variables c......
|
|
-
13
Liked
| 15
Learned
| 7
Comments
|
|
Is it unbeleivable? See the below example
[code]Create procedure GO
as
select 1 as number[/code]
Now execute it without using keywords EXEC or EXECUTE
[code]GO[/code]GO is treated as batch seperator and you wont get any result. Now execute it by[......
|
|