Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE dbo.GetTableColumn(
- @ColName VARCHAR(MAX),
- @TblName VARCHAR(MAX),
- @Result BIT OUT
- ) AS
- BEGIN
- IF (EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TblName AND COLUMN_NAME = @ColName))
- BEGIN
- DECLARE @SQL VARCHAR(MAX)
- SET @SQL = 'SELECT ' + @ColName + ' FROM ' + @TblName
- EXEC (@SQL)
- SET @Result = 1
- END
- ELSE
- SET @RESULT = 0
- RETURN @Result
- END
- Public Function GetTableColumn(ByVal col As String, ByVal table As String) As AutoCompleteStringCollection
- GetTableColumn = New AutoCompleteStringCollection
- Using dbContext As New Customer_LINQDataContext
- Dim result As Boolean
- Dim query = dbContext.GetTableColumn(col, table, result)
- MessageBox.Show(query.ToString())
- End Using
- End Function
Add Comment
Please, Sign In to add comment