How Can Use column name as variable in SQL Server?

Use Variable as SQL column Name in query

Table of Contents

DECLARE @ColumnName VARCHAR(100)
set @ColumnName= ‘Date Received ‘+ GETDATE()
SELECT Datecolumn as @ColumnName.
SET @sqlquery = N’SELECT DISTINCT (‘ + QUOTENAME(@COLUMNNAME) + ‘) FROM TABLE1’

Can you search for a column name in SQL?

A feature that can be used to search for column names in SQL Server is Object search.

How do I find a particular column name in SQL Server?

1 Answer

SELECT COL_NAME AS ‘Column_Name’, TAB_NAME AS ‘Table_Name’
FROM INFORMATION_SCHEMA.COLUMNS.
WHERE COL_NAME LIKE ‘%MyName%’
ORDER BY Table_Name, Column_Name;

How do you assign a column to a variable in SQL?

Try these statements:

set @sql = N’select top(1) @location = location FROM dbo. productcategory order by ProductCategoryID desc’
exec sys. sp_executesql @sql, @params = N’@location nvarchar(50) OUTPUT’, @location = @location OUTPUT.

What is @table in SQL Server?

Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.

How do I select a specific column in SQL?

To select columns, choose one of the following options: Type SELECT , followed by the names of the columns in the order that you want them to appear on the report. Use commas to separate the column names.

Which keyword is used to assign datatype of an existing table column or variable to another variable?

The TABLE keyword specifies that this variable is a table variable. After the TABLE keyword, we have to define column names and datatypes of the table variable in SQL Server.

How do I see the fields in a table in SQL?

Using the Information Schema

SELECT TABLE_NAME FROM INFORMATION_SCHEMA. TABLES.
SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA. COLUMNS.
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA. COLUMNS WHERE TABLE_NAME = ‘Album’
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.

What are columns called in SQL?

Fields
Records and Fields in SQL Tables contain rows and columns, where the rows are known as records and the columns are known as fields.

How do I select a column in a table?

You can also click anywhere in the table column, and then press CTRL+SPACEBAR, or you can click the first cell in the table column, and then press CTRL+SHIFT+DOWN ARROW. Note: Pressing CTRL+SPACEBAR once selects the table column data; pressing CTRL+SPACEBAR twice selects the entire table column.