|
|
|
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 using SQL SERVER 2008 Posted by roy goldhammer at 9/9/2007 11:52:51 PM Hello there.
I want to learn about sql server 2008 before it comes up to air.
I understand that i need to register to CTL of microsoft, and then i can use
any workstation computer only to learn about it.
What i need to do in order to register?
...more >>
Help About Dbmail Posted by The_TOZ at 9/9/2007 11:47:40 PM Hi .
I am new in the sql programming.I need your help..
I want to write a batch procedure that looking for the amount of goods that
under the critical stoke in a table.After find the goods I send email with
Dbmail to email adresses that found on another table.
1-)How can I schedule this j...more >>
Understanding tables as variables Posted by Steve Dassin at 9/9/2007 9:10:45 PM There is little evidence that the sql community understands the
concept of a table as a variable let alone its significant
implications. Yet there is ample evidence that the sql community
thinks that it is practicing relational principals within an sql
database. This would seem an awkward state ...more >>
Divide using CASE - Need Help Posted by Chamark via SQLMonster.com at 9/9/2007 8:52:10 PM I am trying to use a CASE statement to sum up responses and then divide to
get a percent. Example
SELECT TOP 100000 dbo.CM.Site, COUNT(dbo.CM.BM1) AS [Auth Calls], COUNT
(dbo.CM.BM2) AS [RISK Mgnt Calls],
SUM(CASE WHEN BM1 = 'Yes' THEN 1 ELSE 0 END) AS [Auth
Calls -...more >>
create a competition leaderboard in SQL Posted by mike at 9/9/2007 8:01:29 PM I have a SQL query connecting to an ASP.NET app that is returning a
list of the current leaderboard for a competition. My recordset is
returned with scores in descending order (highest score is the
leader).
Is there any way that I can generate in SQL the current placings so
that I can get out...more >>
Get Count of Items Created In Specific Period Posted by Mick Walker at 9/9/2007 8:00:23 PM Hi Everyone,
I am in the situation, where I want to return the count of all rows from
a table created within a time period. The table has a datetime column
already which refers to when the record was added.
My problem comes in the fact I am working in the interval of a day.
i.e The tim...more >>
CONSTRAINT_COLUMN_USAGE Posted by Jay at 9/9/2007 5:17:02 PM I'm running the following to get the columns in a PK/FK/U constraint.
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
WHERE TABLE_CATALOG = @TABLE_CATALOG
AND TABLE_SCHEMA = @TABLE_SCHEMA
AND TABLE_NAME = @TABLE_NAME
While it does seem to work, I'm concerned that there i...more >>
automatic creation of stored procedures Posted by OK at 9/9/2007 5:15:23 PM What's the best way to create stored procedures in a database while the sp
has been developed before within another similar database? I can't think
that I would need to code it by hand for each database.
Is there a way to export and import stored procedures between databases?
As up to now ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Where are my own stored procedures within Management Studio? Posted by OK at 9/9/2007 4:51:22 PM I am new to stored procedures in SQL Server 2005.
I've been able to add and create new stored procedures within the SQL Server
Management Studio after right clicking the option 'New Stored Procedure' of
'Programmability\Stored Procedures' within a Database. I was also able to
execute the sp...more >>
different default schema in SQL2005 Posted by VT at 9/9/2007 3:54:10 PM Hello all,
Fully qualified database object name in SQL2005 is
[ [ [ server. ] [ database ] . ] [ schema_name ] . ] object_name
If schema_name is ommited then dbo is assumed
select * from customer
=
select * from dbo.customer
Question:
is it possible to make SQLServer assume other tha...more >>
Multiple records in one row Posted by Ray at 9/9/2007 2:55:48 PM Hello,
I have a table that contains multiple prices for multiple
location (yes I know is should have been done with an Xref table or
something, but I didn't create it and it's too late to do right now).
The records are similar to this...
priceID, productID (non-unique), productName, locati...more >>
Space Required to store a file in database Posted by apondu at 9/9/2007 11:47:40 AM hi,
I had a query on sql database, we know we usually store files of
different type in sql database and its helpful for searching and
retrieving the documents from the database, but one query i had was
related to the amount of space required to store the files in the
database. For Eg., say i ...more >>
SQLCLR -- .NET 3.X? Posted by KJ at 9/9/2007 9:59:12 AM Just curious, can SQLCLR managed stored procedures be written
using .NET 3.X, or just 2.0? Does SQL Server 2005 host the .NET FX
3.X? Will SQL Server 2008 host multiple versions of the CLR, or just
2.0?
TIA,
KJ
...more >>
Where is ON stored Posted by Jay at 9/9/2007 9:12:20 AM In the follwing:
CREATE TABLE tab (
...
) ON filegroup
I'm looking for where the filegroup value is stored. I can't find it in
INFORMATION_SCHEMA, or COLUMNPROPERTY.
I am using a very simple install that only has a PRIMARY filegroup, so it
might not be stored. Stll, I would like t...more >>
IDENTITY in INFORMATION_SCHEMA Posted by Jay at 9/9/2007 6:33:37 AM Where in the INFORMATION_SCHEMA does it tell you a column is an IDENTITY
column?
If it's not there, where is the information?
...more >>
Slow Stored Procedure Posted by ahmedeid100 NO[at]SPAM gmail.com at 9/9/2007 5:40:09 AM I have this stored procedure that runs very slow ,,, Is there any way
it could get optimized ???
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
alter procedure [dbo].[yam_notice_select_ChurchesThatNeedNotice]
(@Days int) as
declare
@TargetDate datetime
set @TargetDate = date...more >>
include all clustered index columns in non-clustered index definition Posted by ms news group at 9/9/2007 12:00:00 AM
Suppose that the columns for a non-clustered index is selective enough, so
one adds all clustered index columns in its definition to make it an unique
index.
We know, the clustered index columns are always appended to the
non-clustered index, as a row pointer. Now that the columns are alread...more >>
Restore is being stuck Posted by Roy Goldhammer at 9/9/2007 12:00:00 AM Hello there
I'm trying to restore database. The restore process stuck on 80% and stay
like this forever
...more >>
Delete and reserved keywords Posted by Arjen at 9/9/2007 12:00:00 AM Hi,
I have two questions.
1. How can I delete all data inside a table so that also the id fields
(re)starts with 1?
2. I have a table with the name values. This is a reserverd keyword. How do
I query the table without chaning it's name?
Thanks,
Arjen
...more >>
how identity a record before execute insert operation Posted by Mehmet_Gülden at 9/9/2007 12:00:00 AM Hi
I am working on project which records orders from customers.
I want to create an order id before i insert the record.
So i do not want to use identity functionality of the field.
For the oracle develepers , i am looking for something like
sequences in oracle.
Thank You...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |