create table rsc_check_constraint_test(
TimeToReach ID int IDENTITY(1,1) , nvarchar(10) CHECK ( LEN(TimeToReach) = 5 AND SUBSTRING(TimeToReach , 3,1) = ':' AND ISNUMERIC(SUBSTRING(TimeToReach, 1,2)) = 1 AND ISNUMERIC(SUBSTRING(TimeToReach, 4,2)) = 1 AND CONVERT(int , SUBSTRING(TimeToReach , 1,2)) > 5 AND CONVERT(int , SUBSTRING(TimeToReach , 1,2)) < 19 )
)
insert
select
drop table rsc_check_constraint_test
* from rsc_check_constraint_test rsc_check_constraint_test values ('19:14')
Subscribe to:
Post Comments (Atom)
using Microsoft.AspNetCore.Mvc; using System.Xml.Linq; using System.Xml.XPath; //<table class="common-table medium js-table js-stre...
-
Most of the google tutorials on keras do not show how to display a confusion matrix for the solution. A confusion matrix can throw a clear l...
-
Bootstrapping is the process of starting application in angular. The entry point for an angular application is index.html. Index.html loa...
-
http://www.sommarskog.se/share_data.html How to Share Data Between Stored Procedures An SQL text by Erland Sommarskog, SQL Server MVP. M...
No comments:
Post a Comment