SQL SERVER - Few Useful DateTime Functions to Find Specific Dates
Author: Freeacode.com
Description:
which contains many useful SQL Server Date functions. Sql server date time functions
Category:
SQL SERVER 2008
|
MSSQL SERVER - 2008 - Introduction to Merge Statement - One Statement for INSERT, UPDATE, DELETE
Author: Freeacode.com
Description:
MERGE is a new feature that provides an efficient way to perform multiple DML operations. In previous versions of SQL Server, we had to write separate statements to INSERT, UPDATE, or DELETE data based on certain conditions
Category:
SQL SERVER 2008
|
ToCSVString Extension Method
Author: Freeacode.com
Description:
So he started thinking and decided to create a new list. The clients selected the items by clicking some filter options. Items are then returned by a CAML query and inserted into that new list.
Category:
Csharp.NET
|
Overriding methods on System.Data.Services.DataService
Author: Freeacode.com
Description:
There are three methods on the DataService class that you might want to override.
Category:
ADO.NET
|
System.Data.Services.Internal is rather visible
Author: Freeacode.com
Description:
The System.Data.Services.Internal namespace, you might have noticed that the types are rather visible. What's up with that?
Category:
ADO.NET
|
Easy Way to Earn Money
Author: Freeacode.com
Description:
Easy Way to Earn Money
Category:
money
|
Microsoft Second Shot EXAM OFFER
Author: Freeacode.com
Description:
Microsoft Second Shot EXAM OFFER HURRY.
Category:
Exam
|
Microsoft SQL Server 2008 Books Online - BOL - English
Author: Freeacode.com
Description:
SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008.
Category:
SQL SERVER 2008
|
Visual Studio 2008 SP1 Download
Author: Freeacode.com
Description:
Visual Studio 2008 SP1 Download
Category:
Visual Studio 2008
|
SQL Server 2008 Downloads Availables
Author: Freeacode.com
Description:
SQL Server 2008 Downloads Availables
Category:
SQL SERVER 2008
|
EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle
Author: pinaldave
Description:
EXCEPT clause in SQL Server is exactly similar to MINUS operation in Oracle. The EXCEPT query and MINUS query returns all rows in the first query that are not returned in the second query.
Category:
sql
|
SQL Server 2008 Pricing and Licensing
Author: pinaldave
Description:
SQL Server licensing and pricing are to intervined subjects and very important. I strongly suggest to use properly licensed SQL Server in any production environment.
Category:
sql
|
Effect of Order of Join In Query
Author: pinaldave
Description:
When compared both the results they are same but the order of rows is different in both the resultset.
Category:
sql
|
DATA 2.0: Expose And Consume Data in A Web Services World
Author: Elisa Flasko and Mike Flasko
Description:
The goal of the ADO.NET Data Services Framework is to create a simple REST-based framework for exposing and consuming data-centric services easily
Category:
ADO.NET
|
SQLAuthority News - Author BirthDay - SQL Server Birthday
Author: pinaldave
Description:
It always suprise me how many people remember my birthday and take time from their busy life to call me, email me, wish me or send me their warm greetings.
Category:
SQL SERVER
|
SQL SERVER - SQL SERVER - Simple Example of Recursive CTE - Part 2 - MAXRECURSION - Prevent CTE Infinite Loop
Author: pinaldave
Description:
I wrote about SQL SERVER - SQL SERVER - Simple Example of Recursive CTE. I right away received email from regular reader John Mildred that if I can prevent infinite recursion of CTE.
Category:
SQL SERVER
|
MySQL backup,compress and FTP from WinForms Application
Author: admin
Description:
What is this? From your Windows Forms application, implement two menu commandsa) backup entire MySQL database, compress it and send it with FTP to a ftp serverb) reverse = fetch from FTP server, uncompress, restore to MySQL Kind of open/save functionali...
Category:
csharp, C#
|
SQL SERVER mssqlsystemresource Resource Database
Author: pinaldave
Description:
It is read only database and contains system objects.The purpose of resource database is to facilitates upgrading to new version of SQL Server without any hassle.
Category:
sql
|
Styles, Templates and Visual State Manager
Author: admin
Description:
This tutorial will demonstrate how you can modify the appearance of controls in your application. There are numerous ways to do this, and various tools to do it with; I will attempt to cut through the noise and focus in on the three most common use cases.
Category:
asp.net
|
SQL SERVER - Simple Example of Recursive CTE
Author: pinaldave
Description:
Recursive is the process in which the query executes itself. It is used to get results based on the output of base query. We can use CTE as Recursive CTE (Common Table Expression)
Category:
sql
|