table data script file with date range

Question

Hi,

I need specific table data script file '.sql' file only specific date range (like insert into)
when i get it through database -> task -> generate script it give all table entries. but i need only specific date range.

note: i dont have admin rights

Thanks

Answer 1

Hi @kasim mohamed ,

If so, why did you not try the suggestion that I mentioned above. Select the data only specific date range , then insert the data into a new table, then you can get a table with the data that specific date range.

If my suggestion did not meet your requirement, please feel free to let me know.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Answer 2

but i need only specific date range.

There is no option in the script wizard to filter the data on certain condition; it always scipts all data.
You have to head out for other tools.

Answer 3

Hi @kasim mohamed ,

> when i get it through database -> task -> generate script it give all table entries. but i need only specific date range.

No, Generate script wizard could meet your requirement. It will script all data. It can choose the database object, but could do a condition filter as Olaf mentioned.

If you only want to get data between two dates from one table, you can try to using below T-SQL.

Select  * into table2 from dbo.Table1 where date BETWEEN '6/1/2021' AND '6/10/2021'  

Below is a test in my environment.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Answer 4

Thanks for your response

i dont want TSQL query.. i need insert statement with specific date range.

Thanks

Answer 5

Yes cathyji,
I have a date column