|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 How to compare time of day only, for smallDatePart? Posted by wolfv at 10/17/2004 8:57:01 PM Transact-SQL-Reference says:
SQL Server stores smalldatetime values as two 2-byte integers. The first 2
bytes store the number of days after January 1, 1900. The other 2 bytes store
the number of minutes since midnight.
Is there a way to compare just the time of day for smallDatePart?
DEC...more >>
Passing table-type variables to SP? Posted by Agoston Bejo at 10/17/2004 8:00:02 PM Sorry about posting twice, but I had some trouble with setting the date on
this machine... :)
I would like to write a stored procedure that takes a table (i.e. table
variable) as its parameter.
E.g.:
DECLARE @mytable = TABLE(ID INT, NAME VARCHAR(50))
SP_MYPROC @mytable
What should SP_MY...more >>
Log Directory .ldf has 2 MB of space Left HELP Posted by Lontae Jones at 10/17/2004 7:15:04 PM My Log directory is 60 GB and it is almost full. Wht can I do to make more
space without lossing data?...more >>
Syntax for Data Loading? Posted by Steve at 10/17/2004 6:33:05 PM Hi,
Can someone help me with the following
I have to automate the process of loading the files from source to target.
I have to use partitioned tables which should be created automatically to
load the data. These tables should have different name each week(for e.g
customers40, customers4...more >>
Cannot add rows to sysdepends for the current stored procedure Posted by Andrew Smith at 10/17/2004 4:58:55 PM Hi,
I've scripted with "Generate SQL Script" all my stored procedures. When I'm
trying to create these with the script I get the error message:
"Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'dbo.dt_adduserobject_vcs'. The stored
pro...more >>
Empty Results When One Or More Fields Are Null Posted by Darren at 10/17/2004 1:13:34 PM I have created a stored procedure that compiles the contents of a bespkoe
letter to a customer. The resulting string is then inserted into a
"correspondence history" table.
The stored procedure looks to a view that initiallly compiles the customer
address in a calculated field:
Customer...more >>
Source Control in SQL Server 2005 Posted by Brian at 10/17/2004 12:41:11 PM Will SQL Server 2005 include integrated support for putting stored procedures
and triggers in source control?
Thanks...more >>
bulk insert fails from vb but works in query analyzer Posted by alison.clark NO[at]SPAM barrheadtravel.com at 10/17/2004 12:34:54 PM Hi,
I am trying to use DTS Package Object library to bulk insert a flat
file on my local machine into sql server. The bulk insert works fine
from query analyzer but in vb I get error: 80040e14 - Method Execute
failed.
Here is my bulk insert function:
Private Sub GenericTaskPackage()
Dim...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
random 7 digit number Posted by niv at 10/17/2004 12:29:12 PM rand()
Hi, I thought SELECT rand() * 9999999 would always
generate an 7 digit number but it does not..
How do I ensure that the generated random number is always
7 digits long?
Thanks...more >>
Swapping rows values Posted by Chris at 10/17/2004 11:26:52 AM Lets say I have a table which has two fields:-
SeatSerialNo - int - primary key
RowNo - smallint (constraint that allows values between 0 and 1000 only) -
doesn't allow nulls
There is a combined unique index on SeatSerialNo and RowNo.
I want to write a store procedure that will allow a R...more >>
Free SQL Server Tools Posted by Rob Vallee at 10/17/2004 7:30:29 AM www.hybridx.com
...more >>
Get the description of INFORMATION_SCHEMA.COLUMNS Posted by Agoston Bejo at 10/17/2004 1:04:58 AM I understand that sp_help and sp_columns can give a description of a table
for me.
However, sp_help sees only the tables in the current schema, and
sp_columns 'COLUMNS', 'INFORMATION_SCHEMA'
returns an empty result, too.
How can I query the descriptions of tables in other than the current schem...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |