How to generate script from database with where clause

Question

1.00/5 (1 vote)

See more:

>Hello Sir

I have lots of data in to a table and do not want to generate whole data from table i want to generate only those data which is i need required

like

Select * Frin Table where Datayear='2016'

so please guide me how to do

beacuse if i generate whole table data then i get exception during generate script

What I have tried:

I Need Data so Please help Me i am trying to generate like right click on database
task ,then generate script like that

Posted 3-May-18 20:48pm

Member 12183079

Updated 3-May-18 21:54pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*dan!sh* · Answer 1 · 2018-05-03T21:56:00

There is nothing built-in in SQL server to generate such scripts. Reason being that the where clause would be different for each table of yours. You will need to write your own code to export partial data.

If you are looking for data after certain date, backups might help. If you take incremental back up, you will get all the data after the date of last full back up.