Skip to content

Instantly share code, notes, and snippets.

View csprofile's full-sized avatar

CS csprofile

View GitHub Profile
@csprofile
csprofile / findStoredProc.sql
Last active June 17, 2016 12:48
Return table with all called stored procedures from a SP.
DECLARE @SPName NVARCHAR(MAX) = 'SPName'
DECLARE @T TABLE (T VARCHAR(MAX))
INSERT INTO @T
EXEC SP_HELPTEXT @SPName
SELECT LTRIM(REPLACE(T,' ',''))
FROM @T
WHERE T LIKE '%EXEC%'
AND T NOT LIKE '%xp_logevent%'
@csprofile
csprofile / String_Replace_SysObjects.sql
Created October 19, 2016 13:11
Script to replace ocurrences in all Functions, Views and Stored Procedures - SQL SERVER
-- Include strings to replace in @ServerList
DECLARE @ServerList TABLE (Id INT IDENTITY(1,1), Prod VARCHAR(MAX), Dev VARCHAR(MAX))
INSERT INTO @ServerList (Prod,Dev) VALUES
('String_In_Prod001', 'String_In_Dev001')
,('String_In_Prod002', 'String_In_Prod002')
static class Program
{
/// <summary>
/// The main entry point for the application.
/// </summary>
static void Main()
{
#if (!DEBUG) //Release
ServiceBase[] ServicesToRun;
CREATE DATABASE AccessX
GO
USE AccessX
GO
CREATE TABLE [dbo].[AccessDB](
[LOJA] [nvarchar](50) NULL,
[DATA] [nvarchar](50) NULL,
[CODIGO DO MATERIAL] [nvarchar](50) NULL,
[QUANTIDADE] [nvarchar](50) NULL,
[TOTAL DO ITEM] [nvarchar](50) NULL,
$http({
method: 'POST',
url: '/upload-file',
headers: {
'Content-Type': 'multipart/form-data'
},
data: {
email: Utils.getUserInfo().email,
token: Utils.getUserInfo().token,
upload: $scope.file