Question about Microsoft Business & Productivity Software

4 Answers

HOW TO SOLVE SQL QUERIES?

SQL QUERIES

Posted by on

4 Answers

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

Consider the following schema:
supplier(sid,sname,address)
parts(pid,pname,colour)
catalog(sid,pid,cost)

Posted on Jul 22, 2010

  • Rajib_eng_18 Feb 01, 2011

    hello

    4 cid_No, 4_Name

    ans: remark
    1
    2
    3
    4

×

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Greenhorn:

    A rookie expert who has answered 20 questions on their first day.

    Night Owl:

    An expert who has answered 10 or more questions between 12 midnight and 6am on the same day.

  • Contributor
  • 52 Answers

Use the Rank function:
http://msdn.microsoft.com/en-us/library/ms176102.aspx

Then select rows where rank =2

Posted on Oct 19, 2012

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Finding second highest salary

Posted on Apr 01, 2009

  • jagdishgowda Apr 01, 2009

    second highest salary

  • jagdishgowda Apr 01, 2009

    second highest salary

×

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Expert
  • 68 Answers

Komam,

well that depends on what you actuall want to do with your queries Komam.

Take a look here as this may well get you on the starting blocks.

http://www.w3schools.com/sql/sql_tryit.asp

Regards

ElApe

Posted on Sep 26, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I have Restaurant Pro Express by PC America - I have accumulated a database of customers, how do I export their contact info. (names, address, phone, email, etc) to a report like a .csv file or something...


You would need someone familiar with writing sql queries to extract the information from the database. You would also need to load a program such as sql management studio express. There is no export routine built into the program. I could do this for a price.

B Mattern
sysadmin@ccybernet.com
Please return and give me a favorable rating if this helps or is of value to you.

Feb 18, 2011 | Pc America Restaurant Pro Express

2 Answers

Which site is good for free download file for sql 2005 practical


Hi try PDF database.com
It's free for downloading.
A lot of user manuals and guide.

Feb 25, 2010 | Microsoft SQL Server 2005 Enterprise...

1 Answer

I don't remember my Server name ...thats why an error 53 of MICROSOFT SQL SERVER 2005 is being occured


As i had a problem of 53 in MS SQL server 2005....and i came to know my Server name by clicking on it Servertype that is given as Database Engine....so you could solve that solution too by doing this... This is a solution to the error 53..
.Actually, when you start your Sql server...it prompts you to enter the server name on "windows Authentication" and if server name is given by default,then its alright but if not, click on the given servertype i.e. Database Engine . By doing this, u could find ur Servername.

Jun 10, 2009 | Microsoft SQL Server Standard Edition for...

1 Answer

Sql queries for edit the tables dipendra


This is a generic Update(edit) statement in SQL:

UPDATE [tablename]
SET [columnname] = [new value]
WHERE [columnname] = [old value]

tablename = the name of the table you want to edit
columnname = name of column to be updated

Mar 15, 2009 | Microsoft Business & Productivity Software

2 Answers

Java.sql.SQLException: Network error IOException: Connection refused: connect


Hi,

I too was facing the same problem as mentioned by you and couldn't connect through telnet localhost 1433.
Solution : Just go to SQL server configuration manager----SQL Server Network configuration----Protocols for SQLEXPRESS and in that right click on TCP/IP and in properties field make all TCP/IP port to 1433 which is blank. Start and Restart the SQL server and you can telnet localhost 1433 and it works. Hope this will help.

Ghanshyam
gimatpune@hotmail.com

Aug 07, 2008 | Microsoft SQL Server 2000 Standard Edition...

4 Answers

Restoring files from the database


I suggest you use the Enterprise manager (gui tool to manage SQL).
Restoring a single table is not an option.
You can however restore a file or filegroup.
Make sure to backup before you start and NOT to restore database to its original name or original file location, to avoid acidents.
Normally you will have databases with only 2 files: the data at its Primary file group, and log file.
You may wish to create a new file group and move tables to the new group by recreating them there and exporting data from old table to new table. Then recreate indexes. This may prove to be complex as all tables and indexes have unique names and can't coexist with exact duplicate of them.

oh yea..... did I say backup?
well just in case backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup
but dont overwrite that backup

Feb 11, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Stored procedures


They are permanent procedures stored in the database that allow repeated execution of reusable SQL code. They are also compiled and stored in a cache repository to make their repeated execution more efficient.

The alternative to Stored Procedures is to use in-line queries "select * from table where field1 = value" hard-coded in your VB or C# application. This option though is less than ideal. Any change to the in-line query and you have to recompile the application.

The better way is to use a stored procedure, whose name doesn't change, and the parameters don't change. If the code has to change, then it's done in the stored procedure and recompiling the application isn't needed.

Oct 02, 2007 | Microsoft SQL Server Standard Edition for...

3 Answers

Viewing ms Sql Server database on Access


Are you familiar with "Linking" tables in Access? In Access: File --> Get External Data --> Link Tables. This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

4 Answers

Running SQL queries on Excel


Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

1,258 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...