|
|
|
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 Size of column of datatype Image Posted by Jonas Mandahl Pedersen at 7/22/2006 8:36:36 PM Dear NG
I have a table in my database where I store key / value pairs for a dynamic
form designer.
It has the definition:
ID INT,
DATATYPE TINYINT,
VALUE Varchar(250)
( I asume each row takes 4+1+length(value) bytes?
All conversion is done in the client application and the datatype is...more >>
how to set variable using CASE? Posted by Phill at 7/22/2006 4:31:01 PM How do I set a variable using CASE. This is my mess:
IF DATENAME(dw,CAST(@strFromDate AS DATE)) = 'Monday' SET @i=6
--WHEN 'Tuesday' THEN
-- 5
--WHEN 'Wednesday' THEN
-- 4
--WHEN 'Thursday' THEN
-- 3
--WHEN 'Friday' THEN
-- 2
--WHEN 'Saturday' THEN
-- 1
--...more >>
Get list of connected users on database? Posted by Retf at 7/22/2006 2:39:49 PM Hi All,
How I get list of users that stay connected on my data base?
Thanks
...more >>
Temporary Tables Posted by Chamark at 7/22/2006 1:26:51 PM Using MS-SQL2000 User Level - Beginner
My application needs to take variables from a Web form pass them to a table
for my multiple Views to use. Currently I am using an already created table
and doing a delete each time the application is run. I know this method can
cause problems in a multi-u...more >>
SQLCMD vs BCP Posted by Lawrence at 7/22/2006 8:35:01 AM Hello,
I have the following BCP
bcp.exe "SELECT * FROM LAW.dbo.A" queryout "C:\Test\Test.txt" -c -q -C1252
-T -S "SEA2-LawrenceB1" -t ","
Current ResultSet (3 columns - 2 varchar, 1 int)
Seattle,Lawrence,1
New York,Jeanette,2
However, my issue is that BCP DOES NOT include Header in Re...more >>
datetime filtering Posted by Sa¹o_Zagoranski at 7/22/2006 12:00:00 AM Hi,
I have problem with forming a select statement and I was hoping someone
could help...
In my application the user can enter the date that the project started
and the date when it ended.
However, because some parts of the date can be null the dates are stored
in seperate columns:
da...more >>
T-SQL Query Help Posted by Andrew at 7/22/2006 12:00:00 AM Hi,
I have the following SQL:
select * from tblProducts where prod_name like '%example%' or
prod_description like '%example%'
How do I order the results such that the results found by the prod_name
clause come first, followed by those found by the prod_description clause?
Do i ...more >>
XQuery and case sensitivity Posted by Helmut Woess at 7/22/2006 12:00:00 AM Hello,
i am trying to read values from an xml variable. In this i have the data
from some records. And the records can (but must not) contain at first
position a field called 'id'. And i want the value from 'id', if field
exists.
Here a short example to show what i mean:
------------------...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
PRINT command in trigger Posted by Curious Trigger at 7/22/2006 12:00:00 AM Hi there,
where can I see the output of a PRINT command which runs inside a trigger?
May I configure SQL Server 2005 to write those PRINT-outputs to the eventlog
or to a file?
I know that PRINT outputs are shown on the 'message' tab in query analyzer,
if a sql-batch is invoked interacti...more >>
Is it possible to join the resultsets of two stored procedures? Posted by Curious Trigger at 7/22/2006 12:00:00 AM Hi there,
I want to use the stored procdures as parametrized views: for each table
with historical information (and columns StartDate smalldatetime, EndDate
smalldatetime) I want to create a stored procedure. Those procedures have a
parameter 'Timepoint smalldatetime' and fetch all records ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |