Viewing 15 posts - 38,056 through 38,070 (of 39,490 total)
February 13, 2002 at 11:24 am
As Andy said, it distinguishes you. Not a guarentee, but every bit helps. Sometimes that cert gets you past the HR people.
Steve Jones
February 13, 2002 at 11:23 am
You can run BCP without the -n or -c options and it will ask you questions about each column. At the end, it will offer to save a format file....
February 13, 2002 at 11:07 am
Easiest way I have seen is a cursor. But pls answer Andy's question. We may have a better solution.
Steve Jones
February 13, 2002 at 10:58 am
February 12, 2002 at 3:08 pm
Can you provide some more information?
If you are receiving the "call to sqlmaint.exe" failed, I get this on some things and haven't found a solution, other than to not...
February 12, 2002 at 2:17 pm
Nice article with good examples. Personally, though, I have a rule of thumb: NEVER use dynamic SQL. That being said, I have used it in places, but only when I...
February 12, 2002 at 12:31 pm
Nice article. I too tried this last year, but was a little ticked that I had to use a cursor to get this info. This should be queryable for all...
February 12, 2002 at 12:26 pm
February 12, 2002 at 12:00 pm
Rule of thumb:
February 12, 2002 at 10:55 am
February 12, 2002 at 10:47 am
Can you post more information. This doesn't really make sense. Version of SQL, what tasks? code for the tasks? etc.
Steve Jones
February 12, 2002 at 10:42 am
Not sure what you mean. What is a connectoid? Where is the data? In SQL Server?
Also, what version of SQL are you using?
Steve Jones
February 12, 2002 at 10:33 am
Haven't really developed any as of yet. Be interested to see what you come up with.
Steve Jones
February 12, 2002 at 10:31 am
You can also query information_schema.tables.
Ref:http://www.sqlservercentral.com/columnists/rsharma/informationschema.asp
Steve Jones
February 12, 2002 at 10:11 am
Viewing 15 posts - 38,056 through 38,070 (of 39,490 total)