18 Dec '12 - 4:18 by Curtis Shull (updated)
Using IOC/DI and Repository Factory with LightCore.
15 hrs ago by Shemeer NS (updated)
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables
yesterday by h_wiedey (new)
Implementation of relative database constraints and permissioning using triggers and shadow tables
yesterday by Shemeer NS (updated)
.NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language. CultureInfo, DateFormat, Number Format, Currency Format, Percent Format, Infinity Format etc.
3 days ago by Bishram (new)
Recruitment and selection process is a very important aspect in acquiring and managing talent in any organization. Typically, the process is owned by Human Resource Department.
5 days ago by saimm (new)
How to export SQL data to Excel using VB.NET
5 days ago by Joffrey Brouillet (new)
This is an alternative for "A set of ADO classes - version 2.20"
5 days ago by Christoph Buenger (updated)
Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).
7 May '13 - 14:41 by Espen Harlinn (updated)
Enhance productivity and reliability, write your own tools.
7 May '13 - 5:05 by Frederico Regateiro (updated)
This project creates a Visual Studio visualizer for entity framework queries, view edit and run the generated SQL.
6 May '13 - 2:24 by Shemeer NS (new)
CAST(), CONVERT(), PARSE(), TRY_PARSE(), TRY_CONVERT(), FORMAT(), SQL Server Functions, SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.
17 Jul '11 - 16:20 by WebBiscuit (updated)
Microsoft has violated the holy rules of COM and broken their msado15.dll. The violation occurs after the installation of Windows 7 Service Pack 1 (version 6.1.7601.17514).
4 days ago by Ivan Krivyakov (new)
Random notes on MDX filtering
4 days ago by PRANAV SINGH (new)
Stored Procedure with sorting, paging, and filtering.
5 days ago by snorkie (new)
This post is designed to help you understand how to use the EXISTS keyword in your SQL query environment.
7 May '13 - 19:18 by Basavaraj P Biradar (updated)
Difference between SET QUOTED_IDENTIFIERS ON and OFF settings.
7 May '13 - 19:11 by Basavaraj P Biradar (updated)
The new Merge statement in SQL Server 2008.
3 May '13 - 9:33 by Shahriar Iqbal Chowdhury/Galib (new)
Background In my last post I showed how to split a string in TSQL. Problem with that splitting is it can split a string if resultant split count is <=2, i.e. it can split only string like “a,b” or “first,last” or “java,c”. But while doing the parsing of string of
3 May '13 - 9:31 by Shahriar Iqbal Chowdhury/Galib (new)
Background When you see the your database in Suspect mode that a code red situation. Its not something that you face everyday. It can happen, however, most often due to faulty hardware or operational mistakes (like deleting a transaction log file). This post will show how to recover from suspect mod
2 May '13 - 9:12 by Amogh Natu (updated)
This post shows how to insert a comma-separated string into multiple rows in a table in SQL Server.
2 May '13 - 7:08 by Pragmateek (updated)
[toc] Introduction Note to pedantic guys: yes Access is not a database engine, only the graphical front-end to Jet/ACE, but we’ll stand with this simplification. The sample application (Excel + VBA) and the SQL source code are available in this … Continue reading →
25 Apr '13 - 10:06 by Keyhole Software (new)
Introduction to MonoTouch Library sqlite-net
21 Jun '10 - 8:43 by Pranay Rana (updated)
Getting a SQL Server RowCount Without doing a Table Scan
3 days ago by Amey K Bhatkar (updated)
3 days ago by Youqi Ma (new)
Using a controller to manage dynamic control form events and creation.
3 days ago by ShajuAntony (new)
List out reports from Reprting Server.
4 days ago by Sukant Shekhar (new)
Creation of random and unique code
5 days ago by PratapReddyP (new)
Merge in SQL Server 2008.
8 May '13 - 0:45 by grandtree (updated)
Create a calendar by inputting month
7 May '13 - 19:09 by Basavaraj P Biradar (updated)
Difference between SQL Server Char and Varchar data type.
7 May '13 - 12:09 by OriginalGriff (updated)
Passing a comma separated list of values to an SQL query is all very well, but you can't just use them in an "IN" clause. This helps.
7 May '13 - 1:03 by Hernán Hegykozi (new)
This tip explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by SQL Server.
5 May '13 - 20:08 by mohammad amiri (updated)
Paging DataGridView using LINQ in C#.
Latest 