|
|
-
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.......
|
|
-
|
|
Using WITH statement you can create a series of data and use them in your queries.
Sample 1. Integer-Series
WITH T(ID) AS
(
SELECT 1 ID
UNION ALL SELECT ID + 1
FROM T
WHERE ID
Sample 2: Time-Series
WITH T(Date) AS
(
SELECT CONVERT(datetime, ...
|
|
-
|
|
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
The ...
|
|
-
10 Liked
| 10 Learned
| 6 Comments
|
|
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|
|
-
|
|
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying Syst...
|
|
-
|
|
I stumbled across a scenario where I had to find all the triggers associated with few tables. Found the below queries and felt that they are worth sharing. I am listing the helpful sql queries!
To get a list of all the triggers in the database
sel...
|
|
-
|
|
While using Internet Explorer, if you want to open a link in a new tab or to close a currently opened Tab, then simply hover over the link/tab and press the scroll Wheel of your scroll mouse.
This technique for closing tabs working in many other appl......
|
|
-
|
|
Filezilla is free open source FTP software that is used for transferring files from one location to another location. I have found that it is pretty fast compared to other FTP softwares. This is used for uploading and downloading of files.......
|
|
-
|
|
Very easy way to validate user input its valid date
In web application validation is very basic thing when we are working on page where user needs to add input using textbox as user insert correct value
Here I display case for valid date you can a......
|
|
-
|
|
Generally we can see project files in solution explorer but now you can also see properties and method defined in file. You double click on file it will open fine and take you directly to that method declaration.
Solution explorer also provides search ......
|
|