Results for tsql
I would like to know how to pass a list into openquery. To use a single value the following will work: DECLARE @TSQL varchar(8000), @VAR char(2) SELEC...
I have a T-SQL statement as shown here, but it's not returning the result I want: select * from Sales where Purchased = 'Orange' and Purchased != 'App...
I m using SQLServer 2016 and I have the table (TIMETABLE) with the follow time: ID Descrizione OraInizio OraFine 1 Morning 06:00:00 13:00...
I have this query: DECLARE @NUM AS INT --IT INDICATE THE NUMBER OF SECONDS TO GROUP THE DATA DECLARE @DATA_START AS DATETIME = DATEADD(yy, DATEDIFF(yy...
I try to parse JSON request using TSQL using SQL Server 2016. So I m using this function: ALTER FUNCTION [dbo].[AA_F_ParseJSON]( @JSON NVARCHAR(MAX)) ...
A similar question has been answered, but only for temporary tables. I want to use a temporary stored procedure, as per -- test if folder exists, el...
I have 3 temp tables all populated by 3 independent queries and are associated to each other with a 1 to 1 relationship, these tables are DemographicR...
What is wrong with the following code? BULK INSERT test FROM 'myfile_'+ CONVERT(VARCHAR(20), GETDATE(), 112) + '.TXT' WITH (FIRSTROW = 2, ...
what is the difference between the table names "#mytable" and "mytable" in TSQL? I see table names start with "#" in a lot of custom procedures. ...
I have a table which holds the guid for an user and their actual name as a string. I would like to grab some information based on an user. But which f...
How do I get the current size of the transaction log? How do I get the size limit? I'd like to monitor this so I can determine how often I need to ba...
I would like to replace (or remove) a newline character in a TSQL string. Any ideas? The obvious REPLACE(@string, CHAR(13), '') just won't do it... ...
What is the best way to get the names of all of the tables in a specific database on SQL Server? ...
How do I undo the most recent local commits in Git?
How can I remove a specific item from an array in JavaScript?
How do I delete a Git branch locally and remotely?
How can I find all files containing a specific text (string) on Linux?
How to find all files containing specific text (string) on Linux?
How do I revert a Git repository to a previous commit?
How do I create an HTML button that acts like a link?
How do I check out a remote Git branch?