To ASSIGN variables using a SQL select the best practice is as shown below->DECLARE co_id INT ; ->DECLARE sname VARCHAR(10) ; ->SELECT course_id INTO co_id FROM course_details ; ->SELECT student_name INTO sname FROM course_details; IF you have to assign more than one variable in a single line you can use this same SELECT INTO

Apr 12, 2018 · How can I declare a variable in T-SQL and use it in multiple statements? For example: DECLARE @STRDT DATE SET @STRDT '2017-01-01' SELECT TOP(10) * FROM TABLE1 WHERE START_DATE = @STRDT; SELEC...

Nov 22, 2016 · Note that they neither need nor can be declared—just use them directly. Therefore, if you are defining a stored program and actually do want a "local variable", you will need to drop the @ character and ensure that your DECLARE statement is at the start of your program block. Otherwise, to use a "user variable", drop the DECLARE statement.

Jul 25, 2014 · Use DECLARE inside a VIEW in SQL Server. 1. Using declare variable in SQL Server. 0. incorrect syntax near ...

Sep 24, 2010 · DECLARE @DatabaseName NVARCHAR(MAX) SET @DatabaseName = 'MainDb' EXECUTE('USE ' + @DatabaseName + ';SELECT name FROM sys.tables') -- SQL injection risk! Of course, you need to be very careful with SQL injection, for which I point you to the link in Barry's answer.

With using this approach you can ensure that the data values being passed into the query are the correct datatypes and avoind use of more quotes. DECLARE @sqlCommand nvarchar(1000) DECLARE @columnList varchar(75) DECLARE @city varchar(75) SET @columnList = 'CustomerID, ContactName, City' SET @city = 'London' SET @sqlCommand = 'SELECT ...

Mar 26, 2014 · As no one mentioned it before, starting from Sql Server 2016 you can also use json arrays and OPENJSON (Transact-SQL): declare @filter nvarchar(max) = '[1,2]' select * from dbo.Test as t where exists (select * from openjson(@filter) as tt where tt.[value] = t.id) You can test it in sql fiddle demo

Sep 15, 2011 · DECLARE @Values varchar(1000); SET @Values = 'A, B, C'; SELECT blah FROM dbo.foo INNER JOIN dbo.SplitStrings(@Values, ',') AS s ON s.Item = foo.myField; On SQL Server 2016 or above (or Azure SQL Database), it is much simpler and more efficient, however you do have to manually apply LTRIM() to take away any leading spaces:

Jun 21, 2017 · You need to define columns of table to return, then you can use declare, something like below. CREATE FUNCTION [dbo].[MyFussnction] ( @path [nvarchar](10) ) RETURNS @Mytable TABLE ( ID int PRIMARY KEY NOT NULL -- define other columns ) AS BEGIN DECLARE @xx varchar(50); SET @xx = 'Windows%'; Insert into @Mytable SELECT Id FROM MyTable WHERE DataPath LIKE @path AND XX LIKE @xx; RETURN; END

There are a several ways of declaring variables in SQL*Plus scripts. The first is to use VAR, to declare a bind variable. The mechanism for assigning values to a VAR is with an EXEC call: SQL> var name varchar2(20) SQL> exec :name := …