|
|
|
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 sqlite current_timestamp Posted by Rain at 4/29/2006 7:04:01 PM Hi, im hoping someone could help me with this problem. I would appreciate any
help at all:
SQLite said that it supports current_timestamp but it doesnt work when i use
it as a Default value, for example: (Im executing these sql statements in
sqliteqa)
1.drop table sample_table;
2.create...more >>
SET ANSI_WARNINGS OFF Posted by simon at 4/29/2006 6:52:30 PM I must have SET ANSI_WARNINGS OFF because the program reads return value and
it happends to be ANSI varning instead of return value.
But If I include SET ANSI_WARNINGS OFF into my procedure, I'm getting an
errors because of indexed views.
Is there any solution to this?
regards,S
...more >>
Previewing Crystal Report Posted by Steve Happ at 4/29/2006 1:06:01 PM Hello:
This is probably a very elementary auestion, but I am new to SQL and Crystal
Reports.
We use a 3rd party SQL application. This app uses stored procedures and
Crystal Reports. I've copied and modified one of the stored procedures to
add an additional parameter and copied the Crys...more >>
Intermittent slow performing SP Posted by smithabreddy NO[at]SPAM gmail.com at 4/29/2006 12:19:27 PM Hello,
I have a stored proc that has started behaving strangely a few weeks
after upgrading to SQL Server 2005. This problem cannot be replicated
in the test environment.
The stored proc responds within 1 second in the Production environment
until it slows down (not sure why) and takes abo...more >>
List of hacking applications that run on USB flash drive Posted by xTx at 4/29/2006 7:55:10 AM Security applications such as namp and ethereal are appearing that run
straight from a thumb drive and packet capture, detection and injection
tools no longer require the installation of WinPCap or other
third-party packet capture drivers.
Link:
http://ttcom.blogspot.com/2006/04/list-of-hacki...more >>
Help with SQL QUESTION Posted by pagabas at 4/29/2006 12:16:54 AM Consider the rows for a given extract:
DeviceNumber Type Sequence1 Sequence2
90001 1 A 5
90001 1 A 6
90001 1 B 4
90001 ...more >>
Is there performance penalty for returning resultsets instead of rows Posted by Dejan Grujic at 4/29/2006 12:00:00 AM I'm using server cursor for generic paging.
Interesting part is this:
FETCH RELATIVE @StartRow FROM cur
WHILE @PageSize > 1 AND @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM cur
SET @PageSize = @PageSize - 1
END
Instead of single result set with N rows, this returns N result sets
with 1 r...more >>
Hierarchical queries in SQL Server 2000 Posted by Subbaiah at 4/29/2006 12:00:00 AM Hi,
Do we have Hierarchical queries in SQL Server 2000 (like
that by using start with....connect by prior... in
Oracle)?
If someone has worked on some work-around to do so
in SQL Server 2000, pl. let me know.
Thanks in advance.
Regards
M. Subbaiah
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Array as variable ? Posted by Niclas at 4/29/2006 12:00:00 AM Hi,
I am in a situation where I have an array of userIDs in VB .Net. For each of
these UserIDs I need to query the database for the fastest time for each
user and would like to fill a dataset ordered with fastest to slowest time.
Is there any way I can manage this in T-SQL and submit an ar...more >>
Select query with column name + value Posted by Subbaiah at 4/29/2006 12:00:00 AM Hi,
In my application i am having the situation that, the select query will
returns Column Name + Value.
Ex.
Subject Author
------------------------------------------------
Subject - VisualBasic Author - BalaGuruSamy
Subject - C++ Aut...more >>
temp table in sp_executesql Posted by simon at 4/29/2006 12:00:00 AM This works:
set @sql=N'DECLARE C_LOOPR CURSOR FAST_FORWARD FOR '+
'SELECT v.ING_ID,v.staID from v_predRez v WHERE v.ING_ID IN('+@sIngIDs+')
'
EXEC sp_executesql @sql
OPEN C_LOOPR
....
.....
If I create temp table, doesn't work any more:
set @sql=N'declare @skl table(TX_SKL va...more >>
sql script. Posted by h at 4/29/2006 12:00:00 AM Hi,
Can any one tell me the script for following task:
I am working with a parent table contained with 90 rows and child table with
50 rows(suppose it has no duplicate master value) , I want to write the
script for find that unmatched 40 rows from parent.
Parent table's fields : empmast_i...more >>
SMO Restore Question Posted by Amos Soma at 4/29/2006 12:00:00 AM I am using SMO to restore a database. My question has to do with how to
specify where the .MDF and .LDF files should go. If I do a restore manually
via Management Studio, a default location is provided which is 'C:\Program
Files\Microsoft SQL Server\MSSQL\Data\'. Is there someway in SMO that I...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |