|
|
|
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 Automating Generate Script in Command Line Posted by Mike9900 at 4/22/2006 11:44:01 PM Hello,
Is there a way to automate Generate Script in 2005, so by clicking a link it
generates script which is using a command line and not using Management
Studio Tasks->Generate Script ?
--
Mike...more >>
Non-deterministic Clustered Index for Indexed View Posted by JT at 4/22/2006 11:20:01 PM Hi all,
I am trying to create an indexed view to do aggregation on a table of
Payments. The table has columns as follows:
CREATE TABLE [Payments] (
[PmtKey] [int] IDENTITY (1, 1) NOT NULL ,
[PmtAmt] [smallmoney] NOT NULL ,
[PmtDate] [smalldatetime] NOT NULL ,
[Voided] [bit] NOT NULL CONST...more >>
Need help with Stored Procedure Posted by zod91 NO[at]SPAM yahoo.com at 4/22/2006 8:08:34 PM I have a stored procedure that syntax checks OK, but fails to run...
CREATE PROC RB_VA_TRANS @ID varchar(12)
AS
EXEC('SELECT ''VA'' AS TYPE, ICFPM.PART_ID, VENDOR_PART_ID,
ICFPM.PART_DESC, POFVP.VENDOR_ID,
CAST((SELECT SUM(ON_HAND_QTY) FROM ICFSS WHERE (STORES_CODE = ''RM'' OR
STOR...more >>
Store Procedure check Posted by Rudy at 4/22/2006 7:50:01 PM Hello All!!
Here's a newbie question. I have a store procedure. But I'm trying to test
it in QA, and I'm not sure exacly how do to that. Basicly this SP is taking a
value from a text box, matching that value to the "UserID", then returning
the value of "Credits" for that user. All on the s...more >>
SQL Server 2005 : Where are the Scripting Options Posted by Russell Mangel at 4/22/2006 5:40:22 PM When I right Click (From SQL Server Management Studio), on a Stored
Procedure I can not find
a way to modify the Scripting Options.
How do I do this?
I used to change Scripting Options from SQL Server 2000's Query Anaylzer for
several different objects, like Tables, Stored Procedures.
...more >>
Need records forthe last month Posted by SK at 4/22/2006 3:31:01 PM I need to retrieve records that are posted within the last month and I've
tried variations of below, but do not get all the desired result. I either
get records outside the range or not all the records I should. Posted is
Date1 below.
select convert(char,date1,101)as date1,convert(char,da...more >>
unable to access dbs other than default dbs Posted by Sandy at 4/22/2006 12:55:01 PM Hello -
I had to uninstall and reinstall Sql Server 2000 - time for demo ran out and
I reinstalled with Sql Server 2000 that I purchased.
My databases are not showing up in the UI of either Query Analyzer or
Enterprise Manager. The only databases showing are Northwind, Master, pubs,
etc...more >>
Cross Tab SELECT Posted by LUIS at 4/22/2006 9:52:02 AM I am using MS-SQL2000, on a table called tblItems with these columns:
ID Descripction
-------- -------------------------------
0012 Washer
0145 Oven
2345 Heater
7834 Fan
and other called tblFeatures
ID Description
-------- --------------------------------
00...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
General network error. Check your network documentation ADO.Net error Posted by RJN at 4/22/2006 6:42:01 AM
Hi
I'm getting the General Network error, though not consistently. Stack
trace is below. Any fix for this?
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, TdsPar...more >>
How can you mass-validate stored procedures, views, etc? Posted by Byron at 4/22/2006 4:51:01 AM I am looking for a way to validate all objects in the database that is is
possible for in some automated fashion. For instance, if a column is dropped
from a table stored procedures that rely on it will fail on the next
execution, but I want to be able to run a process that will reveal that p...more >>
Making strings safe for SQL? Posted by Noozer at 4/22/2006 4:31:50 AM I'm writing some general SQL functions to save time later and one of the
functions I'm looking for is something to make strings "SQL Friendly".
What I need to know is, what should I be watching out for?
At this point, I'm assuming that everthing is safe, once the following is
applied to a ...more >>
How to use LIKE in a store procedure Posted by Michael Fällgreen at 4/22/2006 12:47:56 AM How can you use a like-search in a SP
ALTER PROCEDURE dbo.spSearch
(
@s varchar(50)
)
AS
SET NOCOUNT ON
SELECT * FROM tbl where name LIKE @s
What is I need to do a '%@s%' ??
Thanks
...more >>
How to check if server address is valid? Posted by Helmut Woess at 4/22/2006 12:00:00 AM Hi,
how can i check if the used server address is valid? The reason is, that if
a user cannot connect, i want to show "server not found" if server does not
exist or no running sql server is found at this address and "login invalid"
if sql server exists but login fails.
thanks, Helmut...more >>
Schema Sample For Financials Posted by DarkHorse at 4/22/2006 12:00:00 AM Hi Guys
I used to have a site bookmarked that had tons of schema samples for various
applications. Some of it was rather basic but provided a good starting
point.
Does anyone know of a similar sites? I am looking to reference an schema for
a financial section of a e-commerce site that al...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |