sql - How to enforce NOT NULL in a view's computed column -


मैं निम्नानुसार एक दृश्य बदलना चाहता हूं: 

  ALTER VIEW [dbo]। [ ViewOne] SELECT columnOne के रूप में, - नल कॉलम दो, - नल (कनवर्ट करें (दशमलव (2,0), कॉलमऑन) कॉलम के रूप में - मैं चाहता हूं कि यह DBOne से नहीं होना चाहिए। TablesOne

चूंकि कॉलमऑन "रिक्त नहीं है" मैं कॉलम को तीन को "नल नहीं" भी लागू करना चाहता हूं।

मैं बस सिंटैक्स को जानना चाहता हूं

अगर कास्ट का स्रोत स्वयं कभी भी अशक्त नहीं होता है तो

स्तंभ तीन कभी भी अशक्त नहीं होगा। हालांकि, इसका यह अर्थ नहीं है कि कॉलम एक को दशमलव (2,0) पर डाला नहीं जा सकता है और आपको नहीं पता कि क्या आपको अपवाद मिलेगा जब तक कि आप दृश्य के विरुद्ध क्वेरी नहीं करते। आपको यह निर्धारित करने के लिए एक अतिरिक्त चेक जोड़ने पर विचार करना चाहिए कि क्या कलाकार विफल हो जाएगा और कोई कलाकार त्रुटि की संभावना को कम करने में सहायता करेगा: 

  आल्टर दृश्य dbo.ViewOne के रूप में चयन करें कॉलम एक, कॉलम दो, केस जब isNumeric (ColumnOne) ) = 0 फिर 0 या फिर कास्ट (कॉलम के रूप में दशमलव के रूप में (2,0)) समापन के रूप में स्तंभ तीन

-

Comments

Post a Comment

Popular posts from this blog

google indexing -

I have a question, how can I get results of similar Google results like Wikipedia, MySpace ... When you search Wikipedia on Google, you have the result of an input search for Wikipedia, which is user-friendly. When you search MySpace on Google, you have Google results below, some links: login, register, sign up, search ... I actually do this on Google for my website Want a kind result? Thank you. itemprop = "text"> create a sitemap: Custom Search Engine Create: Thanks Google!
Read more

wpf - accessing a visual element in code -

I want to match the following xaml in the code, but I do not know how to capture that text block element: & lt; Local: Deaf TheWeekColumn ... & lt; Local: TheWeekColumn.Header & gt; & Lt; TextBlock Text = "{binding ...}, tooltip =" {binding ...} /> & Lt; / Local: DayOfTheWeekColumn.Header & gt; & Lt; / Local: DayOfTheWeekColumn & gt; The DayOfTheWeekColumn is a subclass of a DataGridTextColumn. I can easily get it on the header and set it to my content, and now I want to set the tooltip in the code, to find out how to do it in xaml above. Cheers, Berryl Edit ========= Even Code for DayOfTheWeekColumn is. XML is part of the text book headers' visual tree, and nothing else I want to put in XML. I want to put it in the tooltip, however, is in the code, so I can set it there. I am thinking that the column headers should have the property of a child, which I can use to find the text box, but the haven has not been found yet....
Read more

wpf controls - Trigger on Image inside a Button WPF -

I want to control the visibility of the image in a button through a trigger: & lt; Button x: name = "notespanel" command = "{binding adddocument}" & gt; & Lt; Image x: name = "notes image" source = "notes" "height =" 32 "& gt; & gt; & gt; & gt; button & gt; 1 / What trigger will appear in the button or in the container that faces the button? 2 / How to set the visibility of the image? Thanks Zone Since you are updating the image, it should lie with the image (style of image as part) such as if the image is by default Is hidden, so I try the following Using R can choose to make it visible with toggleproperty1. DataTrigger binding = "{binding toggleproperty}" value = "1" & gt; & lt ; Setter Property = "Visibility" value = "View" />
Read more