|
|
|
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 Help on technical advise Posted by calderara at 1/7/2007 11:35:01 PM Dear all,
I have an old database structure which has been decided at the time of SQL
server 6.x.
This databased structure is build with HISTORY TABLE and its equivalent
BUFFER table- For example if a table is called EVENTHIST then its buffer
table will be named BUFF_EVENTHIST.
Then we h...more >>
trigger order info Posted by wapsiii NO[at]SPAM otmail.com at 1/7/2007 11:23:47 PM How can I query info about the current trigger execution order? (set
by using sp_settriggerorder)...more >>
send email thru sql server Posted by vipin at 1/7/2007 8:15:50 PM hi, all
how can i send email thru sql server. pls help
...more >>
Owner Name Problem Posted by Rajesh at 1/7/2007 7:53:18 PM In a particular Server i have around 15 databases. Under the server for
some specific database like 'tes'(owner name also 'tes'), the queries
are not working untill we mention the owner name (tes). But in other
database 'CSC_TEST' the owner name is dbtest, for this one even if we
not specifying ...more >>
Cursor Output Every 10 Sample Posted by Joe K. at 1/7/2007 6:42:00 PM
I have a query listed below. This corresponds to a SQL Server 2000 database.
I would like to output every 10 sample.
Please help me create a cursor that will output every 10 sample
from the query listed below.
Thanks,
select fl.* from florida fl, mexico m
where fl.id = m.id
...more >>
Trigger not working Posted by Karl Perry at 1/7/2007 6:05:41 PM I'm new to SQL Server triggers. This is SQL Server 2005.
I created this trigger:
-- =============================================
-- Author: Karl Perry
-- Create date: 1/7/2007
-- Description: Updates GlobalSettings.SignInInfoUpdateDate whenever a
change is made to a record in the table.
...more >>
Extract First and Last Name Posted by Stephen K. Miyasato at 1/7/2007 5:34:29 PM I'm trying to extract FName, LName from this string LNAME,FNAME INITIAL and
get rid of the * and + ending.
Here is what has been done already.
/****** Object: Table [dbo].[Names] Script Date: 7/23/2006 9:25:48 AM
******/
if not exists (select * from dbo.sysobjects where id =
object_id(N'...more >>
Column header Posted by tony wong at 1/7/2007 3:35:09 PM i wish to assign a name to the column header, however i replace Nov with
@UUU, it come up with syntax error
it is because the header name is changed from month to month. Thanks a lot.
****** Query ***********
exec Test @Date0 = 20061201, @Date1 = 20061101, @UUU = NOV
****** Store Pr...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Inserting into a Time column Posted by fniles at 1/7/2007 3:03:07 PM I am using VB.NET 2003 and SQL Server 2000.
I have a table with a datetime column type. When inserting into the table
for that column, I set it to Date.Now.ToString("T")
, which is something like "2:50:54 PM". But after the row is inserted and I
check the data in the database, the column data ...more >>
Passing a parameter into a full text search Query Posted by yaser at 1/7/2007 2:22:50 PM Can any one tell me how i can pass a parameter in the search criteria for
full text search :
somthing like :
SELECT ProductDescriptionID, Description FROM Production.ProductDescription
WHERE CONTAINS(Description, N'@MyParameter');
Do i need to use dynamic Queries.
thanks in advance
...more >>
Getting @@Identiy back Posted by GaryDean at 1/7/2007 11:13:06 AM I'm trying to get Identity back from a stored procedure in SQL Server. When
I execute the SP in Management Studio @NewID is returned in the first
row/first columm. but when I run the code below, executescaler returns
null. I have pasted both the code and the SP below.
anyone know what is g...more >>
adding three fields together Posted by childofthe1980s at 1/7/2007 10:54:00 AM Hello:
The following is a formula that I created in SQL to add the payment/credit
memo amount, discount taken amount, and the write-off amount of each invoice
as a column that I call "TOTAL CREDITS":
COALESCE(RM20201.APPTOAMT, '0') + COALESCE(RM20201.DISTKNAM, '0') +
COALESCE(RM20201.WR...more >>
SQL Server Express Edition & Full text Posted by yaser at 1/7/2007 10:41:08 AM Does SQL Server Express Edition with advanced Features Support Full text
Search, I am really confused because I have some resources telling that it
does support and others telling it don't
...more >>
Dynamic SQL - Set cammand Posted by Andrew Wright at 1/7/2007 4:19:00 AM Hi,
When trying the to do a SET within dynamic SQL I keep getting an error. Can
some explain why this is and how to get around it.
DECLARE @a varchar(10)
SET @a = 'False'
exec('SET ' + @a + ' = ''True''')
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '='.
Regards
And...more >>
Getting first X rows Posted by Simon391088 at 1/7/2007 1:24:00 AM Hi,
I have a table with
salesid int
shopid int
totalpaid money
salesid is a unique key.
example data might be
1 1 £19.99
2 1 £21.99
3 2 £1.00
4 1 £99.99
There are a large number of rows in the table.
How can I retrieve 20 rows only for a given shopid?
For example, the firs...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |