Guest User

Untitled

a guest
Jul 19th, 2018
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. CREATE PROCEDURE dbo.GetTableColumn(
  2. @ColName VARCHAR(MAX),
  3. @TblName VARCHAR(MAX),
  4. @Result BIT OUT
  5. ) AS
  6. BEGIN
  7. IF (EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TblName AND COLUMN_NAME = @ColName))
  8. BEGIN
  9. DECLARE @SQL VARCHAR(MAX)
  10. SET @SQL = 'SELECT ' + @ColName + ' FROM ' + @TblName
  11. EXEC (@SQL)
  12. SET @Result = 1
  13. END
  14. ELSE
  15. SET @RESULT = 0
  16. RETURN @Result
  17. END
  18.  
  19. Public Function GetTableColumn(ByVal col As String, ByVal table As String) As AutoCompleteStringCollection
  20. GetTableColumn = New AutoCompleteStringCollection
  21. Using dbContext As New Customer_LINQDataContext
  22. Dim result As Boolean
  23. Dim query = dbContext.GetTableColumn(col, table, result)
  24. MessageBox.Show(query.ToString())
  25. End Using
  26. End Function
Add Comment
Please, Sign In to add comment