sql server - Powershell Function SQL Stored Procedure with Parameters -

-

प्राप्त त्रुटि "SqlParameterCollection केवल गैर-रिक्त SqlParameter प्रकार ऑब्जेक्ट स्वीकार करता है, नहीं SqlCommand ऑब्जेक्ट्स।" & Amp; "प्रक्रिया या कार्य 'usp__SingleUpdateServerBackupPath' पैरामीटर '@decServerName' की अपेक्षा करता है, जो कि आपूर्ति नहीं की गई थी।" PowerShell कोड: <सेट करें- StrictMode -Version 1.0 फ़ंक्शन अद्यतन-सर्वरबैकअपपथ {परम ([पैरामीटर (अनिवार्य = $ सही, ValueFromPipeLine = $ true)] [वस्तु []] $ इनपुटबैब BEGIN { $ कनेक्शन = नई-वस्तु -TypeName System.Data.SqlClient.SqlConnection $ connection.ConnectionString = "सर्वर = servername; डेटाबेस = डेटाबेस; trusted_connection = हाँ" $ connection.Open ()} प्रक्रिया {$ UpdateBackupPath = नई-वस्तु -TypeName System.Data.SqlClient.SqlCommand $ UpdateBackupPath.Connection = $ connection $ UpdateBackupPath.CommandText = "usp__SingleUpdateServerBackupPath" $ UpdateBackupPath.Commandtype = [System.Data.Commandtype] :: संग्रहित प्रसंस्करण $ ParamUpdateBackupPath = नया ऑब्जेक्ट -TypeName System.Data.SqlClient .SqlParameter $ ParamUpdateBackupPath.ParameterName = "@decBackupPath" $ ParamUpdateBackupPath.SqlDbType = [System.Data.SqlDbType] :: VarChar $ ParamUpdateBackupPath.Direction = [System.Data.ParameterDirection] :: इनपुट $ ParamUpdateBackupPath मान = $ inputobject.paths $ ParamUpdateBackupPathServerName = नया ऑब्जेक्ट -TypeName System.Data.SqlClient.SqlCommand $ ParamUpdateBackupPathServerName.ParameterName = "@DecServerName" $ ​​ParamUpdateBackupPathServerName.SqlDbType = [System.Data.SqlDbType] :: VarChar $ ParamUpdateBackupPathServerName। डायरेक्शन = [System.Data.ParameterDirection] :: इनपुट $ ParamUpdateBackupPathServerName.Value = $ inputobject.names $ UpdateBackupPath.Parameters.Add ($ ParamUpdateBackupPath) $ UpdateBackupPath.Parameters.Add ($ ParamUpdateBackupPathServerName) $ reader = New-Object -TypeName System.Data .SqlClient.SqlDataReader = $ UpdateBackupPath.ExecuteReader ()} अंत {$ connection.Close ()}}

एसक्यूएल प्रक्रिया: 

  प्रक्रिया usp__SingleUpdateServerBackupPath बनाएँ ( @decBackupPath varchar (50), @decServerName के रूप में varchar (50)) BCKP भीतर से अद्यतन BCKP सेट PTH = @decBackupPath रूप में शामिल होने SRVR पर SRVR.ID = BCKP.FK_SRVR कहां SRVR.NM = @decServerName   
 सीएसवी फ़ाइल स्वरूप  
  आयात-सीएसवी -पाथ सी: \ बिन \ रपो \ Backup.csv | C: \ Bin \ Scripts \ update-serverbackuppath.ps1 नाम पथ सर्वर 1 \\ fileshare \ server_name

पावरहेल कोड में कई वाक्यविन्यास त्रुटियां हैं, जैसे कि गलती से गलतियों को संदर्भित करना: 

  # गलत प्रपत्र [System.Data.Commandtype.StoredProcedure] # गणन का संदर्भ देने के लिए सही रूप [ System.Data.Commandtype] :: संग्रहित प्रसंस्करण

बाद में, एक अघोषित वस्तु है जिसके सदस्य विधि को कहा जाता है: 

  # $ आदेश सेट नहीं है , इसलिए ExecuteReader विधि उपलब्ध है $ reader = $ command.ExecuteReader ()

यह अत्यधिक शक्तिशेल में करने के लिए सिफारिश की है

संपादित करें

नवीनीकृत कोड के बाद, अब भी दो त्रुटियां हैं:

/ P> 

  # यह मतलब नहीं है चर SqlParameter होना चाहिए, नहीं SqlCommand $ ParamUpdateBackupPathServerName = नई ऑब्जेक्ट -TypeName System.Data.SqlClient.SqlCommand # ऐसा है: $ ParamUpdateBackupPathServerName = नया ऑब्जेक्ट -TypeName System.Data.SqlClient.SqlParameter # यह बकवास वाक्यविन्यास है $ पाठक = न्यू-वस्तु -TypeName System.Data.SqlClient.SqlDataReader = $ UpdateBackupPath.ExecuteReader () # इसलिए जैसा: $ पाठक = $ UpdateBackupPath.ExecuteReader ()

Comments

Post a Comment

Popular posts from this blog

Editing Python Class in Shell and SQLAlchemy -

-
I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla...
Read more

import - Python ImportError: No module named wmi -

-
I followed the instructions for downloading WMI for Python When I try to run the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = wmi.WMI (): if Raw_input ("restart% s?"% S.Caption) .upper () == "Y": s.StartService () I got the error traceback (most recent call end): file ". \", Line 1, edit: I am using Python 2.7.6 EDIT2: I am running 64-bit Windows 2008 R2, and I've downloaded WMI-1.4.9.zip (md5). I removed the content and put it in D: Python \ Tools \ Scripts I executed dragon setup.py.install I said D : \ Python \ tools \ scripts to% PATH% and when I execute the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = Wmi.WMI (): If raw_input ("Restart% s?"% S. Caption). () == "Y": s.StartService () error me Gets traceback (most recent call final): File ". See \", line 1, & lt; Modu...
Read more

uislider - In a MATLAB GUI, how does one implement a continuously varying slider from a GUIDE created .m file? -

-
I am trying to create a GUI with a plot and a slider. The slider should be described as continuously and output. I have a problem with this explanation that the uicontrol object is programmatically created, on the contrary, I want to know that in the last three instances, to complete the same thing done according to the program What can be added to a GUI file that is created. The code is down, and I have marked the (wrong) code that is provided by some of the above examples. Thanks a lot for any help! This slider function sets P1_slider_Callback (hObject, eventdata, handle) (handle, dragon, 'string', num2str (get (hObject, 'value'), 3)) PlottheData_Callback ( HOBject, EventData, Handle)% "PlotHeadata" is a button that creates the data slider based on the value of P1_slider%, and I think that here "p1_slider_CreateFcn" (hObject, eventdata, handle) needs to be assembled (HOBJECT, 'BackgroundRoller'), (0, 'Default UITTACKBACK MANDROLLE...
Read more