Home > Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.
SQL server remote connection error
I am getting this error when I execute a query on a remote server. [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()). [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Che...
I am getting this error when I execute a query on a remote server. [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()). [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Che...
answer(2) view(322) status(
)
)
SQL 2000 roll back
I am writing a CMS for <a href="http://www.machineadvantage.com">Machine Advantage</a>. I would like to show user what data has been changed for that row of data. They can either roll back to the old version or approve...
I am writing a CMS for <a href="http://www.machineadvantage.com">Machine Advantage</a>. I would like to show user what data has been changed for that row of data. They can either roll back to the old version or approve...
answer(0) view(62) status()
)
SQL Stored Prodcedure Group by and Sum clauses
I have a SQL stored procedure that is returning results in a table as follows (Below): - I would like to have the results grouped by price so as it only appears the once. I would like to have it so as the copies and Rev totals for each pri...
I have a SQL stored procedure that is returning results in a table as follows (Below): - I would like to have the results grouped by price so as it only appears the once. I would like to have it so as the copies and Rev totals for each pri...
answer(1) view(922) status()
)
Convert a SELECT into a DELETE statement
I need to convert this SELECT statement to a DELETE statement SELECT CustId FROM Profile WHERE CustId LIKE 'HEAT%' AND CustId NOT IN (SELECT CustId FROM CallLog) Here is what I've come up with: DELETE FROM Profile WHERE CustId LIKE 'H...
I need to convert this SELECT statement to a DELETE statement SELECT CustId FROM Profile WHERE CustId LIKE 'HEAT%' AND CustId NOT IN (SELECT CustId FROM CallLog) Here is what I've come up with: DELETE FROM Profile WHERE CustId LIKE 'H...
answer(1) view(225) status()
)
difficulty in creatin a query
hi friends... I have a table which contains ---------------------------- prodmanufac prodname 1 brand1 2 brand2 1 brand3 3 brand4 ---------------------------- How can chec...
hi friends... I have a table which contains ---------------------------- prodmanufac prodname 1 brand1 2 brand2 1 brand3 3 brand4 ---------------------------- How can chec...
answer(1) view(389) status()
)
stored procedure error views
Dear Team, Can any body tell in which table the stored procedure eror details are stored. When any stored procedure is compiled the compilation errors are stored in which table. i.e equivalent to user_errors as in Oracle. Any help ...
Dear Team, Can any body tell in which table the stored procedure eror details are stored. When any stored procedure is compiled the compilation errors are stored in which table. i.e equivalent to user_errors as in Oracle. Any help ...
answer(3) view(778) status()
)
Database Maintanance
The LDF file has gotten HUGE!. How do i fix this? Thanks
The LDF file has gotten HUGE!. How do i fix this? Thanks
answer(2) view(519) status()
)
Connecting to a SQL db
Hi! New here. I now have a MS SQL database but I don't know how to set it up. I'm trying to put MaxWebPortal on my website but I can't follow the directions: -- Create a blank database on your SQL server (or have you host do it) -- Connec...
Hi! New here. I now have a MS SQL database but I don't know how to set it up. I'm trying to put MaxWebPortal on my website but I can't follow the directions: -- Create a blank database on your SQL server (or have you host do it) -- Connec...
answer(3) view(511) status()
)
inserting problem
Hello, I am having a problem with inserting a value into a table. Here is my code: sql = "INSERT INTO AnthonyInbox (MessageID, Sender, Subject, Message, Date)"+ "VALUES('" + msgNum + "','" + from + "','&qu...
Hello, I am having a problem with inserting a value into a table. Here is my code: sql = "INSERT INTO AnthonyInbox (MessageID, Sender, Subject, Message, Date)"+ "VALUES('" + msgNum + "','" + from + "','&qu...
answer(2) view(975) status()
)
auto increment
Hi, I am inserting records into SQL db using ASP VBScript. I want to take the id number if the last reccord add 1 to it and insert the new record with the new id number. if someone can tell me just how to query only the last record, I ...
Hi, I am inserting records into SQL db using ASP VBScript. I want to take the id number if the last reccord add 1 to it and insert the new record with the new id number. if someone can tell me just how to query only the last record, I ...
answer(2) view(92) status()
)
storesprocedure variables
Hi! I have a storedprocedure question. Can a use a parameter as a SQL-Command. I tried something like this with out success. Code: @sortorder = 'DESC' SELECT * FROM tblUsers ORDER BY usrName @sortorder thank ...
Hi! I have a storedprocedure question. Can a use a parameter as a SQL-Command. I tried something like this with out success. Code: @sortorder = 'DESC' SELECT * FROM tblUsers ORDER BY usrName @sortorder thank ...
answer(2) view(584) status()
)
display 2 field in 1 record
Thanx for your help!! Can I display 2 fields in 1 record. i.e I have a table ====================== prodname prodbrand x abx y asd z abx ====================== Can I display it like ===============...
Thanx for your help!! Can I display 2 fields in 1 record. i.e I have a table ====================== prodname prodbrand x abx y asd z abx ====================== Can I display it like ===============...
answer(1) view(831) status()
)
grouping on time in a datetime column
I need to do a GROUP BY on only the time portion of a datetime column. Such as: GROUP BY FormatDateTime(clickdatetime,3) Is this possible? The field value is automatically put in the database by the getdate() function. Thanks.
I need to do a GROUP BY on only the time portion of a datetime column. Such as: GROUP BY FormatDateTime(clickdatetime,3) Is this possible? The field value is automatically put in the database by the getdate() function. Thanks.
answer(2) view(273) status()
)
List of true fields across multiple records
I want to create a directory on a site with multiple categories. The user listing their organization on the site will choose the category(ies) that their organization falls into by checking various boxes on a form. The user searching thr...
I want to create a directory on a site with multiple categories. The user listing their organization on the site will choose the category(ies) that their organization falls into by checking various boxes on a form. The user searching thr...
answer(7) view(387) status()
)
Using LIKE comparison with update queries
Anyone know if it's possible to update records in a MS SQL table using the LIKE comparison in conjunction with records from another table. For example, in one table I have a list of company names together with a client number, similar dat...
Anyone know if it's possible to update records in a MS SQL table using the LIKE comparison in conjunction with records from another table. For example, in one table I have a list of company names together with a client number, similar dat...
answer(3) view(604) status()
)
Log Shrink
Hi I have a transactional log that size is 7286.12mb and space used is 548.42mb. When i shrink log to 1000mb i get something like this: Current size: 7286.12mb and space used: 623.53mb. I think that current size should be 1000mb. Why c...
Hi I have a transactional log that size is 7286.12mb and space used is 548.42mb. When i shrink log to 1000mb i get something like this: Current size: 7286.12mb and space used: 623.53mb. I think that current size should be 1000mb. Why c...
answer(0) view(648) status()
)
connect to MSDE instance using osql
Hi, I am new and blue! Utlimately I want to connect to a database using asp. I have created an instance named Joker using securitymode=SQL because I foolishly created the original default server using Windows authentication and I can't co...
Hi, I am new and blue! Utlimately I want to connect to a database using asp. I have created an instance named Joker using securitymode=SQL because I foolishly created the original default server using Windows authentication and I can't co...
answer(2) view(42) status()
)
MS SQL Server Query
Hi, I have the following SQL query: PHP Code: strSQL = "SELECT orders.ordID, orders.ordName, payprovider.payProvName, orders.ordAuthNumber, orders.ordDate, orders.ordEmai...
Hi, I have the following SQL query: PHP Code: strSQL = "SELECT orders.ordID, orders.ordName, payprovider.payProvName, orders.ordAuthNumber, orders.ordDate, orders.ordEmai...
answer(4) view(737) status()
)
TOP 10 Incidents HELP
HI all .. I am trying to create a query that retrived the top ten incidents in specific terms. The problem is that i can't get the top 10s. [ The most 10 common incidents ] i know that i have to use max but i don't know how to get the...
HI all .. I am trying to create a query that retrived the top ten incidents in specific terms. The problem is that i can't get the top 10s. [ The most 10 common incidents ] i know that i have to use max but i don't know how to get the...
answer(1) view(804) status()
)
trigger infinite loop
The following trigger gives me an "nesting limit exceded error" (in other words an infinate loop) the trigger is recursive but the recod i tested it out on had only 3 child rows, since no other triggers are active on that field,...
The following trigger gives me an "nesting limit exceded error" (in other words an infinate loop) the trigger is recursive but the recod i tested it out on had only 3 child rows, since no other triggers are active on that field,...
answer(0) view(850) status()
)
Constraints by triggers
after the bit field Locked is 1, no changes may occur to the record, the following trigger is the closest i can get to it, but now i can't put the Locked field to 1 either can anyone correct my trigger or give me an alternitive way of i...
after the bit field Locked is 1, no changes may occur to the record, the following trigger is the closest i can get to it, but now i can't put the Locked field to 1 either can anyone correct my trigger or give me an alternitive way of i...
answer(0) view(989) status()
)
Free remote management tool for SQL Server 2k?
Are there any good free remote management tools for SQL Server... preferably web driven either via asp or asp.net? Im currently using table editor which is fine for adding records but it's a bit cumbersome. Ideally the tool would look...
Are there any good free remote management tools for SQL Server... preferably web driven either via asp or asp.net? Im currently using table editor which is fine for adding records but it's a bit cumbersome. Ideally the tool would look...
answer(1) view(668) status()
)
APP Slow on IIS 6.0, not on IIS 5.1
Hello I written a application which pulls 800 rows of data from a sql2000 (SP3) database on a APSX form. I have some filters in the heading of the ASPX page, some calcalations are made with the data. I use the databind en repeater comma...
Hello I written a application which pulls 800 rows of data from a sql2000 (SP3) database on a APSX form. I have some filters in the heading of the ASPX page, some calcalations are made with the data. I use the databind en repeater comma...
answer(1) view(775) status()
)
leaderboard
hi all, I am trying to get together a sales leaderboard, but cant quite get my head around it. i have: user_id - wk_id - sales ----------------------- 101 1 100 102 1 200 103 1 300 101 ...
hi all, I am trying to get together a sales leaderboard, but cant quite get my head around it. i have: user_id - wk_id - sales ----------------------- 101 1 100 102 1 200 103 1 300 101 ...
answer(1) view(925) status()
)
DataFiles
Hi I have a database with two datafiles, located on PRIMARY file group. The .mdf has 20gb, and .ndf has 5gb. How can i determine which tables are created on .mdf and which on .ndf data file thanks alex
Hi I have a database with two datafiles, located on PRIMARY file group. The .mdf has 20gb, and .ndf has 5gb. How can i determine which tables are created on .mdf and which on .ndf data file thanks alex
answer(0) view(406) status()
)
SQL Recursie view or stored procedure
I have a table with a recursive parent-child relation: Parent_ID refers to Line_ID example of how that may look: Line_ID . Parent_ID ------------------ 1 . . . . . null -- higest item (no parent) 2 . . . . . 1 3 . . . . . 1 4 . . . . . 2 ...
I have a table with a recursive parent-child relation: Parent_ID refers to Line_ID example of how that may look: Line_ID . Parent_ID ------------------ 1 . . . . . null -- higest item (no parent) 2 . . . . . 1 3 . . . . . 1 4 . . . . . 2 ...
answer(0) view(989) status()
)
Help with theory behind specific table design and sql select statements...
Ok, this might be a tad long but will make sense. Im putting together a DB of products to be browsed and eventually end up at a list of vendors for a specific item. Right now im concerned with 3 tables. One table is a list of possible...
Ok, this might be a tad long but will make sense. Im putting together a DB of products to be browsed and eventually end up at a list of vendors for a specific item. Right now im concerned with 3 tables. One table is a list of possible...
answer(6) view(433) status()
)
for joins.. does sql need to know of the relationships..
Ok so if you need to to a join between two tables.. do you HAVE to define the relationships in SQL.. ? I also assume that you do that with the DIAGRAM section of entreprise manager?
Ok so if you need to to a join between two tables.. do you HAVE to define the relationships in SQL.. ? I also assume that you do that with the DIAGRAM section of entreprise manager?
answer(1) view(232) status()
)
Matisse, the Post-Relational SQL Database
Matisse (URL), the ultimate database for .NET and Java, is an innovative Post-Relational SQL database for .NET and Java environments that natively supports Objects and XML. The Matisse database represents an outstanding solution for databa...
Matisse (URL), the ultimate database for .NET and Java, is an innovative Post-Relational SQL database for .NET and Java environments that natively supports Objects and XML. The Matisse database represents an outstanding solution for databa...
answer(1) view(114) status()
)
Connect to 2 DBs on Same Server w/t Different Details
Hi, I have two databases on a remote server. To access them I need two seperate sets of details so as soon as I regsiter one SQL server, when I try to regsiter another (Enterprise Manager) I get an error saying that one under this name h...
Hi, I have two databases on a remote server. To access them I need two seperate sets of details so as soon as I regsiter one SQL server, when I try to regsiter another (Enterprise Manager) I get an error saying that one under this name h...
answer(2) view(837) status()
)
Programming
Related Pages
- Query two tables with related data
- Limiting Return Qty
- Selecting only Table 1 records that appear in Table 2
- So what do you do if you have NO IDEA
- Simple GROUP BY question
- SQL over 2 domains
- Looping through records in a stored procedure
- Microsoft SQL server setting
- Problem with DTS Script - please help!
- moved site and asp now pages show sql records twiceTWICE !!
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved