Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
1| Name | Data Type | Length | Description |
|---|---|---|---|
| @palabra | varchar | 50 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.obtener_sinonimos
@palabra varchar(50)
AS
BEGIN
SET NOCOUNT ON;
select
sin1,
sin2,
sin3,
sin4,
sin5,
sin6,
sin7,
sin8,
sin9,
sin10
from sinonimos where sin1 =@palabra
or sin2=@palabra
or sin3=@palabra
or sin4=@palabra
or sin5=@palabra
or sin6=@palabra
or sin7=@palabra
or sin8=@palabra
or sin9=@palabra
or sin10=@palabra
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.obtener_sinonimos
@palabra varchar(50)
AS
BEGIN
SET NOCOUNT ON;
select
sin1,
sin2,
sin3,
sin4,
sin5,
sin6,
sin7,
sin8,
sin9,
sin10
from sinonimos where sin1 =@palabra
or sin2=@palabra
or sin3=@palabra
or sin4=@palabra
or sin5=@palabra
or sin6=@palabra
or sin7=@palabra
or sin8=@palabra
or sin9=@palabra
or sin10=@palabra
END
GO
Depends On
1Used By
No items found