|
|
|
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 Encrypty views, SP and Functions Posted by JCP at 9/3/2007 11:44:01 PM I would like drop and re.re-create the views, sp and functions encrypted.
Is there any sp or function to do this?
Thanks
jcp
--
Jose...more >>
how to get the ip address of client connection (or any other specific machine no) Posted by Rajesh at 9/3/2007 8:20:51 PM how to get the ip address of client connection (or any other specific
machine no) to now form which physical machine the connection was
made.
Rajesh
...more >>
Same data from multiple databases into one database each night Posted by Christopher Hilling at 9/3/2007 2:50:04 PM I would like some suggestions as to which would be the best way of doing the
following.
We have 19 companies each with their own accounts databases, all Sage Line
50 which is an ODBC database, and would like to extract some summary
information out of each database over night and put this in...more >>
Query that updates selected rows. Posted by Shimon Sim at 9/3/2007 2:43:15 PM Hi,
I need to write following query
Let say I have a table Lead with columns LeadId, Name, Phone, LastUsed
(datetime).
I need to select any 100 rows where LastUsed IS NULL or less the set
datetime but also I have to set LastUsed to getdate().
The selected and updated rows must be the same....more >>
How to avoid repetitive text Posted by SqlBeginner at 9/3/2007 10:18:01 AM Hi,
I have written a query to display the week number for a given date within
the month. I want to modify it slightly to match my expected output.
Can you somebody help me in this?
Create table MonthWise
(
dt datetime
)
go
Insert into MonthWise values (getdate()-2)
Insert into M...more >>
Help needed for a query Posted by SqlBeginner at 9/3/2007 9:08:06 AM Hi,
I need a help in writing a query for the expected output i have shown below.
Create table weekwise
(
dt datetime,
code varchar(10)
)
go
Insert into weekwise values (getdate()-2, 'AA')
Insert into weekwise values (getdate()-3, 'AA')
Insert into weekwise values (getdate()-3, 'AA')...more >>
What is the best alternative to a Common Table Expression (CTE) when it is not allowed? Posted by mark4asp at 9/3/2007 8:58:06 AM What is the best alternative to a Common Table Expression when it is
not allowed?
I have a query which is built dynamically in C#. It creates a maximum
of 38 * 4 Select statements which are joined by unions. Essentially
the loop (see C# code below: Appendix 2) executes 38 times.
Each of the...more >>
How to change the base type of a UDT? Posted by francis.moore NO[at]SPAM gmail.com at 9/3/2007 8:22:41 AM Hi,
Is there a way to change the base type of a UDT without having to
delete all instances of it from the tables that it's being used in?
I have a UDT of datatype tinyint, which now appears to be too small to
hold some of the values in it's domain.
So, I want to change it to a smallint. Howev...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Understanding odd execution plan costs Posted by codefragment NO[at]SPAM googlemail.com at 9/3/2007 5:54:55 AM Hi
I'm trying to speed up a stored procedure, at the moment it takes
~10 seconds.
I've done the below which I believe should help remove caching from
timing considerations.
CHECKPOINT
DBCC DROPCLEANBUFFERS
The odd thing is that looking at the execution plan it says that one
part of...more >>
return values Posted by Sir Psycho at 9/3/2007 4:40:16 AM Hi people
Im trying to figure out how to return an error message and value from
my stored proc
I have the following code but im not sure how to check them in my c#
code after the db.ExecuteReader() command
PRINT 'Something has happened'
RETURN 1
Any quick pointers?
...more >>
Cannot view decrypted data Posted by yevgeller NO[at]SPAM gmail.com at 9/3/2007 1:25:46 AM Hi All,
I am working on a SQL Server 2005 encryption project and since I am a
newbie to it, I have a couple of questions:
1. I am opening a symmetric key decrypted by a certificate, and
decrypt data but I only get to view the first letter of the data
string, not the entire string. I am usin...more >>
select distinct Posted by SOC at 9/3/2007 12:00:00 AM Hello,
Table A does not have duplicate records, but it does have a field (itemno)
with repeats in it.
I need a view from table A so that there are no repeats in this field. I do
not care which row is returned for each value of itemno.
ie from this data
c1 c2 itemno
44 34 55
32 32 55
21 ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |