Solved

Save sql query result in sql server

Posted on 2016-11-10
15
41 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 48

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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 48

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
 
LVL 48

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 48

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 48

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

830 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