Search results for query: *

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

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.

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.

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.

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

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

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.

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

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

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...

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

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

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

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.