|
|
-
|
|
This chapter shows basic DOM manipulation in HTML. We will describe basic JavaScript methods that can be used to
alter web page appearance....
|
|
-
|
|
In this chapter, we will examine in more details use of XML as a method of data transfer between client and server...
|
|
-
|
|
I have already post the article previously with my PIVOT. As PIVOT same but working reversely and it is UNPIVOT. I do not want to miss the post using UNPIVOT and enjoyed UNPIVOT too. With PIVOT we can get aggregate data with Rows as Columns and with UNP...
|
|
-
49
Liked
| 46
Learned
| 31
Comments
|
|
Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column......
|
|
-
|
|
Every DBA has a daily activity review or monitor database backups as these database backups used for the restoration at other place and using for the database restore which used for reporting purpose or used in log shipping purpose. Because database backups are most important factor and first opti......
|
|
-
37
Liked
| 29
Learned
| 18
Comments
|
|
Goto www.google.com, type 3+4 in the search text box and press enter. You can also do something like 12*(5+5)-12/4......
|
|
-
|
|
In this post, we see that temporary tables allow the use of only 116 characters out of a possible 128. How are temporary tables named, and what happens to the restricted length of 12 characters? What is the naming logic for temporary tables?...
|
|
-
|
|
How can connection strings be used to change the behaviour of an application? In this post, we explore the use of the system function APP_NAME(), which returns the application name for the current session if set by the application....
|
|
-
|
|
Any SSRS report is not re-displaying the changed information when running the same report back-to-back, even though the report itself is set with the following in the SSRS setup:
Always run this report with the most recent data, Do not cache temporary c...
|
|
-
11
Liked
| 5
Learned
| 3
Comments
|
|
If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....
|
|