Re: MSSQL 2005 Stored Procedure?

Alexander Tretjakov wrote:
Sorry for my bad English.
Can somebody help me with MSSQL 2005 and stored procedure?

Something to start from.

require 'rubygems'
require 'dbi'

dbs = DBI.connect('DBI:ODBC:MYDB', 'usr', 'pwd')
dbs.execute("{call pr_appLogin(2, 'myid', 'mypwd')}")

I have to use this on an database where second login is required to
update database. pr_appLogin is the name of stored procedure on MSSQL
2005 server.


by
TheR
--
Posted via http://www.ruby-forum.com/.

.

Relevant Pages

  • MSSQL vs. SYBASE
    ... I am converting to MSSQL SERVER from SYBASE. ... by or called within a stored procedure. ... I can not find any type of callback ...
    (microsoft.public.sqlserver.programming)
  • Re: tool to write code which runs on the server
    ... VS.NET 2003 using MSSQL 2000? ... >> One solution is to write a Stored Procedure but the programming language ... >> to write a Stored Procedure but the programming language for Stored ... >> Order table with a OrderID as its primary and CustomerID as foreign key. ...
    (microsoft.public.sqlserver.programming)
  • Re: MSSQL Output Cursor Parameter
    ... property of a DataAdapter with the command for the stored procedure, ... > Oracle) or to SqlDbType.Variant > ... If it works with MSSQL too i won't need any> customization in my project. ... > If not i have to customize code like this:> ...
    (microsoft.public.dotnet.languages.csharp)
  • How to list atributes of all tables in Query Analyzer
    ... I need to know the properties of all tables in a given database on MSSQL ... I know that there is a stored procedure with the name "sp_MShelpcolumns" ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)