Sql Questions and Answers
Open Question: SQL Server, joining common fields between table?
Hi there, I have three SQL tables. 1. SpritesTable 2. SpriteRipper 3. SpriteSheetTable 1 & 2 have a field in common called RipperName. 1 & 3 have the Primary Key of Table 1 in common. How to I link these fields together? I am not using the text view I am using the table view (I am new at this I don't know the terms that well) moreOpen Question: performance in sql server 2005?
i had a huge database of about 2tb and i need to update the statistics on it regular basis and it usually taking 20-30 hrs for updating the statistics and I am usually doing that on non business hours. can i update the stastics on business hours?does it have any user impact? does my user get any problems while I am updating the statistics? moreOpen Question: wht is the best course to do after B.Tech IT ?
i want a computer course. like networking(ccna), ERP(SAP), programming(php),database(oracle, sql).. i would like to the best course in this, orelse is there something other than this that is the best., i want something that is not much costly... n something that is not very tough too.. please advice me moreOpen Question: SQL+ ISWHERE TO DWNLOD?
moreOpen Question: What OperatingSystem Does Microsoft SQL Server 2000 Works On?
I've Tried On Windows XP But Still Nothing WorksPs: im using VMware (so i can host xp, 2000, etc) moreOpen Question: is it possible to make the address list in msword converted as sql database?
i have typed two columns with 20 addresses per page of 200 pages of addresses as word document for cutting and pasting on postal covers. is it possible to make it a database moreOpen Question: No dynamic code in MySQL stored events?
It says in the SQL manual that you cannot enter any dynamic code into an event. Is there some way that I could use an event to trigger a php script or is there something similar to SQL events in php? Any solutions would be extremely helpful. Thanks. moreOpen Question: Best practice SQL table setup?
I am recording users' hobbies. I have a reference table with the unique hobbies. In my "UserHobbies" table I need to associate each user with his list of hobbies. Should I have separate integer fields to record their hobbies, like "Hobby1", "Hobby2" etc (let's say up to 10, leaving extra unused ones blank), or should I have just one varchar field "Hobby" where I concatenate the hobbies separated by semicolons? Which is a best practice for such a necessity? Thanks moreOpen Question: How can i create a custom database?
I want to make a custom database making my own buttons, look, everything. I have visual basic and can get sql server but i am not sure how to make this database. I want to be able to click on a tab (SEARCH) type in a phone number and it brings up a list of people. well actually only 1. (the person who has that number) so i want like a thing where i can store all my friends and famils number, address, phone number, etc. What program should i use. and how would i do entrys and search features? please be very thorough. Not a 2 sentence answer.. Thanks in advance.. moreOpen Question: what is microsoft SQL server?
i am clearing space on my computer, and found this, do i need it? whats it for? what does it do? thanks guys moreResolved Question: I might be pregnant and he hasnt even called, should i be pissed?
ok, so last night me and my bf had an accident the condom broke (LIFESTYLE CONDOMS SUCK) and well we were like flipping out and i was like dude dont worry ill take plan b. well i am now done taking my plan b and im awaiting for the 5 days to take the pregnancy test. Well long story short my boyfriends phone is broken, hes like oh yeah well hang out tomorrow im like fer sure. so today he calls me when hes on break at sql and then hes like ill call u when im back in town (he works downtown chi.) and well here i am fcuking waiting, possibly pregnant and he hasnt called. Should i be pissed? I am right now but fcuk i need some input hereSo he called, sorry about the terrible grammar i was just caught up in the whole mix of things. Yes, he called and basically explained how he was sorry for not calling but that he will make it up to me, we are hanging out today. :D thank you for answering it really did put a ease in my mind. <333put mind at ease* moreResolved Question: Is this a valid SQL command?
The command is: SET @level = SELECT level FROM players WHERE player_id = 357; (The database is already selected) What I want this command to do is set the variable @level to whatever is in the field `level` in the table players where the player's id is 357. Am I going about this the right way. Thanks. moreResolved Question: Is an object-oriented database the same as a row-oriented database?
I just started learning databases and SQL and I'm confused about what "row-oriented" means. According to Wikipedia a column oriented database groups data according to columns, i.e. groups of the same properties of different records. A row-oriented database then would group data by records (which are like objects). I think this is what it means but I'm not sure. I may be completely off. moreOpen Question: SQL query to obtain lookup column data from MS Access DB?
In an MS Access table schema, a column can be created as a lookup into another table, making it effectively a star schema. When you view the table data in Access, you don't see the IDs -- you see the actual values, like this: [Country] Australia Belize Canada If you query the table in SQL (via a JET-ODBC connection) using "SELECT * FROM myTable", you see the IDs, not the country names: [Country] 1 2 3 I know how to do a join in SQL (e.g., "SELECT Name As Country FROM myTable JOIN tbCountries ON tbCountries.ID=myTable.Country". However, because the lookup seems to be part of the MS Access table schema, I want to know if there is any simply generic SQL mechanism that would let me do something as simple as "SELECT * FROM myTable", without having to construct the Join. I can't change the database - I can only read from it. I know that if the designer had defined in query in Access, rather than using the column lookups in the table schema, then "SELECT * FROM myQry" would do what I want. The DB I'm dealing with has many dozens of tables, with many of these lookup columns with numerous variations. My app needs to query the joined data without knowing the underlying lookup schema info. moreResolved Question: all SQL syntax is available in the "mysql_query(...)" PHP function?
I'm studying the mysql_query() function, and I would like to know all the things that I could add into the first parameter of this function. as I know they could be a lot, here, I found a list of all SQL reserved words: http://developer.mimer.com/validator/sql-reserved-words.tml My question is: all those words, can be used in the mysql_query() function? or is there limitations?. moreOpen Question: how do i query SQL to return quarter value (1-4) when i have the month?
I'm trying to do some work in matlab and sql. i want to write a simple query that will allow me to specify a month value (say june [6]) and will return the calendar quarter it is in (in this case, 2). any ideas how to do this? i know about the datepart function but i'm not sure how to set up the query to do this task. any advice is greatly appreciated moreResolved Question: Counting how many times a value changes in SQL?
I have a SQL database that is logging real-time data and I want to detect the number of times a binary value is changing from the historical data i.e. Time, Binary Value ---------------------------- 1, 0 2, 0 3, 0 4, 1 5, 1 6, 1 7, 0 8, 1 9, 0 10, 1 11, 1 Given the above dataset, I need to come up with a query that can count that there are 3 times the binary value changes. Any ideas, I'm totally stuck! Thanks!Sorry I meant transitions from 0 to 1 (rising edge), but even counting the 5 "changes" will do moreOpen Question: Where can I find a beginner's guide to using MySQL, in particular WampServer 2.?
I love the Lynda.com, HOT (Hands on Training) book series. I used these resources to learn both Flash and Dreamweaver. Now I'd like to learn about databases, in particular, adding a site search to my website. In order to do this I need to learn how to use MySQL and PHP. I've downloaded WampServer 2, but now I need a crash course on SQL, preferably done Lynda.com HOT tutorial style. I've done google searches for beginners guides, but I'm not having any luck. Got any suggestions?That might have been just what I was looking for, but I can't access it :( moreOpen Question: I install wampserver2.0. it does not display page in http://localhost/? And there wampserver-mysql askpassword?
I am new to php. I Install wapserver 2.0. After install in desktop shortcut icon I click then in task bar Right sight corner it show wampserver icon I move through these icon it is show wampser offline. Then I like to open http://localhost/ . Then it must show any page because in there www directory in contain some php file .but it does not show page. it show unable to connect . What is problem? Then I click in the sql console window it ask password. Now I install fresh copy and I am not set any password so I enter 123 the I click enter. Then console window automatically disable. What is problem? How to use wampser2.0 with php and mysql. Please give the solution. moreOpen Question: So I have listed below the types of computer languages I am interested in learning. Need Suggestions.?
During my downtime, I am interested in attaining basic/intermediate knowledge of various computer languages/ programs. Of the ones listed below, what are the MUST learns and what are the ones I could do without. ***Remember****I have no specific career goal in mind currently, just possibly looking to branch out in the next 6 months to a year. HTML XHTML Javascript Java SQL PHP Flash Photoshop moreOpen Question: Will I need any prior database experience to take SQL classes?
I've enrolled in 2 SQL classes in the Fall: 1) SQL Administration 2) SQL Implementation I have no prior background with databases or programming, but I thought it these classes would be a good way to advance with my company and learn a database. Will I need prior experience with databases for these classes (e.g. Visual Basic) or will I be OK if I start with SQL Administration?? I don't want to be completely lost. moreOpen Question: Are these job postings are real or fraud?
BRITISH PETROLEUM COMPANY UK OFFICE OF THE HEAD OF THE HUMAN RESOURCES DEPARTMENT 1 St Jame Square London,SW1Y 4FD +44 702 408 1580 Ref No: 01/007/HRD/BPPLC Attention: Applicant It will be an excellent opportunity to join one of the world biggest Oil and Gas company that is focused on growth and sharing that success with employees. The Company offers a combination of competitive base salary with stock and stock options from day one plus other benefits. The compensation philosophy includes annual performance bonuses that have paid out in the two years of the Company's existence in the UK. The Company has approximately 100,000 employees spread between offices in United Kingdom.It is now seeking to strengthen its team with the addition of challenging team of new employee. With a workforce of nearly 100,000 employees, BP operates globally, with business activities and customers in more than 100 countries across six continents. Every day, we serve millions of customers around the world. To put this in perspective, our businesses and brands – among them BP, Castrol, ARCO, Aral, Ultimate, Connect and am/pm – reach nearly as many consumers as Wal-Mart, the world’s largest retailer. BP downstream: oil refining and trading energy products in over 100 countries. We received your CV.It was sent to the office of the Recruit Team for screening.Your qualification has met with BP first Round of recruitment, therefore you have been sent our company's Application Form and Terms and Conditions for your kind view. Do fill out the application form if you are satisfied with our Terms and Conditions (Recruitment Policy).If your application meets the minimum requirements, you will progress to the next stage of our selection process. This is a detailed review of the CVs/resumes and application form of all the candidates that have met the minimum requirements. The recruit team will then decide which candidates will be shortlisted for an interview here in london.Please be informed that only applicant who met with our recruitment policy and standard and also can incure 33% of their traveling expenses will be screened and consider for the interview here in our Head Quater. If you are successful you will be invited for an interview in person. You will be contacted via email for the interview call up letter from the Chief Recruit Officer who is the head and leader of the recruit team. If you are not successful you will receive an email letting you know. We will continue to notify you when your profile matches other job postings as there may be a different job for which you are a better fit. BP need resourceful and Team Co-Ordinating individual to take up the new BP Branch offices which the company commissioned recently.Applicant with a good number of years of experinces in Is/Her qualification will have more job opportunity with BP. British Petroleum Company needs applicant with the ability to present conclusions and recommendations clearly is essential. Ability to work effectively with highly skilled technical professionals essential. Must be enterprising,creative and energetic, eager to accept new responsibilities and challenges. Must be flexible and willing to undertake occasional travel. Package: A base salary in the range £9,000(Pounds) - £20,000(Pounds) Monthly dependent on experience, plus attractive Stock Grant (from day one), Target Bonus (circa 20% at present) and other Oil Company benefits. Accomdation: Accomdation will be provided for all newly employed staff of BP,these apartment will be able to accomodate staff and family for the time duration working for BP.Apartment will be changed for staff upon promotion in position. Family Education: Education entitlement will be given to staff before resumption of new office with our company. Full summary of the entire package will be couriered to qualified applicant before resumption of duty. All positions are vacant in these offices, and British Petroleum Company needs skillful and well experienced individuals in the following area: Marketing. Account Executive. Chief Accountants. Engineering Managers Maintenance. All Managerial positions. Cost Engineer/ Sr Quantity surveyor. All Engineering positions. Chief Engineers.. Management and Project Management. General Manager/Manager Engineering. Project Manager, Exploration of Oil and gas fields. Medical Officers. Medical Consultants/Specialist. Mining Consultants. Engineering consultants Financial Consultants. Petroleum Geologist. Welding and heavy fabrication. Professional Executive Secretary. Human Resources, Administration. Microsoft Access, SQL-Server, Share Point Portal Server, Systems. Personal & Facilities Management. Const. Mgmt/Tendering Document control. General Managers ect. All position are still vacant, qualif moreOpen Question: Searching for a good job!!?
There are urgent open positions in Accenture (Hyderabad) for levels SSE/TL/AM in SQL DBA. For further details please send mail to avrr_ujwal@yahoo.co.in And also few more openings in Accenture (India) at different locations in skills (New Generation Data Center (NGDC), MOSS Admin*, AXX++, C# - Technical Architect, Microsoft BizTalk, Microsoft BizTalk – Technical Architect, Microsoft BI Tools*, Microsoft Commerce Server*, Microsoft SharePoint – Technical Architect*, Microsoft SQL Server Database (Developer), CRM Testing*) for levels SSE/TL/AM. SQL DBA, NGDC, MOSS Admin are having more openings. As always, feel free to send me mail to avrr_ujwal@yahoo.co.in moreOpen Question: how to edit a view through data databinding using gridview?
C# ,, sql database.. windows form app it is easy to update changes back to db apply databinding on a table with datagridview control ... but obviously i dn't want to load the whole table.. if my user wants data with date limitations... like receipt records in reciept table on date dd/mm/yy ,,,, soo ,, i created a view .. and databind that view with datagridview.. bt now here is a problem how to update changes made by my user moreOpen Question: Delphi 7: HELP!! I can't execute my assignment..?
I'm in my final year of high school (matric), and I have this MONSTER of an IT assignment thats sitting on my head. Its set up in four stages, I finished stage one and two, but I'm struggling with stage 3! Stage 3 consists out of Delphi with SQL programming. Its extremely hard for me to grasp HOW I should start this. I know what has to happen, but I cant execute it so well. Since this part has to be handed in in about two weeks time, it would be too slow to use answers only, since I have many questions, and even more come up while I'm busy working on the code. I would appreciate it if I could have somebody helping me via Yahoo-, or Windows Live Messenger. If you can help me with this, I would really appreciate it if you would let me know. moreOpen Question: i hav problem with SQl srever .. I m not able to connect with SQL server .. So tell d steps ...?
Information On SQL server Operations In short moreOpen Question: Where does the SSIS package go?!?
Hello all. Noob to SSIS here so please forgive my ignorance. When importing a given file through the import/export wizard in SQL 2008, it offers the user the chance to save this import as an SSIS package - lovely stuff. Where exactly does this package go exactly?! I'd just like to see and view it in Buisness Development Studio and expand on the data import. Again, I apologise for what is likely to be a ridiculous question and thanks for your help. moreOpen Question: Sample Payroll In sql Oracle?
I am In need for the project .. I wanted a sample Database of Payroll ready Script of Sql if any one has PLz send me via Mail or post the link i appreciate .. sk_all@ymail.com moreOpen Question: How do I link to my inhouse database over the internet ?
We have a Windows client/server database system in-house (it uses VB6 and Access but we can go to SQL Server). We now want to let our customers have access to the database over the internet for simple queries. But our website is hosted (not in-house). It wouldn't be practicable to have our database hosted remotely - it is used very heavily in house, whilst we only expect light usage over the internet. How do we link from a page on our website to the database on our server ? We'd write a simple application to allow queries from the browser - any suggestions in what language ? VB.Net/ASP.Net ? moreOpen Question: how to release the savepoint in sql commands?
moreOpen Question: SQL number library failed to initialization,your installation is either corrupt ,unistall then re -run,what do?
what does it mean and what do i do moreOpen Question: What does the DISTINCT command in SQL do?
Can someone explain what this does,it doesnt make sense to me.Thanks moreResolved Question: 20 points. I asked an SQL question about an hour ago. No responses.?
This is something that I am really stuck on. Here is the link: http://answers.yahoo.com/question/index;_ylt=AtlJAVCvN4A_QnHTjrZkXdrsy6IX;_ylv=3?qid=20090701204519AASuJoV I will give the best answer 10 points on this question and 10 points on the other one. Please help. Thanks. moreOpen Question: I need help with website installation, with SQL Databases?
I bought a "script" from a seller online. He sent me a bunch of files compressed. I ahve unzipped them and have put them all on the server per his instructions, in the instructions he says to setup SQL Database with the "db.sql" file. I'm not real sure what this is? Can anyone point me in the right direction> Thanks moreResolved Question: Why can't I use a DELIMITER in SQL?
I am using PHP to to create an event in MySQL via an SQL query. I am using the "DELIMTER" syntax so that semicolons will not end the "CREATE EVENT" statement. Anyway, when PHP sends the query, MySQL returns an error telling me that there is a problem with the syntax, specifically the word "DELIMITER". Could this feature somehow be turned off? Can I turn it on? Also, if anybody could give me a link to the section of the SQL reference site that discusses specifying delimiters in such a way, that would also be really great. I can't find it. Thanks. moreOpen Question: How to make an e-commerce website (experienced answerers)?
I know how to make a website. I've taught myself using basic teenager websites such as piczo. Now I can make a good website using HTML, asp.net, css and photoshop. I've set up an example shop because I want to keep on teaching myself and learning because I want to be a web designer. I'm 17 by the way. How do I make my example site into a shop? Do I need a shopping cart system? Or can it be done using a SQL database(which I can't figure out well) Please only answer if you really know how to help :) thanks in advance you'd make my day I've been trying to find the answer.I know everything about websites domains, hosting all that. Just I want to make an e commerce site like a clothes shop. Not real to go on the Internet but so I can learn how to. I want to do most of the coding unless that almost impossible without a e commerce system moreOpen Question: about Microsoft SQl server?
During the presentation to management, the owners identified the following additional reporting requirements: 1. Have vendor report; exclude disabled vendors. 2. Include inventory by category report, exclude disabled Inventory, and order by inventory name. 3. Have stock-out report; exclude disabled inventory. Prepare queries for the reports in Microsoft SQL Server Management Studio. Use subqueries, joins, and aggregation functions within the queries. Copy the SQL from the visual design tool to a Microsoft Word document. moreOpen Question: I'm needing to create custom forms for mySQL that only use SQL code. Easy front end. GUI. Any thoughts?
There has to be a way....just looking to create a form that I can have users put a ID number in a box and retrieve info for said ID from a table. Shouldn't be all that hard but I can't seem to pull it off. Ideal would be excel pulling from Mysql table but I'll go third party if need be. moreOpen Question: help with vieleRETS needed?
I have set up a vieleRETS server for some one and connected to RETS well. I want data to be downloaded in the relational database. I am having trouble here. Table for images is created and the image data also inserted into the table. But the table for text is not created. I get a long sql query while downloading and I tried to create a table with that query which returns some error like "#1103 - Incorrect table name 'C_ROOM_1LV' " which is not at all mentioned by the developer. It shows some data insert error and I found that it is caused because the table is not created.. Can anyone tell me what is that which blocks the text table from creating and not the image table..this is the link to http://idxsync.com/idx/index.php the server..Please help me...Thanks in advance.. moreOpen Question: If your tables were named T1 and T2, we could join them together with the following SQL code?
moreOpen Question: sql view creation challenges?
CREATE OR REPLACE VIEW duplicate_ssn_view AS SELECT * FROM stage_enrol where select input_ssn from stage_enrol where source_batch_id = 701 and ed_level_id >=2 group by input_ssn having (count(input_ssn) > 1) ORA-00936: missing expression on the second select statement Any advice and you'd rule moreOpen Question: what are the best programming languages to learn(HTML, XML, SQL, etc.)?
What is the best order to learn them and how long does it take to achieve a intermediate understanding of each?I'm not currently in an IT field but I am interested in getting trained in the languages that will provide me with the best chance of getting myself in an IT position then feeling my way out from there. So what would be the best languages to learn in this case? moreResolved Question: how can I get data from mysql(phpmyadmin) to access..?
I read that you cant do it...is that true?? I need to copy tables from phpMyAdmin to an Access table... I tried using the sql code yesterday, exported off of phpMyAdmin...but i just got errors :( Thanks!Im not sure if i can do that from phpMyAdmin, looks like I need a local sql server thing or something...i dont know all the terms moreOpen Question: How much to charge for web site maintenance?
Thanks all in advance for your input. I created a website using asp.net and sql server. I also implemented a shopping cart and a back end administration section for my client. Now I'm trying to propose a maintenance fee plan for my client. I am new to this and would like to get anyone's feedback. Potential Pricing Plan version 1: Pay-as-you-go maintenance is charged at an hourly rate of $40. However unlike most web development companies we only charge per quota (capped every 30 minutes). So for example if a project takes 0-30 minutes then the cost would be $20; between 30-60 minutes would cost $40. or customer can choose Fixed monthly plans Plan 1 - 2 hours of support - $70/month - $35/hour - save $10/month compared to the pay as you go option ($40 X 2 hours = $80) Plan 2 - 5 hours of support - $150/month - $30/hour - save $50/month compared to the pay as you go option ($40 X 5 hours = $200) Plan 3 -10 hours of support- $250/month - $25/hour - save $150/month compared to the pay as you go option($40 X 10 hours = $400) ====================================== Potential Pricing Plan version 2: Pay-as-you-go maintenance is charged at an hourly rate of $45. However unlike most web development companies we only charge per quota (capped every 30 minutes). So for example if a project takes 0-30 minutes then the cost would be $22.50; between 30-60 minutes would cost $45. or customer can choose Fixed monthly plans Plan 1 - 2 hours of support - $80/month - $40/hour - save $10/month compared to the pay as you go option ($45 X 2 hours = $90) Plan 2 - 5 hours of support - $175/month - $35/hour - save $50/month compared to the pay as you go option ($45 X 5 hours = $225) Plan 3 -10 hours of support- $320/month - $32/hour - save $130/month compared to the pay as you go option($45 X 10 hours = $450) Plan 4 -more than 10 hours of support. - $30/hour. $30/hr is below market value. Client specifies how many hours they want each month(more than 10 hours to get this rate) and I will multiply my hourly rate of $30 times number of hours to get the monthly fee. I'm not sure if any of these plans work. If you have a better idea for a maintenance pricing plan let me know. Thanks, I based maintenance plans off this website(except i'm cheaper): http://www.lajuett.com/web-maintenance.html Brandon Drake http://www.tshirtquest.com moreOpen Question: is there any sites that can help me learn php/mysql/sql?
I want to make my own text based game and i need to learn how, also are there any free hosts that host php my admin moreOpen Question: How to create a table in ms access 2003 using MS Visual Basic 6.0 ?
I'm making a project using visual basic 6.0 and ms access 2003, which requires to create a separate a table in every financial year. I'm using ADO-Connection to connect the database.I need to know how can i create a table (using sql queries) from VB 6.0 codes. Plz Help Me. moreOpen Question: how do you replace fields on a table using perl?
Hi, I got the code below, but I would like to check if an entry is already in the table and if not insert and if it is update it. --CODE-- use strict; use warnings; use DBI; use DBD::AnyData; my $table = "data"; my @fields = qw/ id name /; my %field_def = ( id => 'char(20)', name => 'char(20)', ); my $dbh = DBI->connect('dbi:AnyData(RaiseError=>1):') or die "Can not create database connection"; # build the create table SQL on the fly $dbh->do ( "CREATE TABLE $table (" . join(',', map { $_ . ' ' . $field_def{$_} } @fields) . ")" ) or die "Can not create table"; $dbh->do("INSERT INTO $table VALUES ('01', 'FOO' )"); unlink './data.csv'; # delete existing csv file if any $dbh->func( 'data', 'CSV', './data.csv', 'ad_export'); $dbh->disconnect(); --END CODE-- I've tried loads of different ways I've seen on websites, but none seen to work. I think its something to do with the "INSERT INTO" but, but I can't work it out. I would also like to know if it is passable to make it so I can have unlimited letters it the fields? Thanks for your help. moreOpen Question: Can we integrate sql and access?
Senario is this that i have an access db and an sql db. Access db is generated by my device, and is raw information. Sql db is my application backend database. I want to integrate access with my sql such that if there comes new values in access db(raw values), i may implement them in my sql db in a meaning full way. Like,, if i receive in access db some entry 13424 in any field. I want my sql database to be updated by, like it ld store IBM keyboard / stock id 24 in any table( Accessories )... Regards .. moreOpen Question: Help required with Insert Query in Delphi 6?
Guys, I am having difficulties using Insert query. Here are the table fields: (contactid, contactname, gender, age, countryid) contactid is PK (auto number) and countryid is Number (FK) contactname, gender are Text age is Number Here are Form controls: Edit Box edContactName stores contactname Char variable gender stores gender Edit Box edAge stores age List Box lstCountry is already populated with Country Names from country table QCountry.Active := True; QCountry.Close; QCountry.SQL.Clear; QCountry.SQL.Add('Insert into contacts(name,gender,age,countryid)'); Please help me complete this Add statement. I am having trouble with the string formatting. Thanks in advance, Regards. ZainInteger (FK) Value at SelectedIndex of lstCountry should be inserted into countryid field of table as countryid is FK moreOpen Question: Visual Web Developer Express - Data base error?
I am trying to set up a login form for a site which i am creating. Im taking a summer course at my school on how to do this easily. If you go to http://www.alpcentauri.info/asp-login.html the instructions for doing this are there. I have created all of the necessary pages and controls except the 'logout' control, but when i go into Web Developer, open my site and the ASP.Net configuration, then go to security i get the following error: Unable to connect to SQL Server database. When i edit this it says: Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. I have no idea what this means or how to fix it, Thanks i advance moreSql News
Sql Links
Dynamics GP Logistics and Barcode Add-ons notes
If you have Microsoft Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise, implemented in your organization and the next phase in your ERP and MRP developing is Logistics, Warehouse M... moreThe importance of dominios and hosting
The domain you choose for your website is just as important as the quality of the hosting and the website, so you should be careful when deciding on the domain name. Dominios are essential, because wh... moretotal information about dedicated sql hosting
Dedicated SQL Hosting is hosting type option for hosting database offered for various clients. Dedicated SQL Servers differ in their specs depending upon . sql database information can be ac... moreDynamics GP Warehouse Management and Barcode Solution Notes
Supply Chain Management automation, including Warehouse Management, Inventory Control with Batch Mode or Real Time Barcoding, Consignment, Shipping and Receiving, Trucks Scheduling, Rentals and Warran... moreMostly used programming languages and their programming advantages
Nowadays, world wide clients are demanding for cost effective solutions along with high-performance speedy development. In recent internet marketing arena, designing a good website template and placin... more�Know your SQL Repair Requirements
How do you elucidate the significance of MS SQL server in your organization? It is true that organizations that are using MS SQL server for years are still unable to answer this question. Probably... moreError 8936 in SQL Server
SQL Server supports b-tree indexes to give fast query results. The pages of B-tree indexes are referred as index nodes, with the top node called as root node. However, the middle nodes are termed as b... moreEcommerce Dynamics GP or Great Plains Solution Notes
There is no needs to reinvent the wheel or bicycle, in the sense that ecommerce web front out-of-the-box applications exists and you could easy to deploy Shopping Cart, Online Catalog, Credit Card Pay... moreDigital Asset Management Solution - Extensis Portfolio Server 9 Review
Extensis just released an upgraded version of their digital asset management server, more
Eight Reasons to Choose Windows VPS Hosting:
Virtual Private Server (VPS) or Virtual Dedicated Server (VDS) hosting is the type of web hosting in which one server is partitioned into several dedicated servers (virtual ... moreSQLGurus
Charla de sql mobile - Taken at 9:47 PM on August 24, 2006; cameraphone upload by ShoZu more