|
|
-
|
|
Today I just help my kid's to learn tables. I lean new technique for learn nine table like
Now Hold out both of your hands with palms facing away from you.Numbers your fingers from 1 to 10 from left to right. Make sure you know the number correspondi......
|
|
-
|
|
Suppose if you want to visit www.beyondrelational.com. instead of typing each character, just type beyondrelational and press CTRL+ENTER to invoke the website. This works in IE and Firefox......
|
|
-
|
|
Suppose you are maintaining some notes in a notepad on a daily basis and you want to add current date and time whenever you finish so that you can keep track of when notes are added. While working in a notead, Press F5 and it will insert current date an......
|
|
-
|
|
I knew it before, but since there was a today's thread on this topic, I think it's important to re-learn.
T-SQL does not permit BEGIN END without something in between.......
|
|
-
|
|
Recently, I came across a situation where I wanted to remove entries of "server name" from history of SQL server management studio.
and we can do that by following: Go to "%appdata%\Microsoft\Microsoft SQL Server\100\Tools\Shell" (For SQL Server 2008)......
|
|
-
|
|
**Hold Control and shift key while Clicking on Program icon**.
**For example:** You want to open visual studio with administrator rights then **Ctrl + Shift + Click on visual studio icon**...
|
|
-
|
|
I am working a Data Quality Services Demo where i had to figure out how to write a domain rule to validate a email address. for this task, i re-learned how to write a regular expression; here's my basic version: [A-Za-z0-9._-]+@[A-Za-z0-9.-]+.[A-Za-z] ;...
|
|
-
|
|
It can't get simpler than this: Drag the "Email" to the "Tasks" Tab that you can find in Bottom Left corner. What I like about it is that It let's to specify start date, end date, priority, status, reminders. Just wonderful! I have been using it for a w...
|
|
-
|
|
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...
|
|
-
|
|
ManagementStudio & Visual Studio:
press [Ctrl+KC] to comment code (works also on selected lines), but comment out only whole lines.
press [Ctrl+KU] to uncomment code (works also on selected lines), but comment out only whole lines.
but for VS, at HT...
|
|