#nav-small-js {display:none;}

SQL Server Snippets

SQL Server Snippets/

Deployment mit sqlcmd.exe

Deployment via Scripts

DBMS Snippets

sqlcmd SQL Server

Logins

Erstellen von Logins

DBMS Snippets

CREATE SQL Server

Restore und Recovery

Restore und Recovery nur anhand eines .BAK und zig .TRN Files

DBMS Snippets

RESTORE SQL Server

Stubs

Allgemeine Stubs für Procedure resp. Function

DBMS Snippets

SQL Server

System Stored Functions

System Functions für Transact-SQL

DBMS Snippets

SQL Server

System Stored Procedures

System Stored Procedures für Transact-SQL

DBMS Snippets

SQL Server

System Tables

System Tabellen

DBMS Snippets

SQL Server

System Views

DBMS Snippets

SQL Server

Tools: bcp Export/Import

bcp /? usage: bcp {dbtable | query} {in | out | queryout | format} datafile [-m maxerrors] [-f formatfile] [-e errfile] [-F firstrow] [-L lastrow] [-b batchsize] [-n native type] [-c character type] …

DBMS Snippets

bcp SQL Server

Umbenennen einer DB

ALTER DATABASE [db_name_test] Modify Name = ‘db_name_dev’;

DBMS Snippets

ALTER SQL Server

Windows User/Gruppe

Lokale Windows-User in lokaler Gruppe mit Berechtigung auf lokalen SQL-Server

DBMS Snippets

CREATE SQL Server

Übersicht aller Spalten

inkl. Constraints, Descriptions

DBMS Snippets

Information Schema SQL Server