Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. alex12

    Finding value

    Thanks for the explanation, but why do we need three times ''' in 'select''' : 'SELECT ''' + @TableName + '.' + @ColumnName Thanks again.
  2. alex12

    Finding value

    Thank you a lot, DBomrrsm. Now it seems to be working, just taking really long time... Please, explain to me what the following means: 'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630) What is the bunch of '''' means? Thanks.
  3. alex12

    Finding value

    It is very frustrating, but it doesn't work in my db. The procedure works perfectly in pubs, but not in my db. What should I do?????? Thanks.
  4. alex12

    Finding value

    Obviously, I am missing a lot here. How do I "Create the function in your database then run it against your database."??? How do I do it or is it some other way to make this procedere work for another db except pubs. Thanks.
  5. alex12

    Finding value

    Thanks guys. But this procedure works only with pubs database. How do I search in my database? Thanks.
  6. alex12

    Finding value

    How would I find what columns in database have data 'Optic'? Thanks.
  7. alex12

    Finding value

    Does anybody know how would I go through all the tables and columns in order to find columns that have value ‘opt’ in them? Thanks.
  8. alex12

    Must have or..?

    With one-to-one relationship the tables on both sides must have the same number of records or not? Thanks.
  9. alex12

    one-to-one relationship

    With one-to-one relationship the tables on both sides must have the same number of records or not? Thanks.
  10. alex12

    Help!

    Hello, guys. I have been trying to execute the following and just keep getting the same error: “Syntax error converting the nvarchar value ‘one_a’ to a column of data int. declare @a int declare @b int declare abc cursor for select TABLE_Name, data_type from information_schema.columns where...
  11. alex12

    relationship

    It should mean something like it: one record should depend on time in the second table. Does it ring a bell? Thanks.
  12. alex12

    relationship

    What is “time dependent one-to-one relationship”? With such relationship can table have different number of records? Thanks.
  13. alex12

    one-to-one relationship

    What is “time dependent one-to-one relationship”? With such relationship can table have different number of records? Thanks.
  14. alex12

    primary key

    To create a relationship between tables without primary keys set up, what would I do? And how what I use unique keys to create relationship? Thanks.

Part and Inventory Search

Back
Top