Solved

Save sql query result in sql server

Posted on 2016-11-10
15
23 Views
Last Modified: 2016-11-10
Hello,

Is there any way I can save a query and query results  in sql server.

Cheers
0
Comment
Question by:RIAS
  • 5
  • 5
  • 5
15 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 41882044
yes, there are ways ..
please provide specifics for your case
0
 

Author Comment

by:RIAS
ID: 41882047
Hi,

I have a query in acces which takes input from user.The user runs the query .  Similar thing in sql. Can view be done with parameter?
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41882048
You can save to text files. Queries will be .sql scripts and Result will be .rpt files.
In SQL Server Management Studio (SSMS) you can find the save option in the menu File or just press the Save icon in the toolbar.
For save the Results you just need to send the results to a file (CTRL+SHIFT+F). You can also find the respective icon in the toolbar or in the Menu Query / Results to.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41882052
I have a query in acces which takes input from user.
If you want something similar to MS Access queries then you don't have it in SQL Server. The more near you can have are the Views but then the user will need to run the View as a Select command:
SELECT *
FROM ViewName
WHERE Filter

Open in new window

So identically as they do for tables but using a View name instead of a table name.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 41882065
0
 

Author Comment

by:RIAS
ID: 41882067
Vitor,
Is there any way i can pass parameter to view ?

Cheers
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 41882069
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41882074
Is there any way i can pass parameter to view ?
No. In SQL Server, parameters are used by Stored Procedures and Functions.
You can always have a SP that runs a View with the WHERE clause being build dynamically depending on the parameter. I think that's the best option you have.
0
 

Author Closing Comment

by:RIAS
ID: 41882083
Cheers!
0
 

Author Comment

by:RIAS
ID: 41882084
Thank you all for helping me!
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 41882087
it was not clear that you are asking about Sql server view

actually you can pass parameter in  view  by using Dynamic query in Sql server
 but case is closed....
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41882092
actually you can pass parameter in  view  by using Dynamic query in Sql server
I don't think that's true. Can you give an example of passing a parameter to a View?

Dynamic query is what I suggested but inside a SP so parameters can be passed:
"You can always have a SP that runs a View with the WHERE clause being build dynamically depending on the parameter. "
1
 
LVL 42

Expert Comment

by:EugeneZ
ID: 41882133
yes, it is correct directly you can not assign parameter to view in sql

however, it is possible to do it using as you said procs or as I said dynamic queries via
 proc non prod such as Ad-hoc from some front end or another mechanism can be used
-----
something like this


declare  @strparam varchar(800)= 'somevalue'
declare  @sql varchar(8000)

set @sql= 'select * from your view where paramColumn =' + @strparam
Exec (@sql)
1
 

Author Comment

by:RIAS
ID: 41882147
How to write a view query or how to create a view and have a query in it ?

Example:
Select ref from Table1
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41882169
How to write a view query or how to create a view and have a query in it ?
See a View as an virtual table so you'll need first to create it with the CREATE VIEW command. This way the View will be stored in the SQL Server database.
Now with the View created you can abstract from it and use it as you use any other table so you can easily perform a SELECT * FROM ViewName and you can also add the WHERE clause. Just check one of your dynamic SQL solutions that we've been provided to you.
1

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now