Search

Category filtered by: Database [x] | Database [x] | SQL Server [x]

String Data Types and Functions - SQL Server (2000, 2005, 2008, 2008 R2, 2012) by Shemeer NS

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, +

Relative Constraints and Permissioning in T-SQL by h_wiedey

Article 12 May 2013 license: CPOL

Implementation of relative database constraints and permissioning using triggers and shadow tables

Database » Database » Sql Server

SQLSQL-Serverdatabase

WITH (NOLOCK) example by Amey K Bhatkar

Tip/Trick 10 May 2013 license: CPOL

Database » Database » Sql Server

SQLBeginnerIntermediate

Merge in SQL Server 2008 by PratapReddyP

Tip/Trick 8 May 2013 license: CPOL

Merge in SQL Server 2008.

Database » Database » Sql Server

SQL-Server

Difference Between SET QUOTED_IDENTIFIERS ON and OFF settings by Basavaraj P Biradar

Technical Blog 7 May 2013 license: CPOL

Difference between SET QUOTED_IDENTIFIERS ON and OFF settings.

Database » Database » Sql Server

SQL

Merge Statement in SQL Server 2008 by Basavaraj P Biradar

Technical Blog 7 May 2013 license: CPOL

The new Merge statement in SQL Server 2008.

Database » Database » Sql Server

SQLSQL-ServerDBADevBeginner

Using comma separated value parameter strings in SQL IN clauses by OriginalGriff

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

Check Digit Vertical and Horizontal by Hernán Hegykozi

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, +

SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats. by Shemeer NS

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

How to prevent SQL Injection in Stored Procedures by Wong Shao Voon

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

TSQL Recursive Split Function by Shahriar Iqbal Chowdhury/Galib

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

Solution To The MSSQL Server “Suspect” by Shahriar Iqbal Chowdhury/Galib

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

Date and Time Data Types and Functions - SQL Server (2000, 2005, 2008, 2008 R2, 2012) by Shemeer NS

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, +

Adding items in comma-separated string into separate rows in SQL Server by Amogh Natu

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

SQL Server 2012 FileTable, My first experience by Dan Kearney

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

Create an SQL Server Database Using C# by Nguyen Thanh Phuong

Article 24 Apr 2013 license: CPOL

Create a SQL Server database using C#.

Database » Database » Sql Server

.NET1.1Win2KSQL2000VS.NET2003C#SQLDBADevIntermediateWindows, +

SQL Server StringPadding (String function) by Surender Singh (CodeToast)

Tip/Trick 24 Apr 2013 license: CPOL

Custom StringPadding functions for SQL Server

Database » Database » Sql Server

SQL2000SQL2005SQLSQL-ServerBeginnerIntermediateSQL-ServerSQL2008

SQL Server: TOP…WITH TIES - A Beauty of TSQL by aasim abdullah

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

SQL Server: Restore Failure from Enterprise to Standard Edition by aasim abdullah

Tip/Trick 19 Apr 2013 license: CPOL

Restore failure from Enterprise to Standard edition in SQL Server.

Database » Database » Sql Server

SQL2005SQL-ServerSQL-ServerSQL2008

SQL Server: Automatic Query Execution at Every Instance Startup by aasim abdullah

Tip/Trick 19 Apr 2013 license: CPOL

Automatic query execution at every instance startup.

Database » Database » Sql Server

SQL2005SQL-ServerDBASQL-ServerSQL2008SQL2012

DMV-6 : How well is my stored procedure doing? by Rohitmssqlfun

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

Secure way of executing Update statement in SQL Server by sisirp88

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

TSQL split a string by delimiter by Shahriar Iqbal Chowdhury/Galib

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, +

Install Power View for multi-dimensional model by Ivan Paniagua

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

Versioning SQL Server Databases using SSDT by Shining Dragon

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

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`

		9,868,710 members (30,974 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Sort by

Match

Rating Range