Viewing 7 posts - 1 through 7 (of 7 total)
re: "!! DIR C:\Temp"
This doesn't work for me
"Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '!'."
Is it running the commands on the SQL server, like xp_CmdShell?
Or locally on...
January 10, 2008 at 11:17 am
Not answering the question, but the concept is too cool!
May be my inexperience, but I've not seen a numbering system like this before.
Is there an official name for this. Twelvish?
...
June 20, 2003 at 9:30 pm
Too lazy to remember the rules about nulls and ANSI NULLS and empty strings, so I avoid tripping over them.
Typically, I use comparisons like this:
isnull(@variable,'') = ''
isnull(@variable,0) = 0
coalesce(@variable,@anothervariable,'') =...
June 20, 2003 at 9:11 pm
Forgot to mention - no indexes on imported columns
Identity is primary key clustered
April 30, 2003 at 9:24 pm
Source file has 4 columns, destination table has 5 (4 plus identity primary key)
Destination is dropped and created on each attempt, so no weird carryover or gaps in the identity...
April 30, 2003 at 9:18 pm
Is it correct you wish to pass a single string to the procedure and then use the individual numeric members?
The proc below breaks a comma-delimited string into integers. This is...
August 19, 2002 at 6:12 am
Not running Active Directory
New info: I changed the connection string and set IIS to Basic Authentication
It works, but the extra login screen and sending clear text passwords over the network...
July 12, 2002 at 8:36 am
Viewing 7 posts - 1 through 7 (of 7 total)