GitHub

Create tempDB files based on proc.sql

,@new_tempdbdev_size_MB INT -- Size of the new files,in Megabytes ,@new_tempdbdev_Growth_MB INT -- New files growth rate,in Megabytes SELECT @new_tempdbdev_size_MB = 4096 -- Four Gbytes , it's easy to ...
LinkedIn

SAS - Proc SQL

PROC SQL is a powerful Base SAS_ Procedure that combines the functionality of DATA and PROC steps into a single step. PROC SQL can sort, summarize, subset, join (merge), and concatenate datasets, ...
Simon Fraser University

PROC SQL Pass-Through Views

A Version 6 PROC SQL Pass-Through view does not need to be updated to be used in Version 7 or Version 8. The conversion of PROC SQL Pass-Through views is automatic and does not require you to use the ...
Simon Fraser University

CREATE VIEW Statement

PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...
GitHub

Create-C-VB.Net-Class-and-MS-SQL-Stored-Proc-Generator-from-MS-SQL-Database

I originally submitted this project on Planet Source Code. But since then Microsoft also broke their SQL Web Browsing service that allowed this program (and others) to be able to search for any SQL ...