BCP is what you would use to get a table or query's results into a file; you'll really need to read Books On Line for the syntax, as I rarely...

you'll want to use the optional ALIAS for each columnname.

descriptions with spaces require brackets or double quotes.

based on your example, here's what it might look like:

SELECT

employeeid AS...

here's a code example of what John and roy are talking about with the calculated column:

Create Table Example(P int identity(1000,1) , --starts at 1000

PCODE AS 'P' + CONVERT(varchar,(P)) PERSISTED, ...

i THINK i understood what you are after;

it's still looking in the same view i mentioned.

try this, and comment/uncomment the WHERE/AND statements to see the differences:

select name,* from syslogins

where...

yeah it seems misleading.

I would say it is ALWAYS Characters. it's just coincidence that when you have a varchar, the bytes=# chars. i think that was what they were trying...

the GO command after every related group of commands would do what you want, i think.

you'd want to make sure there was no explicit transaction open i think, as well.

sp_help_revlogin serves a specific purpose: scripting out the commands to create the logins, complete with the password. it has output...

To build on what CozyRoc said, the issue is your choice of application in opening a CSV file;

if you use a raw text editor, like EditPlus,Notepad++,UltraEdit32, etc, they all open...

Gift Peddie (12/13/2009)

---

I installed VS2008, SQL Server 2005 and SQL Server 2008 now Windows 7 complain about VS2005 not compatible but I ignored that. If try all programs in...

on your laptop, this probably seems to make sense....everything "else" slows down, and task manager says sqlserver.exe is using almost all your memory.

As Bru and Lynn both pointed out, it's...

there are two kinds of hotfixes: cumulative hotfixes and specific hotfixes;

for example this link:

http://support.microsoft.com/kb/918222 clearly descibes that this is the latest cumulative hotfix as "build 2153" for SQL 2005...so yes,...

converting an rtf string to raw text.

AFAIK, you can't uses a System.Windows.Forms.RichTextBox in a CLR, but you can call a web service that uses the System.Windows.Forms.RichTextBox;

two steps to...

Grant, would this be a correct assumption?

if the index for date_entered was in place, would we expect an INDEX SEEK and an estimated 10 rows(because of the TOP 10) instead...

ok I'm no expert, but I'm not a country bumpkin either.

it looks to me like this is the costliest item: a table SCAN of almost 500,000 rows, which then requires...

altering a procedure is NOT the same as EXECUTE ing the procedure.

run something like this statement and capture the query plan :

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

EXECUTE GetOrders @params.....

then run the...