Pages
(Move to ...)
Home
Thank You
▼
Tuesday, February 16, 2010
SQL Server - List-out Procedures, Functions, Triggers
›
In order to know which procedures, functions, and triggers exist in the database, the following queries can help you to find this out.: The ...
1 comment:
SQL Server - Insert Data From Linked Server Table
›
In a situation where Servers are linked, it is possible to retrieve data from a table in one server to a table on the other server. Followin...
Wednesday, February 3, 2010
SQL Server - Self Joins
›
To join tables, at-least two tables are required. It does not necessarily have to be two different tables :). It is possible to join a table...
Monday, February 1, 2010
SQL Server - Date Time Functions
›
Here are a few examples of functions that can help you manipulate DATE in different manners. These will comprise most of your daily job rout...
1 comment:
Sunday, January 31, 2010
SQL Server - CHARINDEX - Oracle INSTR
›
There is a ‘ CharIndex’ function in SQL Server which is similar to the Oracle ‘ Instr’ function. In Oracle, the syntax of the INSTR functi...
1 comment:
SQL Server - Sample Database Link
›
Here is the link for Microsoft SQL Server Community Projects & Samples. They have provided the best examples and databases in the follow...
Friday, January 29, 2010
SQL Server - List Out Number of Rows in Database
›
To List-Out The Number Of Rows In Each Table From The Current Database. To Find-Out Number Of Rows In Each Table In Database. /**********...
SQL Server - Monthly Report - Group by Month
›
The following example guide you to retrieve a monthly report. As discussed earlier, If the date column is SMALLDATETIME or DATETIME, we can ...
SQL Server - Daily Report - Group by Date
›
Like hourly report, the following example guide you to retrieve a daily report. As discussed earlier, If the date column is SMALLDATETIME or...
SQL Server - Hourly Report - Group by Hour
›
Sometimes it requires to know how many inserts are happend every hour in a transactions table OR how many payments made every hour OR to ret...
‹
›
Home
View web version