|
|
|
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 Trusted Server error Posted by Jim Heavey at 11/8/2003 9:01:04 PM I am attempting to run an osql procedure and when I run it, it says the user id and password are "Not associated with a trusted SQL Server connection". This ID and password are able to run that query in Query Analyzer, but it does not work for that same id when run as the ID and password for osql.
...more >>
Foreign Key & UniqueIdentifier Posted by BlckHlDev at 11/8/2003 8:08:01 PM In master table the data type of Primary Key is UniqueIdentiFier, In Detail
table what should be the DataType of the Referenced column to establish a
Foreign Key Relationship? Int & BigInt are not Working, only
UniqueIdentifier is working,
Is this the Restriction?
...more >>
newbie: about a simple select Posted by Jeff at 11/8/2003 5:57:27 PM Sqlserver2000 on win2k3 is my database server
I created one win2k3 usergroup (usergroup is called "TESTGROUP") and added
User1 and User2 to that group
Then I gave the group access to a database called TEST on the server
I used sp_grantdbaccess, sp_grantlogin (windows authentication)
Then ...more >>
Space Used Char V/s varchar Posted by Abraham at 11/8/2003 4:37:53 PM I know char uses more space than varchar since it right pad all data.
But below example suprises me .
Any ideas ??
------------------------------------------------------------------------
create table TEST_TABLE(
recno int,
F_1 char(55),
F_2 char(55),
F_3 char(55),
F_4 char(55))
go
declar...more >>
how to execute sql files Posted by Matt at 11/8/2003 4:29:27 PM Given a sql file with sql commands, how to execute that sql file inside the
SQL Server?? I don't know how to do that.
please help!
...more >>
Help with Function (Revisited) Posted by Keith at 11/8/2003 12:44:00 PM Sorry for the duplicate posting....The NextID table is
essential in this situation.
I am using a table that stores the NextID values. I have
a sp that is inserting multiple records in a table using
the following insert command:
Insert Into GroupAccess (CompID, CatalogID, GroupID,
Acce...more >>
Is SQL Server faster than Access? Posted by Peter Mount at 11/8/2003 11:12:57 AM Hello
I'm doing ASP (we are using classic ASP i.e. ASP version 3, not ASP.NET) as
a module in my studies. I recently did this query in ASP using an Access
2000 table with just over 15,000 records in it. What happened was that it
took forever to run. I actually wound up stopping it from complet...more >>
Incremental Numbers Posted by darren at 11/8/2003 9:25:26 AM I want to have a field showing Incrementing numbers in a select statement,
how can I do this?
Ex:
Select Field1, ClaculateSomeIncrementingNumber from myDataset
would return
FieldData, 1
FieldData, 2
Etc...
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Performing Fast Inserts Into SQL Server Posted by digesh NO[at]SPAM consultant.com at 11/8/2003 7:45:35 AM Hi all,
How can I achive fast inserts into MSSQL Server? We have a parsing
program written in Perl that parses text data and inserts into 2
different databases and 17 different tables. Lookups on 8 primary
tables happens via a Linked server with a Gigy connection. All the
selects for lookups ...more >>
Help with Function Posted by Keith at 11/8/2003 7:06:31 AM I am using a table that stores the NextID values. I have
a sp that is inserting multiple records in a table using
the following insert command:
Insert Into GroupAccess (CompID, CatalogID, GroupID,
Access)
Select @HotCompID as CompID, CatalogID, @HotGroupID as
GroupID, 1 as Access
fro...more >>
trailing spaces Posted by Davis at 11/8/2003 5:51:08 AM Is there a reason how come my varchar column entries when selected from aspx webforms have trailing spaces and when I do the same from the Northwind sample aspx from the Northwind database there no trailing spaces? How do I eliminate them, via database column attributes or database settings?
Thanks...more >>
Multiple insert - Urgent Posted by Pogas at 11/8/2003 4:33:52 AM Urgent help please!
I have three tables in sql server 2000
How do I insert ClientName,Premium,UnderwritersName into
these multiple tables????I quess a stored procedure or
Transaction will do,but dont know how.Quick response to
this request is much apprecited.Thanks for your help in
adv...more >>
My First osql Posted by Jim Heavey at 11/8/2003 4:14:45 AM Hello I am trying to learn how to use the osql command. When I enter
the following command in Query Analyzer, I get an incorrect syntax near
'S'.
osql -S FRED\NetSDK -U Fred -P Fred -i Master..sp_who2 -o
h:\temp\sp_who2_out.txt
When I run the same command at the command line prompt, it l...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |