mySQL is definitely more primitive, but all the basic functionality is there.  Tables, views, procedures....

The native interface is much more primitive that QA and EM; really just a command line...

You cannot do this in SQL...you need to have middleware that converts the PDF into a binary object, which can then be stored in SQL.  Usually you'll use a filestream...

This should definitely be handled in the GUI, but something like this may work (although it doesn't handle spaces)

create function dbo.string_wrap(@String varchar(8000), @WrapInterval int)

returns varchar(8000)

as

begin

declare @NewString varchar(8000)

While @String <> ''

 BEGIN

  select...

"The comment about registering the server as "Local" to ensure portability tweaks my interest. I'm wondering how you register a named instance as "Local"..."

By default a named instance can be referred...

Yeah, this is some basic functionality that should be in SQL2K, but isn't.

you can get the creationdate, though, although this isn't going to help with "alter proc" commands.

-------------------------------------------------------------------------------

select  Name, crdate

from...

There is an undocumented extended proc that does this:

exec master..xp_dirtree 'c:\', 2

The 2nd variable sets the "depth" the tree is navigated....

cl

PS: Some form of "exec master..xp_cmdshell 'tree c:\Snapshots'" may be...

"However, as long as you don't go beyond 4,000 characters total (including WITH ENCRYPTION),"

You can go to 8000 characters if you use varchar instead of nvarchar.  If you concatenate system...

Or a homegrown version....

ALTER           Proc cmd_GetDIR @Dir varchar(255)

as

set nocount on

declare @cmd varchar(275),

  @FileName varchar(255)

set @cmd = 'dir "' + @dir + '" /A-D /B'

exec master.dbo.xp_cmdshell @cmd

set nocount off

GO

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS...

"3. Add some logging (or MessageBox calls) of your own"

Actually, mxgbox calls could cause the problem described.  a msgbox call that has an "OK" button is going to stall your...

You can have ntext input variables to procedures, and that should be all you need.  Note that you can't declare ntext variables at private (internal to the procedure), they must...

Maybe the numbers guy did some statistics on a bunch of sites, then determined what features where shared by most of the news sites.  That could lead to a rule...

You can also create a view one the table that excludes the indentity column, then insert from the view back into the table (using select *).

Of course, as PW pointed...

Of course the media wants him gone!  News published by consumers for consumers directly threatens the centralized (hierarchal) model the media depends on to make a profit.  Now is not...

Good article, but I'd have to disagree with the following:

"Non-Clustered indexes are better for singleton and individual row lookups. "

Non-Clustered indexes really aren't any "better", they costs virtually the same (an...

ignore the ATOM rules at your own risk...they are not arbitrary and were created for good reason.

-----------------------------------------------------------------------------------------

if object_ID('tempdb..#Person') is not null drop table #Person

create table #Person

 (

  PersonID int identity not...