How do I create a stored procedure in dbml?



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

Post New Answer

More SQL Server Interview Questions

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,


Define Check points and End Points?

1 Answers  


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?

1 Answers   ABC,


What is Replication?

1 Answers  


How does stuff differ from the replace function?

1 Answers  


What are synonyms?

1 Answers  


How can you get @@error and @@rowcount at the same time?

9 Answers  


How is sql server used?

1 Answers  


WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  


How to list all tables having unique constraints in any of the columns in a database.

1 Answers  


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.?

1 Answers  


How can we determine what objects a user-defined function depends upon?

1 Answers  


Categories