|
|
|
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 Searching for referenced columns in a Stored Proc Posted by praseeth NO[at]SPAM gmail.com at 1/15/2006 11:51:43 PM Hi,
I`m a newbie T-SQL programmer.
Is there a way in which we can find out what all Columns and their
corresponding tables which are referenced in a stored procedure or
function?
Thanks in advance..
:-)
...more >>
Dynamic SQL weird stuff Posted by Prospero via SQLMonster.com at 1/15/2006 11:19:07 PM OK im not an expert SQL user or anything and im trying to figure out how to
do stuff purely from BOL...Im still learning how to use dynamic SQL and the
sp_executesql. im trying to run some dynamic sql code on every column in
every user table in a database.... the general structure of the code i g...more >>
SQL 2005 & export stored Posted by Mauro Miotello at 1/15/2006 9:49:47 PM I one develope server with SQL2005 and another on my customer.
When i develope many stored procedure i need to copy to my customer server.
Is there a way to do this quickly ?
(like export, script etc etc...)
thanks
Mauro
...more >>
Possible SQL Bug with clustered indexes and DOP > 1 Posted by justin.parry-okeden NO[at]SPAM cba.com.au at 1/15/2006 7:30:55 PM Hi there,
I think I have identified a possible bug in MS-SQL 2K.....
The information below has been obfuscated for provacy reasons, however
the principal is the same....
I have a table which has several fields (nothing interesting). The
table has approx 1M rows. One of the fields [HR_POSI...more >>
Merge Agent takes all the CPU time Posted by Lina Manjarres at 1/15/2006 6:17:01 PM The merge Agent takes all the CPU resources and makes no space for other
aplications. When I stope the Server Agent the Server becomes available to
other applications. I start the merge agent again and every thing works fine.
How can I handle this so I wont have to stop the merge agent each t...more >>
Memory Usage Posted by Roy Goldhammer at 1/15/2006 5:37:37 PM Hello there
IS there a way to know how mutch the sql server use memory now?
--
øåòé âåìãäîø
òúéã äðãñú úåëðä
èì' 03-5611606
ôìà' 050-7709399
àéîééì: roy@atidsm.co.il
...more >>
scope_identity Vs Parameters Posted by Mr Newbie at 1/15/2006 5:32:21 PM Sorry for double posting but I screwed the last one up. The following code
successfully inserts a record in the Sections table, but the
scope_identity() returns DbNull. If I remove the parameter 'pSectionName'
and replace it with dummy value, it works fine. Alternatively, if I use
@@IDENT...more >>
SCOPE_IDENTITY() / ADO.NET FAILS Posted by Mr Newbie at 1/15/2006 3:28:29 PM The following works fine until I add a parameter, any parameter added causes
this to fail regardless of if I use it or not, I get a big fat ZERO for the
rows returned
Any ideas ?
--
Best Regards
The Inimitable Mr Newbie º¿º
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Prompt Parameter Query? Posted by Oded Dror at 1/15/2006 3:08:36 PM Hi there,
How to I convert Northwind Access Query look like this
SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName,
Employees.HireDate
FROM Employees
WHERE
(((Employees.HireDate) Between [Enter Begining date]
And
[Enter ending date]))
OR
(((([Employees].[HireDat...more >>
Server Size on Ram Posted by Roy Goldhammer at 1/15/2006 12:58:56 PM Hello there
I have one server who connected to many databases.
Two of the database size is very big. (approx 2.5Gb each one).
one of them is very active (all the users are using it) and the another
database is almost passive.
Does passive databases are using the Ram memory?
--
øåò...more >>
Size of objects Posted by Rusty at 1/15/2006 12:50:04 PM I was using a script to see the size of my tables which only amounted to
about 13 GB on the primary filegroup. But I ran dbcc shrinkfile and it tells
me the estimated pages is 6324856 which is about 49 GB. So my "size of
tables" script is missing something (about 36 GB).
Before I ran dbcc...more >>
Performance problem Posted by Christian Staffe at 1/15/2006 11:59:48 AM Hi All,
I'm investigating a performance problem and I don't really know if the
following stored proc is ok or if it could be written otherwise. One of the
parameter is a list of eventypes in XML used as filter. If the xml is empty,
then it means "all events", explaining the reason of the se...more >>
Date Fields Posted by GTN170777 at 1/15/2006 11:12:02 AM Hi all, i would be really grateful if you could help with this one
I have an MS SQL table with amongst others 3 fields -
DatePosted
Dayspostedfor
ExpiryDate
The value inserted into DatePosted id GetDate()
The vaue inserted into Dayspostedfor is eith - 7/14/21 or 28
I'd like ExpiryDate to ...more >>
Getting all users that using sql Posted by Roy Goldhammer at 1/15/2006 10:51:03 AM Hello there
I would like to know which users are using sql server.
How can i know that ?
...more >>
Logical Design!!! Posted by Adam J Knight at 1/15/2006 9:20:37 AM Hi all,
I have a table called students, with the following structure:
Students:
- StudentID
- InstitutionID
- AccountID
- FirstName
- LastName
- Phone
- Mobile
- Email
- StreetAddress
- Suburb
- PostCode
- StateID
I have different types of students that will be stored in the db ...more >>
repost on subtracting date range data between tables Posted by peter walker at 1/15/2006 4:45:27 AM Hi everyone. I posted this previously but made an error in my original
posting. So i am posting again with corrections in place, in hopes someone
might shed light on a possible solution.
What i have is two tables containing date range date. I need to find the
difference between this date. S...more >>
String Manipulation Posted by Mike Perry at 1/15/2006 3:32:43 AM I need to write a report that involves a log file from a Proxy Server. I
have imported the log files into an SQL table and the structure for the
relevant columns look like this:
Table Name: ProxyLog
ClientIP varchar(32)
LogDate datetime
HostName varchar(255)
pTime int
bRecd int
bSent i...more >>
query no longer working?? Posted by shoeman240 at 1/15/2006 3:17:02 AM UPDATE PUBLIC_Transaction INNER JOIN ShipTo ON PUBLIC_Transaction.ShipToID =
ShipTo.ID SET PUBLIC_Transaction.ReferenceNumber = [dbo_ShipTo].[Name] WHERE
(((Len([name]))>0))
When I try to run this I get the error message
An Error occurred while executing query: Inccorrect syntax near the...more >>
SImple DTS stuff Posted by Prospero via SQLMonster.com at 1/15/2006 12:49:32 AM Hey, im kinda new to this DTS thingy. I imported a lot of tables from Excel
to SQL. I got a bunch of irrelevant columns with all null values. They are
all titled F1, F2, ...F84. Deleting all the colums manually is pretty tedious.
How can I make some script that will like delete all columns from ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |