When I generate scripts in SQL Server 2008 Management Studio, it seems to insert the date/time in the script also.
For example:
USE [AdventureWorks]
GO
/****** Object: View [dbo].[vw_test] Script Date: 18/01/2017 3:27:10 PM ******/
SET ANSI_NULLS ON
GO
<rest of script goes here>
How can I remove that?
In Oracle there is a function (trunc) used to remove the time portion of a date. In order to do this with SQL Server, you need to use the convert function. Convert takes 3 parameters, the datatype to convert to, the value to convert, and an optional parameter for the formatting style.
Tools.. Options.. SQL Server Object Explorer..Scripting
Probably need to set "Include Descriptive Headers" = false
However, your question is unclear so this is a guess.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With