sql server - Find all table names with column name? -

-

इस सवाल का पहले से ही एक उत्तर है: < / P>

  • 2 जवाब

    मैं सभी कैसे प्राप्त कर सकता हूँ तालिका नाम जहां दिए गए स्तंभ का नाम मौजूद है? मुझे एसक्यूएल सर्वर में "पसंद" वाले नाम चाहिए। उदाहरण के लिए: - 

      तालिका नाम चुनें जहां '% MyColumn%' जैसे कॉलमनाम '  
     कृपया मेरी मदद करें   
     < Div class = "post-text" itemprop = "text"> 
     कृपया नीचे की क्वेरी का प्रयास करें विवरण प्राप्त करने के लिए sys.column का उपयोग करें: -  
      का चयन करें c.name के रूप में colName, c.object_id = t.object_id पर sys.column c JOIN sys.tables t से तालिकानाम। '% MyCol%' जैसे सी। नाम

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

c++ - Qt::make_shared for creating QSharedPtr as std::make_shared for creating std::shared_ptr -

-
As stated in the Barjini Stroustrup's "A Tour of C ++", and a known C ++ 14 practice As such, someone should avoid the naked code in the new and delete . Provides std :: make_shared and std :: make_unique to create smart pointers to store allocated items in the standard library. However, it is not possible to use these routines for non-standard smart pointers, such as QT's own memory management model (with parent), but also smart pointer class like Provides QSharedPointer and QPointer (although later it is not actually a brochure indicator). My question is: Is not it convenient to create Qt analog of std :: make_shared ? To like it, QSharedPtr : Namespace Qt {template & lt; Class T, squares ... Args & gt; QSharedPointer & LT; T & gt; Make_shared (erg & amp; ... args) {return QSharedPointer & lt; T & gt; (New t (std :: forward & lt; ergos & gt; (args) ...)); }} or to create this, QPointer : named place ...
Read more