Search

Category filtered by: Database [x]

Failover or Restart Results in Reseed of Identity – FIX by Gordon W Beeming

Technical Blog 14 May 2013 license: CPOL

Simply run the script and then every time SQL is restarted all your Identity columns will be reset to the latest available seed.

Database » Database » General

SQL

Connecting to MySQL databases using VB.NET by Hassantga

Tip/Trick 14 May 2013 license: CPOL

How to connect to a MySQL database using VB.NET.

Database » Database » Mysql

VB.NETVBVB.NET

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

Reports from Reporting Server by ShajuAntony

Tip/Trick 10 May 2013 license: CPOL

List out reports from Reprting Server.

Database » Sql Reporting Services » General

SQLReports

Back Up All Databases Using T-SQL by PRANAV SINGH

Technical Blog 9 May 2013 license: CPOL

Backing up all databases using T-SQL

Database » Sql Reporting Services » General

WCFT-SQL

Stored Procedure with Sorting, Paging, and Filtering by PRANAV SINGH

Technical Blog 9 May 2013 license: CPOL

Stored Procedure with sorting, paging, and filtering.

Database » Database » Sql

SQL

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

Export SQL Data to Excel using VB.NET by saimm

Article 8 May 2013 license: CPOL

How to export SQL data to Excel using VB.NET

Database » Database » Utilities

SQLOfficeVBVB.NET

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 (40,566 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Sort by

Match

Rating Range