Advertisement
Ruslan_Rayanov

dbTable falcon_search

Jul 20th, 2022 (edited)
1,525
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.39 KB | None | 0 0
  1. В falcon_search
  2.  -- db tables
  3.        insert into #result
  4.        select top 10 0,
  5.               '<a href="/dbtable/'+Table_name+'" class="text-decoration-none"><i class="fa fa-database"></i> '+Table_name+'</a>',
  6.               '',                        
  7.               '',
  8.               getdate()
  9.        from INFORMATION_SCHEMA.TABLES
  10.        WHERE TABLE_NAME LIKE '%'+@q+'%'
  11.        order by Table_name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement