Lab Sql

Possible Duplicate: how do find the number of rows in a table when the table name is in a variable?… Read more Use A Variable For Table Name

I have declared 6 variables in a stored procedure and I'd like to store a query result (which m… Read more Store Query Result In Variable

I'm trying to create a query in GRAFANA with LIKE using the internal variables of the tool, but… Read more Use Variable Grafana In Query With Like

I want to pass variables in sqlplus command in my bash script, answer might be given but doesn'… Read more Passing Variable User,pass,sid In Sqlplus Comman

I wrote a code like this in execute sql task Declare @tmpHistoricDriveSpace Table ( Servername var… Read more How To Pass Table Variable Data Into A Data Flow In Ssis

I tried use a string variable in R script to use through SQL statement for example: x='PASS'… Read more Pass String Variable In R Script To Use It In Sql Statement

I have the following query: select * from cars where make in ('BMW', 'Toyota', &#… Read more Sql Server Store Multiple Values In Sql Variable

In my test plan I have JDBC PreProcessor that captures a single value that I'm trying to save i… Read more Jmeter Pre-processed Variable As Part Of Report File Name

I work wirh oracle Database. I have a plsql code where i run a query in a loop for multiple tables.… Read more How To Declare A Number Variable Where I Can Save Th Count Of Table In My Loop

I am trying to create a script that gives me the size of some databases. I have created the origina… Read more Sql Cmd: Pass Variables With Brackets And Single Quotes

I have an SSIS package that has a Foreach Loop container loading all .txt files in a static folder.… Read more How To Store 'fully Qualified' And 'name Only' File Name In Ssis Variable

I wrote a bash program to monitor bitcoin mining devices, it worked fantastically running one set o… Read more Parallel Processes In Bash Bitcoin Monitor That Records To Sql Leaking Data?

I have a stored procedure that I need to convert so that it reads a linked server variable from a t… Read more Converting A Query To Dynamic Sql With Linked Server Variable

Is there a way to identify local variables that have been created (or even created and set to a val… Read more Unused Variable Detection In Sql Server

I have only 1 column in my table, in this table there are inputs like 990x70, 980x50. I need the va… Read more Variables In T-sql

This is my first question here and I hope it is simple enough to get a quick answer! Basically, I h… Read more Like Operator With $variable

Using user variables to number rows I often find answers here on SO suggesting the use of user vari… Read more Guarantees When Using User Variables To Number Rows

I want to declare a server name and use this name in an insert statement. So far all i got is an er… Read more How To Use Variable In Target Database Name For Insert Statement?

I have the following code: DECLARE @x TABLE (item XML (document Galeries)) DECLARE @schemaname … Read more Sql Variable In Xml Node

In Oracle's PL-SQL, you can declare a variable and define its type based on a table column: dec… Read more Declaring Variable Type Based On A Column Type