Home / Questions / 61344
Accepted
Alejandro Ricotti
Asked: 2020-04-08 06:36:48 +0800 CST 2020-04-08 06:36:48 +0800 CST

Assign a Select to a Table in SQL Function

  • 772

In a function in SQL Server is there a way to create a table and assign the value of a query to it, something like

CREATE TABLE AuxAlumnos
(
   Id       int,
   Nombre   varchar (10),
   Apellido varchar(10)
);

And to that table assign the value of aSELECT * FROM Alumnos

sql

3 Answers

  1. You can do the following:

    SELECT CAMPO1, CAMPO2, CAMPO3 INTO NUEVATABLA FROM VIEJATABLA
    • 2
  2. Best Answer

    If it can or can be done with temporary tables or concrete tables, you will have something similar to this:

    Concrete table:

    CREATE PROCEDURE MI_PROCEDIMIENTO
AS

    CREATE TABLE #AuxAlumnos
    (
       Id       int,
       Nombre   varchar (10),
       Apellido varchar(10)
    );

    INSERT  INTO #AuxAlumnos (ID,NOMBRE,APELLIDO) 
    SELECT  ID,NOMBRE,APELLIDO
    FROM    Alumnos

    Temporary Table:

    CREATE PROCEDURE MI_PROCEDIMIENTO
AS

    DECLARE @AuxAlumnos TABLE
    (
          Id       int,
          Nombre   varchar (10),
          Apellido varchar(10)
    )

    INSERT  INTO @AuxAlumnos (ID,NOMBRE,APELLIDO)
    SELECT  ID,NOMBRE,APELLIDO
    FROM    Alumnos

    then you just have to do the select to the table you just created.

    I hope it is helpful

    Cheers

    • 2

  3. What do you want to do exactly? the question is not clear.

    Maybe you want to do something like:

    SELECT *FROM fuMyFunction('x')

    If so, yes it can be done.

    • 0