By using "select into " statment you will only get the columns and the data. It will not create Primary keys , indexes etc.

Yup... check for the tables existence before doing the inserts using IF EXISTS.

BTW what do you mean by table is dropped in future? Its better to check before dropping a...

Hi

Check whether the table exists and then insert.

Hi

Hope i have understood you r post clearly..

I think this is an issue where design could be row wise or column wise and you can have arguments for and against...

Hi

The only error i found was in your parameter declaration.

"@Name varchar(255)," . No need of a comma if its the only parameter there.

Check your server,db...

nice article jeff.

Here's another one with more uses of tally table.

http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/

Yup... convert the search string into a table with a function and then do the search. Much easier to work with.

Hi

Glad to help. 🙂

hi

what about using fn_listextendedproperty check out BOL for more details.

Hi

If you have friends working on databases ask them if they can provide some general details regarding the projects they are working on. They could provide general details without divulging...

Hi

You can insert the result set of a procedures into a table.

Insert into table1 (col1,col2....)

Exec StoreProc1 @param1,@param2... .

Anoop

You have asked a very general question .

You will the info you need on BOL, MS site and also in this site. Why dont you read up and...

Toni

Agreed that @@Rowcount will give you the desired result.

However you have to "select @@Rowcount" after the query .

This will give 2 result sets , first the result set...

Hi

Keep in mind that select * into does not create indexes, Primary keys,Foreign keys and default values for column.

It would be much better if you apply the source table...

Does column addition/deletion/modification happen regularly?

The script needs to be changed to accomodate the column changes . how is it done? How difficult is it to make any changes in the...