Question about Microsoft Computers & Internet

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

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 want to programaticaly modify an SQL statement in VB6


If I remember correctly you need to call ExecuteQuery or something similar otherwise it does not update the database.


Regards
GeWiz.

Jun 16, 2009 | Microsoft Visual Basic Enterprise Edition...

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 Computers & Internet

1 Answer

How to create a multiple access query and put altogether into 1 SQL Scrip(.sql file)


Suggest using Union Query. Thus, you can add more queries from many table and the output will be in one (1) query. Bear in mind that all fields must have same Field Name.

For example:
tblOne contains dtDate1 fieldname. Your query will select [tblOne].[dtDate1] As myDate.
tblTwo contains dtDate2 fieldname. Your query will have the following SQL:

Select [tblOne].[dtDate1] As myDate
UNION Select [tblTwo].[dtDate2] as myDate

Thus the output will result dates from tblOne and tblTwo in a column called myDate.

Regards,
Maha

Feb 05, 2009 | Microsoft Computers & Internet

1 Answer

I have installed sql-server management studio at Win-XP professional.. but it is while run this it is looking for LOCAL SERVER... but it is unable to find any local server at my system.... pls solve my...


First of all you need to be sure that when you installed sql server you also checked Database server. I assume you have.

Then you need to check if SQL is running.

You have to go to start and type services.msc in the search field.

then you have a list of services. go down to sql server and check if its running.

Now go to sql management studio and connect to your local server.

You also might have a instance name. like local server\sql express or an other name.

Jan 03, 2009 | Computers & Internet

1 Answer

I want to install SQL server2000 free!


you cant get sql server 2000 free, but you can get sql 2005 express edition free. http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en this is the link to download SQL 2005 express edition. This is same as SQL 2000 if you just want to work on queries.

Oct 19, 2008 | Microsoft MS SQL SERVER (810-01567-3-1)...

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?
Computers & Internet Logo

Related Topics:

1,261 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...