|
|
-
|
|
Menu > View > Freeze panes > Freeze top Row...
|
|
-
|
|
choose the program > properties > shortcut > short cut key > assign the shortcut > OK. ...
|
|
-
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...
|
|
-
|
|
@@ROWCOUNT returns the number of affected rows by last statement.
Below example illustrate the same
CREATE TABLE #t (id int)
INSERT INTO #t(id) values(1)
DELETE #t
SELECT @@ROWCOUNT
Here we will get @@ROWCOUNT AS 1
But same did not...
|
|
-
|
|
According to MSDN
"***A Windows PowerShell drive is a data store location that you can access like a file system drive in Windows PowerShell***."
You can use the Power of PS to create drives like ( within Windows PowerShell)
- file system drives (in...
|
|
-
|
|
Typically when we require a number to be represented as a string we employ a CAST or CONVERT.
Sometimes though we want to preserve the natural 'sortability' of the numbers **after** the conversion and this poses a problem as string '8' is "bigger" than...
|
|
-
|
|
I was Mckinsey's Big Data report 2011 when I learned that " during a single cross-country flight, a Boeing 737 generates 240 terabytes of data " ...
|
|
-
|
|
I was working on a project where one of the things we needed to do was to import data from Excel file to MS project 2010. Go to file > Open > Change File format to see "All files" > Select the excel file. This will start the conversion wizard. Here you ...
|
|
-
|
|
I have come across the method of finding last time the SQL server DB has been restored. I believe it would be helpful for most of us.
Please refer the link for the details.
DECLARE @dbname sysname, @days int
SET @dbname = NULL --substitute for...
|
|
-
|
|
It was announced when office 2013 preview came out so in case you missed this awesome news: "Power View is Integrated in Excel 2013!" ...
|
|