Database

Flaviu_2006 wrote:

can i make ODBC SQL Server

SELECT 
    Table1_Id
FROM
    Table1
WHERE
    Table1_FK NOT IN (SELECT 
                          Table2_Id
                      FROM
                          Table2)

Dim conn As New SqlClient.SqlConnection(strMyConnectionString)
Dim cmd As New SqlClient.SqlCommand()
cmd.CommandText = "UPDATE myTable SET col1='my value'"
cmd.ExecuteNonQuery()

Dim conn As New SqlClient.SqlConnection(strMyConnectionString)
Dim cmd As New SqlClient.SqlCommand()
cmd.CommandText = "SELECT * FROM myTable"
Dim da As New SqlClient.SqlDataAdapter(cmd)
Dim cb As New SqlClient.SqlCommandBuilder(da)
da.Update(myDataTable)

CREATE PROCEDURE  returncolname @tablename varchar(255),  @colname varchar(255)<br />
<br />
AS<br />
declare @tblname  as varchar(255)<br />
set @tblname = @tablename <br />
declare @clnName  as varchar(255)<br />
set @clnName = @colname<br />
 <br />
 SELECT @clnName AS [Columns] <br />
FROM information_schema.columns <br />
WHERE (TABLE_NAME = @tablename) and (Column_name =@colname )<br />
<br />
GO

CREATE PROCEDURE DynamicSqlTest
(
    @columnName NVARCHAR(100)
)
AS
 
DECLARE @sql NVARCHAR(1000)
 
SET  @sql = 
N'SELECT COLUMN_NAME AS Columns 
  FROM information_schema.columns 
  WHERE (TABLE_NAME = ''MyTable'') and 
  (COLUMN_NAME = ''?COLUMN_NAME?'')'
 
SET @sql = REPLACE(@sql,'?COLUMN_NAME?',@columnName)
 
EXEC(@sql)