Click here to Skip to main content
15,892,059 members
Articles / Web Development / XHTML

SQL Simple Utilities

Rate me:
Please Sign up or sign in to vote.
4.68/5 (13 votes)
22 Sep 2016CPOL15 min read 35.7K   1.8K   32  
This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.
'------------------------------------------------------------------------------
' <auto-generated>
'     This code was generated by a tool.
'     Runtime Version:4.0.30319.18444
'
'     Changes to this file may cause incorrect behavior and will be lost if
'     the code is regenerated.
' </auto-generated>
'------------------------------------------------------------------------------

Option Strict On
Option Explicit On

Imports System

Namespace My.Resources
    
    'This class was auto-generated by the StronglyTypedResourceBuilder
    'class via a tool like ResGen or Visual Studio.
    'To add or remove a member, edit your .ResX file then rerun ResGen
    'with the /str option, or rebuild your VS project.
    '''<summary>
    '''  A strongly-typed resource class, for looking up localized strings, etc.
    '''</summary>
    <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Resources.Tools.StronglyTypedResourceBuilder", "4.0.0.0"),  _
     Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
     Global.System.Runtime.CompilerServices.CompilerGeneratedAttribute(),  _
     Global.Microsoft.VisualBasic.HideModuleNameAttribute()>  _
    Friend Module Resources
        
        Private resourceMan As Global.System.Resources.ResourceManager
        
        Private resourceCulture As Global.System.Globalization.CultureInfo
        
        '''<summary>
        '''  Returns the cached ResourceManager instance used by this class.
        '''</summary>
        <Global.System.ComponentModel.EditorBrowsableAttribute(Global.System.ComponentModel.EditorBrowsableState.Advanced)>  _
        Friend ReadOnly Property ResourceManager() As Global.System.Resources.ResourceManager
            Get
                If Object.ReferenceEquals(resourceMan, Nothing) Then
                    Dim temp As Global.System.Resources.ResourceManager = New Global.System.Resources.ResourceManager("SqlSimpleUtilities.Resources", GetType(Resources).Assembly)
                    resourceMan = temp
                End If
                Return resourceMan
            End Get
        End Property
        
        '''<summary>
        '''  Overrides the current thread's CurrentUICulture property for all
        '''  resource lookups using this strongly typed resource class.
        '''</summary>
        <Global.System.ComponentModel.EditorBrowsableAttribute(Global.System.ComponentModel.EditorBrowsableState.Advanced)>  _
        Friend Property Culture() As Global.System.Globalization.CultureInfo
            Get
                Return resourceCulture
            End Get
            Set
                resourceCulture = value
            End Set
        End Property
        
        '''<summary>
        '''  Looks up a localized string similar to SELECT 
        '''	ROW_NUMBER() OVER(ORDER BY c.name + &apos;.&apos; + b.name, e.name + &apos;.&apos; + d.name) Id
        '''	, c.name + &apos;.&apos; + b.name ChildTable
        '''	, e.name + &apos;.&apos; + d.name ParentTable
        '''	, f.name ChildColumn
        '''	, g.name ParentColumn
        '''	, b.object_id ChildId
        '''	, d.object_id ParentId
        '''	, h.name ChildColumnType
        '''	, i.name ParentColumnType
        '''	, f.max_length ChildColumnLength
        '''	, g.max_length ParentColumnLength
        '''	, g.is_identity ParentColumnIsIdentity
        '''	, g.name UniqueColumn
        '''	, CONVERT(BIT, CASE WHEN j.object_id IS NULL THEN 1 ELSE 0 END [rest of string was truncated]&quot;;.
        '''</summary>
        Friend ReadOnly Property SqlGetForeignKeys1() As String
            Get
                Return ResourceManager.GetString("SqlGetForeignKeys1", resourceCulture)
            End Get
        End Property
        
        '''<summary>
        '''  Looks up a localized string similar to SELECT a.object_id, b.name + &apos;.&apos; + a.name TableName, c.name IdentityColumnName 
        '''FROM sys.tables a
        '''INNER JOIN sys.schemas b ON a.schema_id = b.schema_id
        '''LEFT JOIN sys.columns c ON a.object_id = c.object_id AND is_identity = 1
        '''ORDER BY 2, 3.
        '''</summary>
        Friend ReadOnly Property SqlGetTables() As String
            Get
                Return ResourceManager.GetString("SqlGetTables", resourceCulture)
            End Get
        End Property
    End Module
End Namespace

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior) Unisystems
Greece Greece
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions