|
|
|
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 How to retrieve the text of UDF in SQL Server 2005 Posted by dariusz.dziewialtowski NO[at]SPAM gmail.com at 4/8/2006 8:43:35 PM In the previous versions of SQL Server, retrieving the text of User
Defined Functions was easy:
SELECT text FROM syscomments sc INNER JOIN sysobjects so ON sc.id =
so.id WHERE so.name = 'fn_dblog' ORDER BY sc.colid
For some reason the above statement doesn't work in SQL Server 2005 (it
work...more >>
datepart Posted by ciojr NO[at]SPAM yahoo.com at 4/8/2006 7:47:43 PM I am trying to use datepart to determine what row in a table a users
hiredate is closest to current system date
example
JOE was hired in Mar 01 2000
I need to get his payrate based off months experience
<12 months
<24 months
<60 months
<120 months
<200 months
Thanks
mike
something li...more >>
temp table in external stored proc Posted by helmut woess at 4/8/2006 7:04:03 PM Hi,
i want to write an external stored proc which works with data created and
stored in a temp table by the calling stored proc. When i use a global temp
table (ie ##temp1) then i can use this table in the external stored proc,
but when i have a normal temp table (#temp1), then this temp table...more >>
>> Help with Stored Procedure Posted by Jonathan at 4/8/2006 6:12:01 PM Hi, I'm so new to programming in MS SQL that the paint is still wet behind my
ears...
Using sql 2000 and vb.net (I normally develop in MS Access)
I have a search form set up so that users can enter any combination of the
following search criteria:
User types all or part business name,
Us...more >>
SELECT top 1 for each ID Posted by simon at 4/8/2006 5:40:57 PM I would like to get only the top 1 row from view for each productID
order by date,type,quality
for example:
productID quantity date quality type
--------------------------------------------------------------
ID1 10 '20060304' ...more >>
Get Windows NT/XP Logon ID in SQL Server Posted by RonL at 4/8/2006 3:50:22 PM Is there a way to get the Windows NT/XP Logon ID in SQL Server if the
user logs on as "sa"?
SUSER_SNAME () returns "sa"
Thanks
Ron
...more >>
Inserting Specific Value in Query Result Posted by DK13 at 4/8/2006 12:33:39 PM I have a table where I need to insert a unique USERID based on the
USERNAME. Seems pretty simple to me, however I am a novice writing SQL
statements.
My knowledge is very limited, so when responding please do not assume I
know basic code.
I have taken on this task in an emergency situation...more >>
PATINDEX and CHARINDEX Posted by mukki_neo at 4/8/2006 4:48:21 AM Hello
I have a table in my database , in one field i have data like this
(230+365+651+695) varchar(100)
I want to use the any SQL function to return the data in form of rows from
the above field.
Result should look like
230
365
651
695
Anyone can help in this regard?????
Thanks in...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Multiple Join Query Problem Posted by Wayne Wengert at 4/8/2006 3:45:40 AM I am trying to update a field in TblA based on the contents of a field in
TblB where 4 conditions match but I can't get it to work. ere is what I
tried:
Update TblA t Set [Show Name] =
(Select Contest From TblB s
Where s.Date = t.Date,
s.RegionalCode = t.Regional,
s.unit = t.un...more >>
File size is growing fast Posted by SF at 4/8/2006 12:00:00 AM Hi,
My SQL database is about 90MB and start growing very fast to 1000MB over a
week time. I try to shrink from the EM with no success. I notice that only
the size of the log file is reduced. Is there a way to do shrink the
database file through Query Analyzer.
I also want to run the shrink ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |