How do I create a stored procedure in dbml?
Answer / Anil Kumar Kumar
{"create_stored_procedure": [n {"name": "sp_MyStoredProcedure", "parameters": [n {"parameter_name": "@param1", "data_type": "int", "is_input": true}, n {"parameter_name": "@param2", "data_type": "varchar(50)", "is_output": true}n ]}, n {"sql_statement": "CREATE PROCEDURE sp_MyStoredProcedure @param1 int, @param2 varchar(50) AS SELECT Column1, Column2 FROM Table_Name WHERE Column3 = @param1"}n]}
| Is This Answer Correct ? | 0 Yes | 0 No |
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE
Define Check points and End Points?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is Replication?
How does stuff differ from the replace function?
What are synonyms?
How can you get @@error and @@rowcount at the same time?
How is sql server used?
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?
How to list all tables having unique constraints in any of the columns in a database.
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?
How can we determine what objects a user-defined function depends upon?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)