|
|
|
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 Creating a batch job which runs a stored proc Posted by Vamsi at 12/21/2003 11:56:12 PM Hi,
I want to create a Batch job for Executing a Stored
Procedure and saving the output into an Excel Sheet,
Could someone advice me how to go about this.
I want to schedule a job in Windows. I cannot use DTS due
to some reasons. How can i go about saving the commands
in a batch file a...more >>
T-SQL and Record Locking Posted by Gary at 12/21/2003 10:41:05 PM Hi,
I'm trying to use SQL to provide services via a server to client relationship - potentially with in an n-tier structure.
As I see it I have two options.
1) Create a program which builds SQL statements via passed parameters and use either statements or prepared statements to execute the SQ...more >>
Preventing execution stop Posted by adrian zaharia at 12/21/2003 8:30:53 PM Hi,
I have the following situation: In a stored procedure i use a cursor to
parse some rows. Based on each row i dinamically create and then execute
a query using sp_execute. However, it is possible that some queries
might fail and I want to just IGNORE them. Instead, the stored procedure
...more >>
Finding installed Service Pack Posted by Amit at 12/21/2003 7:50:52 PM Hi friends,
How do you find out which SQL Service service pack is
installed on the SQL Server right now ?
I tried using:
SELECT @@VERSION
but it gives me the service pack of the operating system
and not of the SQL Server.
Thanks and regards,
Amit...more >>
Urgent help request: for a VERY complex query Posted by Learner at 12/21/2003 7:36:20 PM Hi,
I urgently need help and guidance with writing a query to solve the
following scenario which is a bit complex:
In tableA I have product and their qty as below
ProdID ProdQty AllocatedAmount
P1 700
P2 400
P3 300
..... and so on
I'll explain the last column ...more >>
Internal SQL Server error when update table with indexed view Posted by david at 12/21/2003 6:45:58 PM I have a table ex12330000 that has a field xml store data like
<field name="contactmode">1</field>
<field name="anniversarydate">6/21/2001</field>
<field name="housecity"></field>
<field name="housevalue">50000</field>
<field name="houseclass">1</field>
<field name="housetype">1</field>
<fi...more >>
Altering table in table's trigger Posted by John Sparrow at 12/21/2003 2:21:10 PM Is it considered good practice to update a table from a trigger on the same
table? Even if it's the same record as the one(s) inserted??
I guess this relies on Recursive Triggers being turned off? What are the
implications of that, that an UPDATE instigated by a trigger won't cause
*any* other...more >>
SP help please Posted by jim at 12/21/2003 1:01:55 PM This sp works when I run it through debug in query analyzer but not when I
run it from VS server Explorer. Any idea what the difference is?
ALTER Procedure GetScores
@Key NVARCHAR(100)
AS
SELECT
1 AS TAG
,NULL AS PARENT
,NULL AS 'Results!1!Id'
,NULL AS 'Result!2!Trait'
,NULL ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Experience in Database Migration Posted by Govindaraju Narayana at 12/21/2003 12:35:30 PM Hi All,
We have a requirement to migrate data from Access to SQL Server.Any
Suggestions in terms of best practices,
tools, tips,books and reference web sites would be greatly appreciated.
Following are some of the facts about the source and target database:
1. The schema of both databases i...more >>
Experience in Database Migration Posted by Govindaraju Narayana at 12/21/2003 12:21:49 PM My name is Govindaraju.
We have a requirement to migrate data from Access to SQL Server. Any
Suggestions in terms of best practices,tools, tips,books and reference web
sites would be greatly appreciated.
Following are some of the facts about the source and target database:
1. The sc...more >>
Create Trigger Question Posted by The One at 12/21/2003 11:29:02 AM Hi All,
I want to run a script which checks to see if a trigger has already been
created for a table
My create trigger statement works find but if I place it inside a test like
if (select * from sysobjects where id = object_id(N'MyTrigg')
AND parent_obj = object_id(N'MyTable') = 0)
beg...more >>
Do NULL fields take up space? Posted by Lecture Snoddddgrass at 12/21/2003 11:12:50 AM Hi,
Let's say I have a field called MiddleName which is a varchar(50). A lot
of people don't have middle names, so I'm going to make this field NULLable.
If a brother doesn't have a middle name, the field will be NULL. What the
man is wondering is:
In a record where the field is set...more >>
ODS: srv_setcoldata sends only 256 characters (SQL server 2000) Posted by amazingwolf NO[at]SPAM hotmail.com at 12/21/2003 8:08:07 AM Hi,
Got this problem with srv_setcoldata. Although I'm using srv_setcollen
to inform the server the size of the packet sent, I still see it sends
only 256 characters. Before the call to srv_setcoldata I also use
describe:
srv_describe(srvproc,
2,
&ColName[0],
SRV_NULLTE...more >>
Database Migrations Posted by Laurel at 12/21/2003 6:38:29 AM We release a version of our prduct quarterly. With this
rapid release, we have to maintain mutiple migration
paths -- currently maintained manually. Are there tools
out there that would allow one to use a gui to create the
migrations? I imagine that it:
Compare schema diffs
Intelligentl...more >>
Secondary (Reporting) Database Posted by Laurel at 12/21/2003 6:32:48 AM Hi,
I am looking for some open ended philosophical discussion
centering around secondary databases - specifically
reporting databases. In our product, we have 2 databases,
one for the application and one for reporting. Obviously,
the schemas are significantly different. We have 0
la...more >>
ClusteredIndex Column Posted by kgs at 12/21/2003 5:16:35 AM how can i find Clustered Index Column Name in a table.
Thanks...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |