Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
650 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 13
Page Size: 10 · 25 · 50

Category filtered by:  Database [x] | Database [x] | SQL Server [x]
Article 13 May 2013   license: CPOL
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
Database » Database » Sql Server
SQL2000SQL2005SQLSQL-ServerDBADevBeginnerIntermediateSQL-ServerSQL2008, +
Article 12 May 2013   license: CPOL
Implementation of relative database constraints and permissioning using triggers and shadow tables
Database » Database » Sql Server
SQLSQL-Serverdatabase
Tip/Trick 10 May 2013   license: CPOL
Database » Database » Sql Server
SQLBeginnerIntermediate
Tip/Trick 8 May 2013   license: CPOL
Merge in SQL Server 2008.
Database » Database » Sql Server
SQL-Server
Technical Blog 7 May 2013   license: CPOL
Difference between SET QUOTED_IDENTIFIERS ON and OFF settings.
Database » Database » Sql Server
SQL
Technical Blog 7 May 2013   license: CPOL
The new Merge statement in SQL Server 2008.
Database » Database » Sql Server
SQLSQL-ServerDBADevBeginner
Tip/Trick 7 May 2013   license: CPOL
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.
Database » Database » Sql Server
SQL
Tip/Trick 6 May 2013   license: CPOL
This article explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by Sql Server.
Database » Database » Sql Server
WinXPWin2003VistaSQL2005SQLWindowsSQL-ServerDBAWindowsSQL-Server, +
Article 5 May 2013   license: CPOL
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.
Database » Database » Sql Server
SQL2000SQL2005SQL-ServerDevBeginnerIntermediateSQL-ServerSQL2008SQL2008R2SQL2012
Tip/Trick 3 May 2013   license: CPOL
How to prevent SQL injection attacks when using dynamic SQL in stored procedures
Database » Database » Sql Server
SQLSQL-ServerIntermediateSQL-ServerSQL2008
Technical Blog 3 May 2013   license: CPOL
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
Database » Database » Sql Server
SQLWindowsSQL-ServerArchitectDBADevBeginnerIntermediateAdvancedSysAdmin
Technical Blog 3 May 2013   license: CPOL
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
Database » Database » Sql Server
WindowsSQL-ServerDevIntermediateAdvancedSQLSysAdmin
Article 2 May 2013   license: CPOL
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Date and Time Data Types and Functions with Sample SQL Statements. Data Type Tables, Function Tables
Database » Database » Sql Server
SQL2000SQL2005SQLSQL-ServerDevBeginnerIntermediateSQL-ServerSQL2008SQL2008R2, +
Technical Blog 2 May 2013   license: CPOL
This post shows how to insert a comma-separated string into multiple rows in a table in SQL Server.
Database » Database » Sql Server
SQL2005SQL.NETDevIntermediateSQL-Server
Article 29 Apr 2013   license: CPOL
One of the things that drew me to SQL Server 2012 was the FileTable feature. It seemed to be a great fit for my need, and to relatively easy to implement. Here’s my scenario, the solution I chose, the “gotchas” I ran into, and how I dealt with them.
Database » Database » Sql Server
SQLSQL-ServerDBAAdvanced
Article 24 Apr 2013   license: CPOL
Create a SQL Server database using C#.
Database » Database » Sql Server
.NET1.1Win2KSQL2000VS.NET2003C#SQLDBADevIntermediateWindows, +
Tip/Trick 24 Apr 2013   license: CPOL
Custom StringPadding functions for SQL Server
Database » Database » Sql Server
SQL2000SQL2005SQLSQL-ServerBeginnerIntermediateSQL-ServerSQL2008
Tip/Trick 19 Apr 2013   license: CPOL
The TOP clause is commonly used to get the top required rows from a result set. The beauty of this clause is that it can be used with the WITH TIES clause to retrieve all similar rows to a base result set.
Database » Database » Sql Server
SQL2005SQL-ServerSQL-ServerSQL2008SQL2012
Tip/Trick 19 Apr 2013   license: CPOL
Restore failure from Enterprise to Standard edition in SQL Server.
Database » Database » Sql Server
SQL2005SQL-ServerSQL-ServerSQL2008
Tip/Trick 19 Apr 2013   license: CPOL
Automatic query execution at every instance startup.
Database » Database » Sql Server
SQL2005SQL-ServerDBASQL-ServerSQL2008SQL2012
Technical Blog 18 Apr 2013   license: CPOL
This DMV allows you to discover a lot of very interesting and important performance information about your cached stored procedures.
Database » Database » Sql Server
SQL-ServerSQL2008
Tip/Trick 15 Apr 2013   license: CPOL
Without transaction if any DML statement are executed in the database then that can be rolled back in sql server.
Database » Database » Sql Server
SQLADO.NET
Technical Blog 13 Apr 2013   license: CPOL
Background Say we have a registration table which store successful registration info. At that table we have a column “Name” which stores value as combination of first name & last name delimited by ‘ ‘ [space]. Later at some point we need to extract the first name or last name
Database » Database » Sql Server
SQLWindowsSQL-ServerArchitectDevBeginnerIntermediateAdvanceddatabasesplitter, +
Article 11 Apr 2013   license: CPOL
This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models and not just Tabular Models.
Database » Database » Sql Server
SQLSharepointServerpowerview2013
Article 8 Apr 2013   license: CPOL
How to effectivley version your SQL Server databases using SQL Server Data Tools
Database » Database » Sql Server
SQLWindowsSQL-ServerDBADevIntermediate
Tip/Trick 8 Apr 2013   license: CPOL
Term Lookup is the one of the powerful Transformations in SQL Server Integration Service. This transformation basically helps to analyze the set of text records.
Database » Database » Sql Server
SQL-ServerDevIntermediate
Article 3 Apr 2013   license: CPOL
How to configure database mail in SQL Server 2008
Database » Database » Sql Server
SQL-ServerDBA
Article 30 Mar 2013   license: CPOL
How to import data from a .mdf file to SQL Server and from SQL Server to Excel
Database » Database » Sql Server
DBASQLServer
Article 22 Mar 2013   license: CPOL
OQMS 1.0 allows you to connect your server online and manage the table like Select, Insert, Update and Delete statements.
Database » Database » Sql Server
SQL2005.NET3.5C#SQL-ServerBeginner.NETSQL-Server
Technical Blog 21 Mar 2013   license: CPOL
Fixing the SSDT unresolved reference to object error.
Database » Database » Sql Server
SQL-Server
Article 14 Mar 2013   license: CPOL
In this article we will talk about the next 5 interesting SQL Server 2012 features.
Database » Database » Sql Server
SQL.NETArchitectDBADevBeginnerIntermediateServerInterviewquestions, +
Article 14 Mar 2013   license: CPOL
In this article I will discuss 5 features of SQL Server 2012 and the rest will be followed in other parts..
Database » Database » Sql Server
SQLSQL-ServerArchitectDBADevBeginnerIntermediateAdvancedServer
Article 13 Mar 2013   license: CPOL
This sample project demonstrates how to save a file to a SQL Server database and also how to pull a file out of the database.
Database » Database » Sql Server
C#3.0.NET3.5SQL-ServerDevIntermediateC#.NETVisual-StudioVS2010
Article 11 Mar 2013   license: CPOL
This article clears the differences between the On cluase and Where clause when used with left join.
Database » Database » Sql Server
SQLSQL-ServerDBADevAdvanced
Technical Blog 6 Mar 2013   license: CPOL
Availability groups (AG) is used for (remote) disaster recovery.
Database » Database » Sql Server
SQL-Server
Tip/Trick 4 Mar 2013   license: CPOL
How to compare database schema in VS 2012 and how to update the target database to the server
Database » Database » Sql Server
SQLSQL-ServerVisual-StudioDBADevBeginnerVisual-Studio-2012
Tip/Trick 2 Mar 2013   license: CPOL
Replicate/Clone/Duplicate selected data in a Table using merge statment
Database » Database » Sql Server
SQLSQL-ServerDBADevIntermediateSQL-ServerSQL2008SQL2012databseDBMS
Tip/Trick 27 Feb 2013   license: CPOL
Easily find table description.
Database » Database » Sql Server
SQLSQL-Server
Tip/Trick 27 Feb 2013   license: CPOL
New high-availability/disaster-recovery solution provided by SQL Server 2012.
Database » Database » Sql Server
SQLSQL-Server
Tip/Trick 25 Feb 2013   license: CPOL
Triki game created in SQL Server with triggers.
Database » Database » Sql Server
SQL2005DevIntermediateSQL-ServerSQL2008
Article 19 Feb 2013   license: CPOL
Standardization database object name with SQL Server Policy Based Management.
Database » Database » Sql Server
Win2KWinXPWin2003VistaSQLWindowsSQL-ServerArchitectDBADev, +
Tip/Trick 13 Feb 2013   license: CPOL
This tip is desired for those who want to list all available SQl Server instances that are in a network.
Database » Database » Sql Server
WindowsSQL-ServerBeginnerVBVB.NETLAN
Technical Blog 12 Feb 2013   license: CPOL
Primary Key and non-clustered index in simple words.
Database » Database » Sql Server
SQLSQL-ServerDevIntermediate
Technical Blog 10 Feb 2013   license: CPOL
This article explains the main concepts involved and then the possible options to Clean the SQL Server Cache.
Database » Database » Sql Server
SQL-Server
Tip/Trick 1 Feb 2013   license: CPOL
This article shows case study, how to rebuild master database
Database » Database » Sql Server
SQLDBABeginnerIntermediate
Article 1 Feb 2013   license: CPOL
CT is a new feature in SQL Server 2008 which allows us to track information about changes that we have made to tables in which CT is enabled.
Database » Database » Sql Server
SQLSQL-ServerSQL-ServerSQL2008database
Tip/Trick 30 Jan 2013   license: CPOL
Return Comma Separated String using SQL
Database » Database » Sql Server
SQL2005C#1.0C#2.0C#3.0C#ASP.NETWCFWebFormsBeginnerIntermediate, +
Tip/Trick 29 Jan 2013   license: CPOL
Get duration between two dates in years, months, days, and hours using SQL Server.
Database » Database » Sql Server
SQL2000SQL2005SQLSQL-ServerSQL-Server
Tip/Trick 29 Jan 2013   license: CPOL
Simple SP to drop any general type of SQL Server object
Database » Database » Sql Server
C#SQL-ServerBeginner
Tip/Trick 28 Jan 2013   license: CPOL
This article is not going to give you a pinpoint solution for a specific delete challenge, but rather it is meant to give a broader picture of the problem domain and the various tools you can opt based on your situation.
Database » Database » Sql Server
databasedelete
Page 1 of 13
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web03 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid