Database

holdorf wrote:

I have a SQL query that is returning

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Create Porocedure GetName
(
  @column nvarchar(50)
  @columnData nvarchar(50)
)
As
Begin 
   Declare @MyQuery nvarchar(300)

  set @column=   IF (@column IS NOT null AND @column ='TableA.SomeColumn') 
    Begin 
    Set @MyQuery = N'Select'+ TableA.[@column] + 'from dbo.TableA
        (where TableA.Column1 LIKE' + @columnData + '+ ''%'' OR' + @columnData + 'IS null)' 
     END         
End
EXEC sp_executesql;

CREATE PROC dbo.GetName
(
    @column        sysname,
    @columnData    nvarchar(50)
)
As
BEGIN
DECLARE @MyQuery nvarchar(max), @RealColumnName nvarchar(130);
    
    SET NOCOUNT ON;
    
    -- Verify that the column name exists in the table:
    SELECT
        @RealColumnName = QuoteName(name)
    FROM
        sys.columns
    WHERE
        object_id = OBJECT_ID('dbo.TableA')
    And
        name = @column
    ;
    
    If @RealColumnName Is Null
    BEGIN
        RAISERROR('Invalid column name: "%s"', 16, 1, @column);
        Return;
    END;
    
    -- Use sp_executesql to pass the parameter to the dynamic query as a parameter:
    -- https://msdn.microsoft.com/en-gb/library/ms188001.aspx
    SET @MyQuery = N'SELECT ' + @RealColumnName + N' FROM dbo.TableA WHERE (' + @RealColumnName + N' Like @columnData + N''%'' Or @columnData Is Null)';
    EXEC sp_executesql @MyQuery, N'@columnData nvarchar(50)', @columnData = @columnData;
END

Using con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\surendera\Documents\student.accdb")
    Using cmd As New OleDbCommand("INSERT into user_acnt (user_name, pas_word) values (?, ?)", con)
        
        ' OleDb doesn't use named parameters, so the names don't matter here:
        cmd.Parameters.AddWithValue("p0", login.UserNameTextBox.Text)
        cmd.Parameters.AddWithValue("p1", login.PasswordTextBox.Text)
        
        con.Open()
        cmd.ExecuteNonQuery()
    End Using
End Using

Balaji Naidu wrote:

oralce table

Balaji Naidu wrote:

SQL Server table

DECLARE @PostalCode VarChar(12), @CustomerID Int, @StreetAddress1 VarChar(80);
SET @PostalCode = '92648';
SET @CustomerID = 5;
SET @StreetAddress1 = '18751 Park Haven Lane';
SELECT * 
FROM CUSTOMER_SHIPPING_ADDRESS
WHERE PostalCode = @PostalCode 
AND CustomerID = @CustomerID
AND LEFT(StreetAddress1, 5) = LEFT(@StreetAddress1, 5)