Viewing 15 posts - 1 through 15 (of 41 total)
Considering a few factors:
1. I am not independently wealthy
2. I do not work for a corporation because I enjoy it
3. My...
April 16, 2010 at 6:05 am
The requirements for this questions don't seem to support the given answer. Upon reading the question, my initial reaction was that the results would be 0,1.
Upon opening...
January 29, 2010 at 5:17 am
I am very confused as to why the comments stated:
"This is one of the reasons to rely on checking 'equality' rather than 'inequality'". The result was generated as expected.
September 16, 2009 at 6:08 am
Another good option to be aware of is that you can assign values directly from your SELECT statement...
SELECT @valueA = Field1 FROM someTable WHERE...
This offers the ability to assign multiple...
August 17, 2009 at 5:53 am
Long live the geek. Could you imagine Dilbert in a management role?:-)
May 28, 2009 at 1:10 pm
If the value is for display purposes, and not required to be a decimal data type, you could format it as a string like below:
DECLARE @Input DECIMAL(16,6)
DECLARE @precision...
May 8, 2009 at 8:48 am
It sounds as though your proc is sending the email since you receive the message when running the proc directly from query analyzer.
If you are receiving the email with empty...
May 6, 2009 at 1:39 pm
amdavis (4/20/2009)
I'm currently using psloglist to export some security logs to csv format then importing them into a sql 2005 database.
Use Apr09
bulk INSERT Ramses
...
April 20, 2009 at 8:39 am
I guess I should have read all pages in the thread before the last two posts to reduce post redundancy:-)
April 16, 2009 at 9:56 am
GilaMonster (4/13/2009)
Truncate deletes all the data in the table. Delete can have a where clause allowing conditional deletes.
Truncate does not fire triggers, delete...
April 16, 2009 at 9:54 am
All I am trying to do delete data from the table where date >=30
Correct me if I'm wrong, but as far as I'm aware, you can't perform a conditional TRUNCATE,...
April 16, 2009 at 9:52 am
How about using this option, to preserve your datetime format:
SELECT TALLY_NAME FROM TALLYS WHERE LAST_UPDATED_DATE < CONVERT(DATETIME,'15/04/2009',103)
--103 STANDARD
April 16, 2009 at 6:16 am
Viewing 15 posts - 1 through 15 (of 41 total)