| Groups | Blog | Home |
|
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 August 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 Altering Certificate expiry date Posted by mplpost NO[at]SPAM yahoo.com at 7/15/2007 11:26:30 PM We already created a certificate and delployed a certificate for the
purpose of symmetric key encryption, without explicitly specifying an
expiry date. Is there any "Alter command" to change the expiry date to
any other future date(only late we found that the default is one year
from start date)...more >>
update columns Posted by seema at 7/15/2007 11:02:02 PM I have a table it has three fields name, address, zipcode, currentdate.
when I upade data of any of this columns the currentdate column should
automatically updated by current date(getdate.now) in the table. Can you
provide me stored proc for this.
Thanks,
...more >>
Help with Updating a temp table using dynamic sql Posted by dchman at 7/15/2007 4:44:00 PM I'm using a temp table to get a complicated dataset.
First I create the core of the temp table with
Create Table #tmpStratDataTable
(
questiontemplateid int,
QNum int,
QuestionText nvarchar(2000),
OverallMean varchar(10),
OverallStdDev varchar(10),
OverallRating varchar(50),
Ov...more >>
How to delete records using two selection criteria Posted by JT at 7/15/2007 3:52:36 PM Using Server Management Studio in SQL Server 2005, I'm using T-SQL to delete
records where there are two selection criteria. The following syntax
doesn't work, whereas it will work if I use only one criterion in the WHERE
clause:
DELETE FROM [XRecords].[dbo].[TransLog]
WHERE (Mkt# =...more >>
FOR XML and performance in SQL Server 2005 Posted by PMarino at 7/15/2007 2:00:01 PM Does anyone have any suggestions or pointers for performance optimizations
for SELECT queries that take relational data and
return it as XML columns?
For example, I have a Person table. In our system, a person may have
multiple names, addresses, phone numbers, and email
addresses. S...more >>
AutoShrink won't set using SMO Posted by Paul at 7/15/2007 1:51:47 PM I find that this bit of SMO code won't actually set AutoShrink to true
when I check it in SSMS database properties. AutoClose is set but this
may be the default anyway. Otherwise the code appears to work correctly.
Database db = new Database(smoServer, destDatabaseName);
db.Create();
db.Dat...more >>
selecting from a Stored Procedure .. and Table Name when none Posted by jobs at 7/15/2007 12:46:45 PM Two questions.
1. If I have a Stored procedure that produces a rowset, how can I
select from the procedure itself?
I've tried this to no avail:
this produces a rowset.
Exec dbo.x_sp 'zzzggg','yyy'
How can I select from it?
I've tried all these:
select * from Exec dbo.x_sp 'zzzg...more >>
Can't trap error Posted by Jerry J at 7/15/2007 8:36:00 AM
I am trying to write a stored procedure that has several insert queries
contained within a transaction. If any one of the queries fails for any
reason I want my transaction to rollback. I have an error handler that will
rollback the transaction. My problem is that not every error will go to ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Newbie question: why do we need CREATE TABLE again?? Posted by raylopez99 at 7/15/2007 7:38:50 AM I'm still learning the ropes on SQL. My development envrionment is
using SQL from inside Visual Studio 2005 using either the C# or C++
language, with the server being MS SQL Server 2005 Express (the free
server), though I just upgraded to Developer version.
Given the above, I create tables us...more >>
ADO.NET: How to generate DBConcurrencyException within my stored procedure? Posted by Max2006 at 7/15/2007 3:05:32 AM Hi,
Using SQL Server 2005 and Using c# 2.0:
How can I generate DBConcurrencyException within my TSQL stored procedure? I
expect there is a RAISERROR number that forces the SqlClient to generate
DBConcurrencyException.
Thank you,
Max
...more >>
Error logs are being rolled back by transactions Posted by Max2006 at 7/15/2007 2:57:00 AM Hi,
I am using an error handling mechanism in my application similar to what we
have in AdventureWorks sample database. So I have a TRY.CATCH block similar
to this:
BEGIN TRY
..
..
END TRY
BEGIN CATCH
EXEC uspLogError
EXEC RethrowError;
END CATCH
END
The stored procedure usp...more >>
Relationships error, C# Visual Studio 2005 database bug?, "the columns in table XYZ do not match an existing primary key or UNIQUE constraint", copyin Posted by raylopez99 at 7/15/2007 12:05:16 AM Problem:
I replicated, using Frasier "Pro Visual C++/CLI" (2006), Chap 12, a
database that has a relationship between two tables, called Content
and Author, using a common column, called "AuthorID". I used the
Server Explorer insider Visual Studio 2005 to do this. It worked.
Now I tried t...more >>
Question about performance and abilability Posted by Roy Goldhammer at 7/15/2007 12:00:00 AM Hello there
I have huge database with huge application that:
1. send a request from one server to anothers to get specific data
2. if the data exist somewhere send it back to an application and send to
current server. the data in most cases are saved in the server and its
aviliability is ve...more >>
Strongly Typed DataSets and "Refresh the data table" Option Posted by Max2006 at 7/15/2007 12:00:00 AM Hi,
Using SQL Server 2005 and Visual Studio 2005:
I am trying to understand the stored procedures that Strongly Typed Datasets
wizard generates for me.
When we create a new strongly typed Datasets, and choose the following path:
Choose connection-> Create new stored procedures -> Enter ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |