| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 problem with IN in stored proc Posted by Daves at 9/28/2006 11:02:43 PM I parse a querystring from a .net website into a stored proc;
ALTER PROCEDURE Postlists_CreateList
(
@Groups varchar(255) = NULL
...
)
AS
INSERT INTO Postlists_Recipients (PostlistID,UserID)
SELECT @PostlistID, UserID
FROM UsersInGroups
WHERE UsersInGroups.GroupID IN (@G...more >>
Executing an sql script on a remote database from Visual Studio .NET 2005 Posted by Nathan Sokalski at 9/28/2006 5:09:41 PM I am connecting to a remote SQL Server database from Visual Studio .NET
2005. I have an sql script located on my machine containing the sql code I
want to use to create several tables, and want to execute it. How can I do
this from Visual Studio .NET 2005? I do not like designing the database ...more >>
Can I use sp_rename in VB program? Posted by mark at 9/28/2006 3:01:17 AM dim gConn as new adodb.connection
gConn.open "...."
strSQL = "sp_rename 'mytable', 'mytable1','OBJECT'"
gConn.Execute strSQL, , adCmdStoredProc
Why last SQL command cannot be executed?
...more >>
DateTime format conversion problem Posted by herethere NO[at]SPAM newsgroup.nospam at 9/28/2006 12:32:41 AM This one is going to be so easy once I get an answer.
When I do a select on a table with a DateTime field I get an answer of
"2006-09-27 16:23:24.000". When I SELECT that into a variable with a DateTime
format I get "Sep 27 2006 4:23PM'.
What I want is to get select format in a variable. ...more >>
Nested while loop instead of nested cursors Posted by venkat at 9/27/2006 4:12:28 PM Hi,
I am trying to write a t-sql with nested while loop and table variable
instead of cursors.
Can some one pls help me if am doing correct with the below code.
eg
declare @myTable table
(rowId int identity(1,1),
p1 int,
p2 int,
p3 int)
declare @nmyTable table
(rowI...more >>
Date and time Posted by Garth at 9/27/2006 9:48:32 AM I am having an issue with a query that is trying to compare a string date to
today's date
I have a table like this
PC Name
Date (year-month-day) (Varchar)
PC1
2006-02-20
PC2
2008-11-11
PC3
2007-08-29
Etc.
Etc.
...more >>
Does backup include stored procedures? Posted by Dagwood Bumstead at 9/27/2006 9:16:39 AM I can't seem to find confirmation of this anywhere...
When I do a backup using the maintenance plan in enterprise manager,
does it include EVERYTHING? ie... stored procedures, views, users,
Or does it only backup the data, requiring a reinstallation of
everything else?
THanks,...more >>
how to use variable in USE method? Posted by mark at 9/27/2006 2:26:54 AM I wrote a store procedure like this:
declare @dbname nvarchar(50)
declare db_cursor cursor for
select name as database_name from master.dbo.sysdatabases
where has_dbaccess(name) = 1 and (name like '[0-9]%')
open db_cursor
FETCH NEXT FROM db_cursor INTO @dbname
WHILE @@FETCH_STAT...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Questions about MSDE and SQL 2005 Server Express Posted by Tony Girgenti at 9/27/2006 12:20:22 AM Hello.
I don't understand the SQL Databases.
I was once using MSDE of SQL2000(Server name = DHJC2R91). Since playing
with VWD, i downloaded and installed SQL Server 2005 Express Edition(It gave
me a server name of DHJC2R91\SQLEXPRESS). After that when i use the systray
icon with the li...more >>
SQL 2005 Database Location Posted by SW at 9/26/2006 5:35:37 PM Hi,
I installed SQL 2005 onto my D: drive but somehow the data is being stored
on my C: drive. (I only noticed this when my c: drive filled up!).
In Server Properties, there is a Default location for datafiles box. If I
just enter the desired location in there (it's currently blank) will the...more >>
Is there something like a completely external trigger to catch updates? Posted by karen at 9/26/2006 9:37:19 AM Hi-
We need to find out when records are added or changed in a vendor's database
for a customer. The customer has said that we can't add triggers nor make
other changes to their database. I've been familiar in the past with SQL
databases (Oracle, Informix), but haven't been using them curre...more >>
LDF File Size, How big is too big?? and Posted by WANNABE at 9/26/2006 9:12:07 AM What is the best way to manage Log file growth?? We have a document
management program and the MDF file is about 3.5 gig, but the LDF file
suddenly ballooned up to 34 gig. The data is backed up nightly and the logs
are backed up hourly. I thought that would allow the log file to "flush
ou...more >>
Integer presented as Text Posted by Anders Eriksson at 9/26/2006 12:00:00 AM Hello,
I have a table where a value is saved as an integer (value 0, 1, 2).
Now the customer wants to have this presented as "Low", "Normal", "High"
Is there some SQL magic that can create a recordset where the integers is
replaced with the text?
// Anders
--
English is not my first,...more >>
REtrieving Data from More than One Table Posted by JC HARRIS at 9/25/2006 4:25:19 PM I am new to this so hopefully you'll bare with me if this is a stupid
question.
I receive data in a dbf format from the state office on a yearly basis. I
have figured out how to use SSIS to pull these into the SQL system as
different tables (e. Birth2002, Birth2003, Birth2004) within a sing...more >>
inconsistent RESTORE DATABASE issues Posted by APB at 9/25/2006 12:10:02 PM Hello. I'm restoring databases from their .BAK files and everything went
smoothly until the last 2.
this is the error message I am recieving in Enterprise Manager when I
attempt to restore from device :
-----------------------------------------------------------
Device activation error....more >>
@ symbol in field name problem Posted by Vayse at 9/25/2006 12:00:00 AM A third party app supplies a table in a SQL database. Unfortunately they
have chosen to end all their field names with # or @.
If I create a view, and include a @ field, the diagram pane will not be
available next time I open that view.
Is there a way around this?
Thanks
Vayse
...more >>
Sql Server Professional Magazine Posted by Tim Zych at 9/23/2006 8:58:32 PM Does anyone here read the magazine "SQL Server Professional" by Pinnacle? I
got a sample copy and it seems really informative and well written. It's
expensive though, but if the whole subscription is as good as the trial
copy, I think it would be worth it.
What do developers think? Is it worth...more >>
SQL Server Desktop Posted by OdieTurbo at 9/22/2006 7:58:48 AM Hello, I have SQL Server Desktop version 7 running on my laptop. I am
using as a data source for Cognos DecisionStream. The issue I am
having is that my database has grown quite large. Everytime I try to
do anything, my database is EXTREMELY slow. What can I do to increase
the speed/efficien...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |