When I right click a table in SSMS and select Script Table As INSERT To, the
resulting VALUES section is not what I would expect. I was hoping it would
generate a list of parameters for each column and then list these as the
VALUES.

I would like to use the output of the stored procedure sys.sp_tables in the
AdventureWorks database to iterate thru the database tables (ultimately I
want to export the table contents to external text files, however, for now I
am merely wishing to determine how to use the output ...

I need to change a bulk set of emails eg.
where Email contains '@yahoo.com'
update Email to '@microsot.com'
Ive been playing with select but I cant even get that right so at a loss to

I wrote a procedure to check, if specified table exists in db.
create procedure spCheckTableInDatabase(
    @TableName nvarchar(50)
)

I have a problem. I am doing a project for my study in which in am
creating booking system for repair. and i have tables customer and
repair. for both tables i need to create a customize key for customer
table i need to create a primary key which has C at the biggning then

Hi All: I have a reporting page on a website that presents a real-time view
of survey responses. The page has a number of queries that count and group
rows in a large table, like:
select listname, count(listname) from mytable group by listname

Hi All: I have a table with a field composed of "fname + lname"...and I'm
able to see that this field has dupes using:
SELECT     myField, COUNT(myField) AS Expr1
FROM         myTable

I have a database at work.  I scripted it to 3 files - one with users,
one with tables, and one with stored procedures.  Then I took the
scripts home and tried to run them.  The user script had statements
like:

This question pertains to the Query Plan for views.  
Assume that I have a table of 10,000 widgets (widgets_table) with a primary
key on the identity column widget_id.  Now, assume I have a view
(widgets_view) defined as:

I have been trying to upgrade my SQL MSDE2000 to SQL 2008 Express.
I run thru the setup and I get this error see the summary log below.
Overall summary:
 Final result:                  Failed: see details below

Has anyone been sent a copy of SQL Server 2008 for having submitted their
appreciation voucher from the "Heroes happen here" launch?
Patrick
=-=-=-=-=-=-=-=-=-=-=-=

Just installed SQL Server 2005 sqlexpr32.exe on my Windows 2003 R2 Standard
DC server SP2
When I opened the SQL Server Configuration Manager
I selected SQL Server 2005 Services  and There are no items to show in this

How do I export the results of a simple query to a text file (such as a csv
file)?  Can I specify that field names (headers) are to be/not to be
outputted too?  I realise I can save the output to csv from the management
console, but I would like to do this programmatically.  Many ...

Dear
Can we use sql database without attatching sql server.
Like temporary database
Bimal Shah

I have installed SQL Server 2008 and then have installed the AdventureWorks
databases for 2008.  They have been installed with no reported problems.  I
can access and view the AdventureWorks databases and the information
contained therein.  I can run an EXEC sp_help statement ...