|
|
-
5
Liked
|
6
Learned
|
1
Comments
|
|
As per this thread on Born to Learn ([SQL Server 2012 Certifications][1]), beta exams will go live mid-March 2012.
[1]: http://borntolearn.mslearn.net/mct/sql/f/87/p/318819/368328.aspx#368328...
|
|
-
9
Liked
|
4
Learned
|
12
Comments
|
|
Sometimes it happens that we need random row (or set of randoms rows) from table.
Itzik Ben-Gan shows us, in one of his book, the efficient way to do this:
SELECT TOP(1) * FROM someTable ORDER BY NEWID()
Changing the value in TOP operator, we can, in...
|
|
-
5
Liked
|
3
Learned
|
1
Comments
|
|
Learned today that converting hexadecimal values to varbinary and vice versa is easier in SQL Server 2008 compared to SQL Server 2005. MS made life simpler with SQL 2K8 :)
See below.
declare @hexstring varchar(max);
set @hexstring = '0xabc...
|
|
-
4
Liked
|
2
Learned
|
5
Comments
|
|
Earlier this week, one of the developers encountered issues when he tried to make a copy of the database on the server instance with a different name. He used the copy database wizard to perform this task. I was under the impression that he used the bac...
|
|
-
|
|
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to help...
|
|
-
|
|
Show table header in each page follow this steps..
1) in the grouping pane, click on the small triangle (Near "Column Groups") and select "Advanced Mode" to show static members.
2) Now select "static" and set **RepeatOnNewPage** to true for repeatin...
|
|
-
1
Liked
|
2
Learned
|
7
Comments
|
|
This script shows how to find the beginning of current financial year (for countries using April 1 as the beginning) using TSQL.
SELECT
DATEADD(dd,0,
DATEDIFF(dd,0,
DATEADD(
mm,
-(((12 + DATEPART(m, getDate())) - 4)%12),
g...
|
|
-
5
Liked
|
3
Learned
|
1
Comments
|
|
I just learn from Dhananjay blog that we can run a C program in visual studio 2008 onward version I am not sure about earlier version we can run or not ? lets try.......
|
|
-
17
Liked
|
14
Learned
|
2
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...
|
|
-
|
|
Step:1 Open Visual Studio 2010.
Step 2 – Go to Tools -> Options -> Text Editor -> All Languages. Then, unchecked the Auto list members check-box.
Thank You
Kirti Darji...
|
|