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)
How to check local and global angular versions
Use the command ng version (or ng v ) to find the version of Angular CLI in the current folder. Run it outside of the Angular project, to f...
-
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...
-
This error means you have created the DbContext but not configured/added it to the project using either DI in startup.cs or by using DbCon...
-
CONCLUSION : 1. Normally, use following two when you do not want query compilation also to come into picture. CHECKPOINT DBCC DROPCLEA...
No comments:
Post a Comment