Hot File

SQL Server

  • Insufficient access rights error when doing backup in SQL Server

    View: 432    Download: 0   Comment: 0   Author: none  

    Insufficient access rights error when doing backup in SQL Server

    Category: SQL Server
    Fields: none

    2.25/2 review
    All of sudden SQL Server Management studio gives me the following error message when I'm trying to browse for the backup file location.

  • Migrate MySQL to Microsoft SQL Server

    View: 2499    Download: 0   Comment: 0   Author: none  

    Migrate MySQL to Microsoft SQL Server

    Category: SQL Server
    Fields: none

    0/2 review
    This article describes a few simple steps in order to migrate MySQL into Microsoft SQL Server 2005. The technique is very easy, but useful if you plan to move your data from MySQL and upgrade it finally to a Microsoft SQL Server environment.

  • COUNT of DISTINCT Rows in SQL Server

    View: 1342    Download: 0   Comment: 0   Author: none  

    COUNT of DISTINCT Rows in SQL Server

    Category: SQL Server
    Fields: Other

    0/4 review
    SQL Server does not support COUNT(DISTINCT *). For example, the below query fails.

  • Finding SQL Servers on the Network

    View: 681    Download: 0   Comment: 0   Author: none  

    Finding SQL Servers on the Network

    Category: SQL Server
    Fields: Other

    0/2 review
    I am a TSQL fanatic. The programs I code are highly dependent upon MS SQL stored procedures. I pay for this love of TSQL when a major overhaul of the system is necessary. Sometimes my code needs to be updated heavily in two places; client and...

  • SQL Server and Database Enumerator

    View: 662    Download: 0   Comment: 0   Author: none  

    SQL Server and Database Enumerator

    Category: SQL Server
    Fields: Other

    0/1 review
    This sample helps you to enumerate the list of SQL Servers and the databases and languages that a particular SQL server has. The class CSQLInfoEnumerator encapsulates this functionality into it.

  • Dynamic Management Views [DMV] – A SQL Server 2005 Feature

    View: 674    Download: 0   Comment: 0   Author: none  

    Dynamic Management Views [DMV] – A SQL Server 2005 Feature

    Category: SQL Server
    Fields: Other

    0/2 review
    The DMVs; newly introduced in SQL Server 2005 gives the database administrator information about the current state of the SQL Server machine. These values will help the administrator to diagnose problems and tune the server for optimal performance....

  • Table Value Parameter in SQL Server 2008

    View: 592    Download: 0   Comment: 0   Author: none  

    Table Value Parameter in SQL Server 2008

    Category: SQL Server
    Fields: Computers - Technology

    0/1 review
    One of the fantastic new features of SQL Server 2008 is the Table value parameter. In previous versions of SQL Server, there wasn’t a native way to pass a table to a Stored Procedure or functions. The usual workaround was to pass a large varchar or...

  • SQL Server DO's and DONT's

    View: 584    Download: 0   Comment: 0   Author: none  

    SQL Server DO's and DONT's

    Category: SQL Server
    Fields: Computers - Technology

    0/0 review
    So, you are now the leader of a SQL Server based project and this is your first one, perhaps migrating from Access. Or maybe you have performance problems with your SQL Server and don't know what to do next. Or maybe you simply want to know of some...

  • Connecting SQL Server 2012 Express from SharePoint 2013 Configuration Wizard

    View: 972    Download: 0   Comment: 0   Author: none  

    Connecting SQL Server 2012 Express from SharePoint 2013 Configuration Wizard

    Category: SQL Server
    Fields: Computers - Technology

    0/1 review
    This article is intended to provide resolution/suggestion in case you face problem while connecting to SQL Server 2012 Express edition (installed on Windows Server 2008 R2) either through SharePoint or SQL Server Management Tool (from other server)...

  • Getting started with SQL Server Everywhere

    View: 744    Download: 2   Comment: 0   Author: none  

    Getting started with SQL Server Everywhere

    Category: SQL Server
    Fields: Education - Schools

    0/0 review
    This article explains how to programmatically use SQL Server Everywhere (embedded) in a C# program.

  • SQL Server 2005 Paging Results

    View: 690    Download: 0   Comment: 0   Author: none  

    SQL Server 2005 Paging Results

    Category: SQL Server
    Fields: Computers - Technology

    0/3 review
    With SQL Server 2005, it is now a lot easier to use paged queries than in previous versions. I will be using the NorthWind database (mostly), so you can also use the examples I have provided. I will keep the examples simple; anything complex will...

  • Database Integration With SQL Azure

    View: 647    Download: 0   Comment: 0   Author: none  

    Database Integration With SQL Azure

    Category: SQL Server
    Fields: Education - Schools

    0/1 review
    We can integrate our database with SQL Azure by using the SQLAzureMW tool that is SQL Azure plugin for migrating the database from our local database to the Windows Azure cloud.

  • SQL Server to SQL Server Compact Edition

    View: 971    Download: 0   Comment: 0   Author: none  

    SQL Server to SQL Server Compact Edition

    Category: SQL Server
    Fields: Education - Schools

    0/3 review
    This utility will copy the schema and data from a normal SQL Server 2000/2005 database and export it to a SQL Server Compact Edition database. The tool supports version 3.1 or 3.5 of SQL Server Compact Edition.

  • SQL LEFT JOIN Keyword

    View: 703    Download: 0   Comment: 0   Author: none  

    SQL LEFT JOIN Keyword

    Category: SQL Server
    Fields: Education - Schools

    0/4 review
    SQL LEFT JOIN Keyword The LEFT JOIN keyword returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match.

  • SQL Quick Reference From W3Schools

    View: 1258    Download: 0   Comment: 0   Author: none  

    SQL Quick Reference From W3Schools

    Category: SQL Server
    Fields: Education - Schools

    0/3 review
    SELECT column_name(s) FROM table_name WHERE condition AND|OR condition

  • SQL Aliases

    View: 730    Download: 0   Comment: 0   Author: none  

    SQL Aliases

    Category: SQL Server
    Fields: Education - Schools

    0/3 review
    SQL aliases are used to temporarily rename a table or a column heading.

 
Newsletter Email

File suggestion for you

File top downloads

logo codetitle
Codetitle.com - library source code to share, download the file to the community
Copyright © 2015. All rights reserved. codetitle.com Develope by Vinagon .Ltd