patrick gallucci's sql server brain drain
Browse by Tags
All Tags »
SQL Script (RSS)
-
This is a follow-up to the blog entry from Jasper Jugan . This is a modification to the script to allow for schema specific deletes of the SP's, Views and I added Functions. create procedure usp_DropSPFunctionsViews as -- variable to object Read More...
|
-
I would have to say that one of my favorite new utilities that shipped with SQL Server 2005 has been the SQLCMD utility . I am going to demonstrate the use of include files. The following is the complete call syntax for SQLCMD. sqlcmd [{ { -U login_id Read More...
|
-
These tables can be used for testing various data types of SQL Server. You can extend as needed. SET NUMERIC_ROUNDABORT OFF ; SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,QUOTED_IDENTIFIER, ANSI_NULLS ON ; GO -- Create XML Schema Read More...
|
-
Here is a view that contains column information. This is useful if you need to create a DDL statement for a table. CREATE VIEW dbo.vColumnInfo AS SELECT tbl.name AS [Table_Name], SCHEMA_NAME(tbl.schema_id) AS [Table_Schema], CAST (ISNULL(cik.index_column_id Read More...
|
-
This script will generate tsql code to bcp and bulk load data for all tables in a given DB. SET NOCOUNT ON GO DECLARE @ path nvarchar(2000), @batchsize nvarchar(40), @format nvarchar(40), @serverinstance nvarchar(200), @security nvarchar(800) SET @ path Read More...
|
