A community for students.
Here's the question you clicked on:
 0 viewing
anonymous
 one year ago
Have a quick question on SQL Server
anonymous
 one year ago
Have a quick question on SQL Server

This Question is Closed

anonymous
 one year ago
Best ResponseYou've already chosen the best response.0I have done some SQL Server. Alot more on larger DB's like Netezza, Oracle. Whats your question ?

anonymous
 one year ago
Best ResponseYou've already chosen the best response.0Alright Lets see how to word this. I am very new to SQL server but I have created a table that holds a customers Credit Limit and there balance. Is there a function way for me to show how much the customer is over their credit limit

anonymous
 one year ago
Best ResponseYou've already chosen the best response.0is there a function or a way*

anonymous
 one year ago
Best ResponseYou've already chosen the best response.0more of a way using SQL of course. So lets say the table is customer ( credit_limit int, balance int, customer_name varchar(50)). I would say select customer_name, balancecredit_limit as over_amount from customer where balance > credit_limit;

anonymous
 one year ago
Best ResponseYou've already chosen the best response.0we aren't using any database functions yet just some math functions and criteria to limit the rows from the table

anonymous
 one year ago
Best ResponseYou've already chosen the best response.0oh ok so SQL does have some math functions you can use though right?

anonymous
 one year ago
Best ResponseYou've already chosen the best response.0all databases have math functions. I use Netezza as a DBA and there are functions that are included. Sql Server has math functions as well. Most of the functions that DB's have are defined in the ANSI SQL standards. Most databases comply with those standards and make them accessible.
Ask your own question
Sign UpFind more explanations on OpenStudy
Your question is ready. Sign up for free to start getting answers.
spraguer
(Moderator)
5
→ View Detailed Profile
is replying to Can someone tell me what button the professor is hitting...
23
 Teamwork 19 Teammate
 Problem Solving 19 Hero
 Engagement 19 Mad Hatter
 You have blocked this person.
 ✔ You're a fan Checking fan status...
Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.