Viewing 15 posts - 58,711 through 58,725 (of 59,048 total)
The use of xp_CmdShell is considered to be a security risk by most DBA's and, I believe, the default is you must have"SA" (not just "dbo" rights to use it. You...
June 25, 2005 at 8:31 am
rschaeferhig,
You were quite right... you didn't change much. In fact, when I built a test Directory and Employees table and inserted the records you showed in a previous...
June 7, 2005 at 10:02 pm
Obviously, the code I posted had to be changed to accomodate your particular requirements. You are correct... something went drastically wrong. If you could post the schema of your personnel...
June 6, 2005 at 9:21 pm
Sure... with examples... I used temp tables for the example so I don't clutter up my hard drive... you don't have to (in fact, I recommend that you don't)...
June 3, 2005 at 6:28 pm
Bull2000,
If you use the concatenate method using the TAB character (CHAR(9) in code) instead of a comma as a delimiter, the output might just cut&paste into Excel with no other...
May 26, 2005 at 7:02 am
Cory...
This works the way you want... leading zeros and mm/dd/yyyy format intact...
DECLARE @Date VARCHAR(30)
SET @Date = '2/3/2005'
SELECT CONVERT(VARCHAR(10),CONVERT(DATETIME,@Date),101)
----------
02/03/2005
(1 row(s) affected)
May 19, 2005 at 9:13 pm
The log file probably grew for a pretty good reason. If you shrink it and it decides to grow again, especially if the growth size is small or is a...
May 17, 2005 at 12:46 am
Try this, instead...
"select boy + REPLACE(STR(age,7,4),' ','') + ' is years old'
May 15, 2005 at 10:40 am
If it truly is a "DateTime" column, it just doesn't matter what format you store it in so long as it is one recognized by SQL. It will have...
May 15, 2005 at 10:18 am
If it truly is a "DateTime" column, it just doesn't matter what format you store it in so long as it is one recognized by SQL. It will have the...
May 15, 2005 at 10:16 am
Not trying to be difficult here... hex doesn't normally work quite the way you described so could you post an example of the hex number and what the expected outcome...
May 15, 2005 at 10:09 am
Can't be done. The purpose of having a username and password is to keep people out unless they know the username and password. Sorry...
May 15, 2005 at 10:01 am
scking,
I'm curious... what is your objection to using ISNULL or it's big brother, COALESCE? Yes, CASE works but it's probably not a fast as ISNULL... your last CASE example could...
May 13, 2005 at 9:35 pm
Miller Time,
Don't define the new column as a TimeStamp datatype... the TimeStamp data type in MS-SQL Server is actually a binary number used for row versioning and has nothing to...
May 12, 2005 at 7:18 pm
Viewing 15 posts - 58,711 through 58,725 (of 59,048 total)