API tools faq
paste
Advertisement
Guest User

KG

a guest
Oct 15th, 2018
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 93.95 KB | None | 0 0
raw download clone embed print report
  1. USE [net_temp_test]
  2. GO
  3. /****** Object:  StoredProcedure [kg].[LadeSubjektPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  4. DROP PROCEDURE [kg].[LadeSubjektPraefix]
  5. GO
  6. /****** Object:  StoredProcedure [kg].[LadeSubjekt]    Script Date: 10/15/2018 9:16:04 AM ******/
  7. DROP PROCEDURE [kg].[LadeSubjekt]
  8. GO
  9. /****** Object:  StoredProcedure [kg].[LadePraepositionPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  10. DROP PROCEDURE [kg].[LadePraepositionPraefix]
  11. GO
  12. /****** Object:  StoredProcedure [kg].[LadePraeposition]    Script Date: 10/15/2018 9:16:04 AM ******/
  13. DROP PROCEDURE [kg].[LadePraeposition]
  14. GO
  15. /****** Object:  StoredProcedure [kg].[LadePraedikatZusatz]    Script Date: 10/15/2018 9:16:04 AM ******/
  16. DROP PROCEDURE [kg].[LadePraedikatZusatz]
  17. GO
  18. /****** Object:  StoredProcedure [kg].[LadePraedikatPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  19. DROP PROCEDURE [kg].[LadePraedikatPraefix]
  20. GO
  21. /****** Object:  StoredProcedure [kg].[LadePraedikat]    Script Date: 10/15/2018 9:16:04 AM ******/
  22. DROP PROCEDURE [kg].[LadePraedikat]
  23. GO
  24. /****** Object:  StoredProcedure [kg].[LadeObjektPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  25. DROP PROCEDURE [kg].[LadeObjektPraefix]
  26. GO
  27. /****** Object:  StoredProcedure [kg].[LadeObjekt]    Script Date: 10/15/2018 9:16:04 AM ******/
  28. DROP PROCEDURE [kg].[LadeObjekt]
  29. GO
  30. /****** Object:  StoredProcedure [kg].[LadeKonjunktion]    Script Date: 10/15/2018 9:16:04 AM ******/
  31. DROP PROCEDURE [kg].[LadeKonjunktion]
  32. GO
  33. /****** Object:  StoredProcedure [kg].[LadeArtikelPronomen]    Script Date: 10/15/2018 9:16:04 AM ******/
  34. DROP PROCEDURE [kg].[LadeArtikelPronomen]
  35. GO
  36. /****** Object:  StoredProcedure [kg].[LadeAdjektivPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  37. DROP PROCEDURE [kg].[LadeAdjektivPraefix]
  38. GO
  39. /****** Object:  StoredProcedure [kg].[GeneriereTabelle]    Script Date: 10/15/2018 9:16:04 AM ******/
  40. DROP PROCEDURE [kg].[GeneriereTabelle]
  41. GO
  42. ALTER TABLE [kg].[Praeposition] DROP CONSTRAINT [DF_Praeposition_kannPraedikatPraefixSein]
  43. GO
  44. ALTER TABLE [kg].[ObjektEinzeln] DROP CONSTRAINT [DF__ObjektEin__kannP__2005291A]
  45. GO
  46. /****** Object:  Index [UQ_PraepositionPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  47. ALTER TABLE [kg].[PraepositionPraefix] DROP CONSTRAINT [UQ_PraepositionPraefix]
  48. GO
  49. /****** Object:  Index [UQ_PraedikatPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  50. ALTER TABLE [kg].[PraedikatPraefix] DROP CONSTRAINT [UQ_PraedikatPraefix]
  51. GO
  52. /****** Object:  Index [UQ_Praedikat]    Script Date: 10/15/2018 9:16:04 AM ******/
  53. ALTER TABLE [kg].[Praedikat] DROP CONSTRAINT [UQ_Praedikat]
  54. GO
  55. /****** Object:  Index [UQ_ObjektPräfix]    Script Date: 10/15/2018 9:16:04 AM ******/
  56. ALTER TABLE [kg].[ObjektPräfix] DROP CONSTRAINT [UQ_ObjektPräfix]
  57. GO
  58. /****** Object:  Index [UQ_ObjektEinzeln]    Script Date: 10/15/2018 9:16:04 AM ******/
  59. ALTER TABLE [kg].[ObjektEinzeln] DROP CONSTRAINT [UQ_ObjektEinzeln]
  60. GO
  61. /****** Object:  Index [UQ_Adjektiv]    Script Date: 10/15/2018 9:16:04 AM ******/
  62. ALTER TABLE [kg].[Adjektiv] DROP CONSTRAINT [UQ_Adjektiv]
  63. GO
  64. /****** Object:  Table [kg].[SubjektPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  65. DROP TABLE [kg].[SubjektPraefix]
  66. GO
  67. /****** Object:  Table [kg].[Pronomen]    Script Date: 10/15/2018 9:16:04 AM ******/
  68. DROP TABLE [kg].[Pronomen]
  69. GO
  70. /****** Object:  Table [kg].[PraepositionPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  71. DROP TABLE [kg].[PraepositionPraefix]
  72. GO
  73. /****** Object:  Table [kg].[Praeposition]    Script Date: 10/15/2018 9:16:04 AM ******/
  74. DROP TABLE [kg].[Praeposition]
  75. GO
  76. /****** Object:  Table [kg].[PraedikatZusatz]    Script Date: 10/15/2018 9:16:04 AM ******/
  77. DROP TABLE [kg].[PraedikatZusatz]
  78. GO
  79. /****** Object:  Table [kg].[PraedikatPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  80. DROP TABLE [kg].[PraedikatPraefix]
  81. GO
  82. /****** Object:  Table [kg].[Praedikat]    Script Date: 10/15/2018 9:16:04 AM ******/
  83. DROP TABLE [kg].[Praedikat]
  84. GO
  85. /****** Object:  Table [kg].[PluralErsatz]    Script Date: 10/15/2018 9:16:04 AM ******/
  86. DROP TABLE [kg].[PluralErsatz]
  87. GO
  88. /****** Object:  Table [kg].[ObjektPräfix]    Script Date: 10/15/2018 9:16:04 AM ******/
  89. DROP TABLE [kg].[ObjektPräfix]
  90. GO
  91. /****** Object:  Table [kg].[ObjektEinzeln]    Script Date: 10/15/2018 9:16:04 AM ******/
  92. DROP TABLE [kg].[ObjektEinzeln]
  93. GO
  94. /****** Object:  Table [kg].[Konjunktion]    Script Date: 10/15/2018 9:16:04 AM ******/
  95. DROP TABLE [kg].[Konjunktion]
  96. GO
  97. /****** Object:  Table [kg].[Artikel]    Script Date: 10/15/2018 9:16:04 AM ******/
  98. DROP TABLE [kg].[Artikel]
  99. GO
  100. /****** Object:  Table [kg].[Adjektiv]    Script Date: 10/15/2018 9:16:04 AM ******/
  101. DROP TABLE [kg].[Adjektiv]
  102. GO
  103. /****** Object:  Schema [kg]    Script Date: 10/15/2018 9:16:04 AM ******/
  104. DROP SCHEMA [kg]
  105. GO
  106. /****** Object:  Schema [kg]    Script Date: 10/15/2018 9:16:04 AM ******/
  107. CREATE SCHEMA [kg]
  108. GO
  109. /****** Object:  Table [kg].[Adjektiv]    Script Date: 10/15/2018 9:16:04 AM ******/
  110. SET ANSI_NULLS ON
  111. GO
  112. SET QUOTED_IDENTIFIER ON
  113. GO
  114. CREATE TABLE [kg].[Adjektiv](
  115.     [id] [int] IDENTITY(1,1) NOT NULL,
  116.     [wort] [nvarchar](255) NOT NULL,
  117.     [geschlecht] [char](1) NOT NULL,
  118.  CONSTRAINT [PK_Adjektiv] PRIMARY KEY CLUSTERED
  119. (
  120.     [id] ASC
  121. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  122. ) ON [PRIMARY]
  123. GO
  124. /****** Object:  Table [kg].[Artikel]    Script Date: 10/15/2018 9:16:04 AM ******/
  125. SET ANSI_NULLS ON
  126. GO
  127. SET QUOTED_IDENTIFIER ON
  128. GO
  129. CREATE TABLE [kg].[Artikel](
  130.     [id] [int] IDENTITY(1,1) NOT NULL,
  131.     [geschlecht] [char](1) NOT NULL,
  132.     [artikel] [nvarchar](255) NOT NULL,
  133.     [artikelAkkusativ] [nvarchar](255) NOT NULL,
  134.  CONSTRAINT [PK_Artikel] PRIMARY KEY CLUSTERED
  135. (
  136.     [id] ASC
  137. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  138. ) ON [PRIMARY]
  139. GO
  140. /****** Object:  Table [kg].[Konjunktion]    Script Date: 10/15/2018 9:16:04 AM ******/
  141. SET ANSI_NULLS ON
  142. GO
  143. SET QUOTED_IDENTIFIER ON
  144. GO
  145. CREATE TABLE [kg].[Konjunktion](
  146.     [id] [int] IDENTITY(1,1) NOT NULL,
  147.     [wort] [nvarchar](255) NOT NULL,
  148.  CONSTRAINT [PK_Konjunktion] PRIMARY KEY CLUSTERED
  149. (
  150.     [id] ASC
  151. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  152. ) ON [PRIMARY]
  153. GO
  154. /****** Object:  Table [kg].[ObjektEinzeln]    Script Date: 10/15/2018 9:16:04 AM ******/
  155. SET ANSI_NULLS ON
  156. GO
  157. SET QUOTED_IDENTIFIER ON
  158. GO
  159. CREATE TABLE [kg].[ObjektEinzeln](
  160.     [id] [int] IDENTITY(1,1) NOT NULL,
  161.     [wort] [nvarchar](255) NOT NULL,
  162.     [geschlecht] [char](1) NOT NULL,
  163.     [plural] [bit] NOT NULL,
  164.     [kaffee] [bit] NOT NULL,
  165.     [kannPraefix] [bit] NOT NULL,
  166.  CONSTRAINT [PK_ObjektEinzeln] PRIMARY KEY CLUSTERED
  167. (
  168.     [id] ASC
  169. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  170. ) ON [PRIMARY]
  171. GO
  172. /****** Object:  Table [kg].[ObjektPräfix]    Script Date: 10/15/2018 9:16:04 AM ******/
  173. SET ANSI_NULLS ON
  174. GO
  175. SET QUOTED_IDENTIFIER ON
  176. GO
  177. CREATE TABLE [kg].[ObjektPräfix](
  178.     [id] [int] IDENTITY(1,1) NOT NULL,
  179.     [wort] [nvarchar](255) NOT NULL,
  180.     [kaffee] [bit] NOT NULL,
  181.  CONSTRAINT [PK_ObjektPräfix] PRIMARY KEY CLUSTERED
  182. (
  183.     [id] ASC
  184. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  185. ) ON [PRIMARY]
  186. GO
  187. /****** Object:  Table [kg].[PluralErsatz]    Script Date: 10/15/2018 9:16:04 AM ******/
  188. SET ANSI_NULLS ON
  189. GO
  190. SET QUOTED_IDENTIFIER ON
  191. GO
  192. CREATE TABLE [kg].[PluralErsatz](
  193.     [id] [int] IDENTITY(1,1) NOT NULL,
  194.     [wort] [nvarchar](255) NOT NULL,
  195.  CONSTRAINT [PK_PluralErsatz] PRIMARY KEY CLUSTERED
  196. (
  197.     [id] ASC
  198. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  199. ) ON [PRIMARY]
  200. GO
  201. /****** Object:  Table [kg].[Praedikat]    Script Date: 10/15/2018 9:16:04 AM ******/
  202. SET ANSI_NULLS ON
  203. GO
  204. SET QUOTED_IDENTIFIER ON
  205. GO
  206. CREATE TABLE [kg].[Praedikat](
  207.     [id] [int] IDENTITY(1,1) NOT NULL,
  208.     [wort] [nvarchar](255) NOT NULL,
  209.  CONSTRAINT [PK_Praedikat] PRIMARY KEY CLUSTERED
  210. (
  211.     [id] ASC
  212. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  213. ) ON [PRIMARY]
  214. GO
  215. /****** Object:  Table [kg].[PraedikatPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  216. SET ANSI_NULLS ON
  217. GO
  218. SET QUOTED_IDENTIFIER ON
  219. GO
  220. CREATE TABLE [kg].[PraedikatPraefix](
  221.     [id] [int] IDENTITY(1,1) NOT NULL,
  222.     [wort] [nvarchar](255) NULL,
  223.  CONSTRAINT [PK_PraedikatPraefix] PRIMARY KEY CLUSTERED
  224. (
  225.     [id] ASC
  226. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  227. ) ON [PRIMARY]
  228. GO
  229. /****** Object:  Table [kg].[PraedikatZusatz]    Script Date: 10/15/2018 9:16:04 AM ******/
  230. SET ANSI_NULLS ON
  231. GO
  232. SET QUOTED_IDENTIFIER ON
  233. GO
  234. CREATE TABLE [kg].[PraedikatZusatz](
  235.     [id] [int] IDENTITY(1,1) NOT NULL,
  236.     [wort] [nvarchar](255) NULL,
  237.  CONSTRAINT [PK_PraedikatZusatz] PRIMARY KEY CLUSTERED
  238. (
  239.     [id] ASC
  240. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  241. ) ON [PRIMARY]
  242. GO
  243. /****** Object:  Table [kg].[Praeposition]    Script Date: 10/15/2018 9:16:04 AM ******/
  244. SET ANSI_NULLS ON
  245. GO
  246. SET QUOTED_IDENTIFIER ON
  247. GO
  248. CREATE TABLE [kg].[Praeposition](
  249.     [id] [int] IDENTITY(1,1) NOT NULL,
  250.     [wort] [nvarchar](255) NOT NULL,
  251.     [kannPraedikatPraefixSein] [bit] NOT NULL,
  252.  CONSTRAINT [PK_Praeposition] PRIMARY KEY CLUSTERED
  253. (
  254.     [id] ASC
  255. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  256. ) ON [PRIMARY]
  257. GO
  258. /****** Object:  Table [kg].[PraepositionPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  259. SET ANSI_NULLS ON
  260. GO
  261. SET QUOTED_IDENTIFIER ON
  262. GO
  263. CREATE TABLE [kg].[PraepositionPraefix](
  264.     [id] [int] IDENTITY(1,1) NOT NULL,
  265.     [wort] [nvarchar](255) NULL,
  266.  CONSTRAINT [PK_PraepositionPraefix] PRIMARY KEY CLUSTERED
  267. (
  268.     [id] ASC
  269. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  270. ) ON [PRIMARY]
  271. GO
  272. /****** Object:  Table [kg].[Pronomen]    Script Date: 10/15/2018 9:16:04 AM ******/
  273. SET ANSI_NULLS ON
  274. GO
  275. SET QUOTED_IDENTIFIER ON
  276. GO
  277. CREATE TABLE [kg].[Pronomen](
  278.     [id] [int] IDENTITY(1,1) NOT NULL,
  279.     [wort] [nvarchar](255) NOT NULL,
  280.     [geschlecht] [char](1) NOT NULL,
  281.     [kaffee] [bit] NOT NULL,
  282.  CONSTRAINT [PK_Pronomen] PRIMARY KEY CLUSTERED
  283. (
  284.     [id] ASC
  285. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  286. ) ON [PRIMARY]
  287. GO
  288. /****** Object:  Table [kg].[SubjektPraefix]    Script Date: 10/15/2018 9:16:04 AM ******/
  289. SET ANSI_NULLS ON
  290. GO
  291. SET QUOTED_IDENTIFIER ON
  292. GO
  293. CREATE TABLE [kg].[SubjektPraefix](
  294.     [id] [int] IDENTITY(1,1) NOT NULL,
  295.     [wort] [nvarchar](255) NULL,
  296.     [geschlecht] [char](1) NULL,
  297.  CONSTRAINT [PK_SubjektPraefix] PRIMARY KEY CLUSTERED
  298. (
  299.     [id] ASC
  300. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  301. ) ON [PRIMARY]
  302. GO
  303. SET IDENTITY_INSERT [kg].[Adjektiv] ON
  304.  
  305. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (1, N'modrigen', N'm')
  306. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (2, N'modrige', N'w')
  307. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (3, N'modriges', N'n')
  308. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (4, N'gediegenen', N'm')
  309. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (5, N'gediegene', N'w')
  310. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (6, N'gediegenes', N'n')
  311. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (9, N'schlaffen', N'm')
  312. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (10, N'schlaffe', N'w')
  313. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (13, N'braunen', N'm')
  314. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (14, N'braune', N'w')
  315. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (15, N'heißen', N'm')
  316. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (16, N'heiße', N'w')
  317. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (17, N'feuchten', N'm')
  318. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (18, N'feuchte', N'w')
  319. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (21, N'gemeinen', N'm')
  320. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (22, N'gemeine', N'w')
  321. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (23, N'dunklen', N'm')
  322. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (24, N'dunkle', N'w')
  323. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (25, N'armen', N'm')
  324. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (26, N'arme', N'w')
  325. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (28, N'schlaffes', N'n')
  326. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (30, N'braunes', N'n')
  327. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (31, N'heißes', N'n')
  328. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (32, N'feuchtes', N'n')
  329. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (34, N'gemeines', N'n')
  330. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (35, N'dunkles', N'n')
  331. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (36, N'armes', N'n')
  332. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (37, N'ahlen', N'm')
  333. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (38, N'ahle', N'w')
  334. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (39, N'ahles', N'n')
  335. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (40, N'ollen', N'm')
  336. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (41, N'olle', N'w')
  337. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (42, N'olles', N'n')
  338. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (46, N'schönen', N'm')
  339. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (47, N'schöne', N'w')
  340. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (48, N'schönes', N'n')
  341. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (49, N'ordentlichen', N'm')
  342. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (50, N'ordentliche', N'w')
  343. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (51, N'ordentliches', N'n')
  344. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (52, N'bitteren', N'm')
  345. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (53, N'bittere', N'w')
  346. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (54, N'bitteres', N'n')
  347. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (55, N'warmen', N'm')
  348. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (56, N'warme', N'w')
  349. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (57, N'warmes', N'n')
  350. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (58, N'schnuckeligen', N'm')
  351. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (59, N'schnuckelige', N'w')
  352. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (60, N'schnuckeliges', N'n')
  353. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (61, N'strammen', N'm')
  354. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (62, N'stramme', N'w')
  355. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (63, N'strammes', N'n')
  356. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (64, N'sahnigen', N'm')
  357. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (65, N'sahnige', N'w')
  358. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (66, N'sahniges', N'n')
  359. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (67, N'scharfen', N'm')
  360. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (68, N'scharfe', N'w')
  361. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (69, N'scharfes', N'n')
  362. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (70, N'aromatischen', N'm')
  363. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (71, N'aromatische', N'w')
  364. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (72, N'aromatisches', N'n')
  365. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (73, N'stabilen', N'm')
  366. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (74, N'stabile', N'w')
  367. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (75, N'stabiles', N'n')
  368. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (76, N'professionellen', N'm')
  369. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (77, N'professionelle', N'w')
  370. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (78, N'professionelles', N'n')
  371. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (79, N'trockenen', N'm')
  372. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (80, N'trockene', N'w')
  373. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (81, N'trockenes', N'n')
  374. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (82, N'rauen', N'm')
  375. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (83, N'raue', N'w')
  376. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (84, N'raues', N'n')
  377. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (85, N'schonenden', N'm')
  378. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (86, N'schonende', N'w')
  379. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (87, N'schonendes', N'n')
  380. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (88, N'erhärteten', N'm')
  381. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (89, N'erhärtete', N'w')
  382. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (90, N'erhärtetes', N'n')
  383. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (91, N'feurigen', N'm')
  384. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (92, N'feurige', N'w')
  385. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (93, N'feuriges', N'n')
  386. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (94, N'glühenden', N'm')
  387. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (95, N'glühende', N'w')
  388. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (96, N'glühendes', N'n')
  389. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (101, N'kernigen', N'm')
  390. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (102, N'kernige', N'w')
  391. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (103, N'kerniges', N'n')
  392. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (104, N'knatschigen', N'm')
  393. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (105, N'knatschige', N'w')
  394. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (106, N'knatschiges', N'n')
  395. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (107, N'nussigen', N'm')
  396. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (108, N'nussige', N'w')
  397. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (109, N'nussiges', N'n')
  398. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (110, N'holzigen', N'm')
  399. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (111, N'holzige', N'w')
  400. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (112, N'holziges', N'n')
  401. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (113, N'lieblichen', N'm')
  402. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (114, N'liebliche', N'w')
  403. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (115, N'liebliches', N'n')
  404. GO
  405. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (116, N'körnigen', N'm')
  406. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (117, N'körnige', N'w')
  407. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (118, N'körniges', N'n')
  408. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (119, N'feinen', N'm')
  409. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (120, N'feine', N'w')
  410. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (121, N'feines', N'n')
  411. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (122, N'doppelten', N'm')
  412. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (123, N'doppelte', N'w')
  413. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (124, N'doppeltes', N'n')
  414. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (125, N'dreifachen', N'm')
  415. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (126, N'dreifache', N'w')
  416. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (127, N'dreifaches', N'n')
  417. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (128, N'ruppigen', N'm')
  418. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (129, N'ruppige', N'w')
  419. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (130, N'ruppiges', N'n')
  420. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (131, N'besonderen', N'm')
  421. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (132, N'besondere', N'w')
  422. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (133, N'besonderes', N'n')
  423. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (134, N'naturtrüben', N'm')
  424. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (135, N'naturtrübe', N'w')
  425. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (136, N'naturtrübes', N'n')
  426. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (137, N'angenehmen', N'm')
  427. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (138, N'angenehme', N'w')
  428. INSERT [kg].[Adjektiv] ([id], [wort], [geschlecht]) VALUES (139, N'angenehmes', N'n')
  429. SET IDENTITY_INSERT [kg].[Adjektiv] OFF
  430. SET IDENTITY_INSERT [kg].[Artikel] ON
  431.  
  432. INSERT [kg].[Artikel] ([id], [geschlecht], [artikel], [artikelAkkusativ]) VALUES (1, N'm', N'der', N'den')
  433. INSERT [kg].[Artikel] ([id], [geschlecht], [artikel], [artikelAkkusativ]) VALUES (2, N'w', N'die', N'die')
  434. INSERT [kg].[Artikel] ([id], [geschlecht], [artikel], [artikelAkkusativ]) VALUES (3, N'n', N'das', N'das')
  435. SET IDENTITY_INSERT [kg].[Artikel] OFF
  436. SET IDENTITY_INSERT [kg].[Konjunktion] ON
  437.  
  438. INSERT [kg].[Konjunktion] ([id], [wort]) VALUES (1, N'und')
  439. INSERT [kg].[Konjunktion] ([id], [wort]) VALUES (2, N'oder')
  440. SET IDENTITY_INSERT [kg].[Konjunktion] OFF
  441. SET IDENTITY_INSERT [kg].[ObjektEinzeln] ON
  442.  
  443. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (1, N'Gesicht', N'n', 0, 0, 1)
  444. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (2, N'Nocken', N'w', 1, 0, 1)
  445. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (3, N'Pumpe', N'w', 0, 0, 1)
  446. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (4, N'Nut', N'w', 0, 0, 1)
  447. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (5, N'Geifer', N'm', 0, 1, 1)
  448. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (6, N'Tee', N'm', 0, 1, 1)
  449. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (7, N'Mörtel', N'm', 0, 1, 1)
  450. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (8, N'Suppe', N'w', 0, 1, 1)
  451. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (9, N'Schiss', N'm', 0, 1, 1)
  452. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (10, N'Fresse', N'w', 0, 0, 1)
  453. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (11, N'Humpen', N'm', 0, 1, 1)
  454. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (13, N'Mund', N'm', 0, 0, 1)
  455. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (14, N'Löffel', N'm', 1, 0, 1)
  456. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (15, N'Fratze', N'w', 0, 0, 1)
  457. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (16, N'Thomas', N'm', 0, 1, 1)
  458. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (17, N'Tyrone', N'm', 0, 1, 1)
  459. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (18, N'Larry', N'm', 0, 1, 1)
  460. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (21, N'Otto', N'm', 0, 1, 1)
  461. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (22, N'Fuge', N'w', 0, 0, 1)
  462. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (23, N'Henry', N'm', 0, 1, 1)
  463. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (24, N'Jason', N'm', 0, 1, 1)
  464. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (25, N'Lippen', N'w', 1, 0, 1)
  465. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (26, N'Teilchen', N'n', 0, 1, 1)
  466. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (27, N'Zahnfleisch', N'n', 0, 0, 0)
  467. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (28, N'Schnäuzchen', N'n', 0, 0, 1)
  468. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (29, N'Kolben', N'm', 0, 0, 1)
  469. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (31, N'Revers', N'n', 0, 0, 1)
  470. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (32, N'Milch', N'w', 0, 1, 1)
  471. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (33, N'Achilles', N'm', 0, 0, 1)
  472. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (34, N'Schlamm', N'm', 0, 1, 1)
  473. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (35, N'Zunge', N'w', 0, 0, 1)
  474. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (36, N'Rosette', N'w', 0, 0, 1)
  475. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (37, N'Hannes', N'm', 0, 1, 1)
  476. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (39, N'Schutt', N'm', 0, 1, 1)
  477. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (40, N'Drescher', N'm', 0, 0, 1)
  478. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (41, N'Pampe', N'w', 0, 1, 1)
  479. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (42, N'Fugen', N'w', 1, 0, 1)
  480. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (44, N'Spalte', N'w', 0, 0, 1)
  481. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (45, N'Dünnpfiff', N'm', 0, 1, 0)
  482. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (46, N'Zahnlücke', N'w', 0, 0, 0)
  483. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (48, N'Freund', N'm', 0, 1, 1)
  484. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (49, N'Leiste', N'w', 0, 0, 1)
  485. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (50, N'Ausschuss', N'm', 0, 1, 1)
  486. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (51, N'Kaffeesatz', N'm', 0, 1, 0)
  487. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (53, N'Brett', N'n', 0, 0, 1)
  488. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (54, N'Schmodder', N'm', 0, 1, 1)
  489. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (55, N'Lappen', N'm', 0, 0, 1)
  490. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (57, N'Backen', N'w', 1, 0, 1)
  491. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (58, N'Tunnel', N'm', 0, 0, 1)
  492. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (59, N'Dung', N'm', 0, 1, 1)
  493. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (60, N'Schlund', N'm', 0, 0, 1)
  494. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (61, N'Schlumpi', N'm', 0, 1, 1)
  495. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (63, N'Loch', N'n', 0, 0, 1)
  496. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (64, N'Bumsberger Fickquell', N'm', 0, 1, 0)
  497. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (66, N'Malte', N'm', 0, 1, 1)
  498. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (67, N'Gamaschen', N'w', 1, 0, 1)
  499. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (68, N'Poppenhäusener Sexbrause', N'w', 0, 1, 0)
  500. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (71, N'Mauernutfräse', N'w', 0, 0, 0)
  501. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (72, N'Schlitz', N'm', 0, 0, 1)
  502. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (73, N'Nebel', N'm', 0, 1, 1)
  503. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (74, N'Bengel', N'm', 0, 1, 1)
  504. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (75, N'Metin', N'm', 0, 1, 1)
  505. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (76, N'Klappe', N'w', 0, 0, 1)
  506. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (77, N'Wiegald', N'm', 0, 1, 1)
  507. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (78, N'Melone', N'w', 0, 0, 1)
  508. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (79, N'Ralle', N'm', 0, 1, 1)
  509. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (80, N'Daniel', N'm', 0, 1, 1)
  510. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (81, N'Roland', N'm', 0, 1, 1)
  511. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (82, N'Dennis', N'm', 0, 1, 1)
  512. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (83, N'Wasser', N'n', 0, 1, 1)
  513. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (84, N'Brillenkitt', N'm', 0, 0, 0)
  514. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (85, N'Putzer', N'm', 0, 1, 1)
  515. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (86, N'Mumpeln', N'w', 1, 1, 1)
  516. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (87, N'Zinken', N'm', 1, 0, 1)
  517. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (88, N'Matsch', N'm', 0, 1, 1)
  518. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (89, N'Luke', N'w', 0, 0, 1)
  519. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (90, N'Maul', N'n', 0, 0, 1)
  520. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (91, N'Bohnen', N'w', 1, 1, 1)
  521. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (92, N'Knecht', N'm', 0, 1, 1)
  522. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (93, N'Brikett', N'n', 0, 1, 1)
  523. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (94, N'Klabusterbeeren', N'w', 1, 1, 0)
  524. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (95, N'Bonbon', N'n', 0, 1, 1)
  525. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (96, N'Tinte', N'w', 0, 1, 1)
  526. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (97, N'Schlacke', N'w', 0, 1, 1)
  527. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (98, N'Vorhaut', N'w', 0, 0, 1)
  528. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (99, N'Bohne', N'w', 0, 1, 1)
  529. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (100, N'Rohr', N'n', 0, 0, 1)
  530. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (101, N'Gehäuse', N'n', 0, 0, 1)
  531. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (102, N'Kabine', N'w', 0, 0, 1)
  532. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (103, N'Rutsche', N'w', 0, 0, 1)
  533. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (104, N'Schmeichler', N'm', 0, 1, 1)
  534. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (105, N'Schoppen', N'm', 0, 1, 1)
  535. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (106, N'Stutzen', N'm', 0, 0, 1)
  536. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (107, N'Jauche', N'w', 0, 1, 1)
  537. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (108, N'Arsch', N'm', 0, 0, 1)
  538. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (110, N'Richard', N'm', 0, 1, 1)
  539. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (111, N'Volumen', N'n', 0, 0, 1)
  540. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (112, N'Schöpfer', N'm', 0, 0, 1)
  541. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (113, N'Baskenmütze', N'w', 0, 0, 0)
  542. GO
  543. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (115, N'Sahne', N'w', 0, 1, 1)
  544. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (116, N'Zehen', N'w', 1, 0, 1)
  545. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (117, N'Ranzen', N'm', 0, 0, 1)
  546. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (118, N'Nagelbett', N'n', 0, 0, 0)
  547. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (121, N'Fundament', N'n', 0, 0, 1)
  548. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (122, N'Kante', N'w', 0, 0, 1)
  549. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (123, N'Puller', N'm', 0, 0, 1)
  550. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (124, N'Schmand', N'm', 0, 1, 1)
  551. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (125, N'Gefühle', N'w', 1, 0, 1)
  552. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (126, N'Thorsten', N'm', 0, 1, 1)
  553. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (127, N'Elch', N'm', 0, 1, 1)
  554. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (128, N'Matthias', N'm', 0, 1, 1)
  555. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (129, N'Ron', N'm', 0, 1, 1)
  556. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (130, N'Sieglinde', N'w', 0, 1, 1)
  557. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (131, N'Matze', N'm', 0, 1, 1)
  558. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (133, N'Ronnie', N'm', 0, 1, 1)
  559. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (134, N'Patschen', N'm', 1, 0, 1)
  560. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (135, N'Latschen', N'm', 1, 0, 1)
  561. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (136, N'Socken', N'm', 1, 0, 1)
  562. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (137, N'Schocken', N'm', 1, 0, 1)
  563. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (138, N'Mauken', N'w', 1, 0, 1)
  564. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (139, N'Stiefel', N'm', 0, 0, 1)
  565. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (141, N'Schuhe', N'm', 1, 0, 1)
  566. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (142, N'Stiefel', N'm', 1, 0, 1)
  567. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (143, N'Spitze', N'w', 0, 0, 1)
  568. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (144, N'Glatze', N'w', 0, 0, 1)
  569. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (145, N'Treter', N'm', 1, 0, 1)
  570. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (146, N'Brause', N'w', 0, 1, 1)
  571. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (147, N'Naht', N'w', 0, 0, 1)
  572. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (148, N'Kiefer', N'm', 0, 0, 1)
  573. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (149, N'Rüssel', N'm', 0, 0, 1)
  574. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (151, N'Prengel', N'm', 0, 0, 1)
  575. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (152, N'Urin', N'm', 0, 1, 1)
  576. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (153, N'Kimme', N'w', 0, 0, 1)
  577. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (155, N'Hoden', N'm', 0, 0, 1)
  578. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (156, N'Euter', N'm', 0, 0, 1)
  579. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (157, N'Klöte', N'w', 0, 0, 1)
  580. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (158, N'Helm', N'm', 0, 0, 0)
  581. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (159, N'Saft', N'm', 0, 1, 1)
  582. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (160, N'Locke', N'w', 0, 0, 1)
  583. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (161, N'Droge', N'w', 0, 1, 1)
  584. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (162, N'Drogen', N'w', 1, 1, 1)
  585. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (163, N'Säure', N'w', 0, 1, 1)
  586. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (164, N'Lauge', N'w', 0, 1, 1)
  587. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (166, N'Wacker', N'm', 0, 0, 1)
  588. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (167, N'Knorpel', N'm', 0, 0, 1)
  589. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (168, N'Bein', N'n', 0, 0, 1)
  590. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (169, N'Eiter', N'm', 0, 1, 1)
  591. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (170, N'Kotze', N'w', 0, 1, 1)
  592. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (171, N'Galle', N'w', 0, 1, 1)
  593. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (172, N'Pfropfen', N'm', 0, 0, 1)
  594. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (173, N'Pisse', N'w', 0, 1, 1)
  595. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (174, N'Hausschuh', N'm', 0, 0, 0)
  596. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (175, N'Knopfloch', N'n', 0, 0, 0)
  597. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (176, N'Hutschnur', N'w', 0, 0, 0)
  598. INSERT [kg].[ObjektEinzeln] ([id], [wort], [geschlecht], [plural], [kaffee], [kannPraefix]) VALUES (177, N'Hemd', N'n', 0, 0, 0)
  599. SET IDENTITY_INSERT [kg].[ObjektEinzeln] OFF
  600. SET IDENTITY_INSERT [kg].[ObjektPräfix] ON
  601.  
  602. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (123, N'Adrenalin', 1)
  603. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (67, N'Ansaug', 0)
  604. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (58, N'Anus', 1)
  605. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (7, N'Arsch', 1)
  606. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (8, N'Arschbohnen', 1)
  607. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (1, N'Beiß', 0)
  608. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (73, N'Beutel', 1)
  609. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (21, N'Böller', 1)
  610. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (76, N'Braun', 1)
  611. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (47, N'Brenn', 1)
  612. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (60, N'Brüh', 1)
  613. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (114, N'Büffel', 1)
  614. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (10, N'Dreck', 1)
  615. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (66, N'Dunkel', 1)
  616. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (28, N'Dünn', 1)
  617. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (44, N'Dünnbett', 1)
  618. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (130, N'Eiter', 0)
  619. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (131, N'Eiter', 1)
  620. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (61, N'Fall', 0)
  621. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (68, N'Ferkel', 0)
  622. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (38, N'Fick', 0)
  623. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (37, N'Fick', 1)
  624. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (11, N'Flatter', 1)
  625. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (31, N'Flüssig', 1)
  626. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (22, N'Front', 0)
  627. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (65, N'Gaumen', 0)
  628. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (52, N'Gaumen', 1)
  629. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (100, N'Genieß', 0)
  630. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (99, N'Genieß', 1)
  631. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (4, N'Gesichts', 0)
  632. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (16, N'Gieß', 1)
  633. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (64, N'Hals', 0)
  634. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (13, N'Hals', 1)
  635. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (70, N'Hebel', 1)
  636. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (75, N'Hitze', 1)
  637. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (78, N'Kack', 1)
  638. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (30, N'Kau', 0)
  639. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (26, N'Kipp', 1)
  640. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (104, N'Klemm', 0)
  641. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (105, N'Klemm', 1)
  642. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (23, N'Knall', 1)
  643. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (96, N'Knet', 0)
  644. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (93, N'Knet', 1)
  645. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (127, N'Knorpel', 0)
  646. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (128, N'Knorpel', 1)
  647. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (33, N'Koffein', 1)
  648. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (27, N'Kopf', 0)
  649. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (120, N'Kopf', 1)
  650. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (12, N'Kot', 1)
  651. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (57, N'Lehm', 1)
  652. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (42, N'Lutsch', 0)
  653. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (41, N'Lutsch', 1)
  654. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (20, N'Moor', 1)
  655. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (124, N'Nitroglycerin', 1)
  656. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (32, N'Nocken', 0)
  657. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (84, N'Peitschen', 0)
  658. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (85, N'Peitschen', 1)
  659. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (56, N'Rachen', 1)
  660. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (74, N'Radau', 1)
  661. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (90, N'Raketen', 1)
  662. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (117, N'Ramm', 0)
  663. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (92, N'Ramm', 1)
  664. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (112, N'Rammel', 0)
  665. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (109, N'Reiß', 0)
  666. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (108, N'Reiß', 1)
  667. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (18, N'Riech', 0)
  668. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (59, N'Röst', 1)
  669. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (110, N'Rupp', 1)
  670. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (106, N'Rüssel', 0)
  671. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (107, N'Rüssel', 1)
  672. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (87, N'Rüter', 0)
  673. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (86, N'Rüter', 1)
  674. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (39, N'Sack', 0)
  675. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (40, N'Sack', 1)
  676. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (121, N'Saft', 1)
  677. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (17, N'Sahne', 1)
  678. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (36, N'Sau', 0)
  679. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (49, N'Sauf', 0)
  680. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (48, N'Sauf', 1)
  681. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (98, N'Saug', 0)
  682. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (97, N'Saug', 1)
  683. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (77, N'Schand', 0)
  684. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (129, N'Schien', 0)
  685. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (132, N'Schimmel', 0)
  686. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (133, N'Schimmel', 1)
  687. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (15, N'Schlabber', 0)
  688. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (34, N'Schluck', 0)
  689. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (35, N'Schluck', 1)
  690. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (125, N'Schmalz', 0)
  691. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (122, N'Schmalz', 1)
  692. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (83, N'Schmand', 0)
  693. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (82, N'Schmand', 1)
  694. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (55, N'Schmeck', 1)
  695. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (25, N'Schmier', 1)
  696. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (19, N'Schnabulier', 0)
  697. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (2, N'Schnecken', 0)
  698. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (3, N'Schnecken', 1)
  699. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (14, N'Schütt', 1)
  700. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (111, N'Schweine', 0)
  701. GO
  702. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (126, N'Spachtel', 1)
  703. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (89, N'Spalt', 0)
  704. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (88, N'Spalt', 1)
  705. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (69, N'Spann', 0)
  706. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (9, N'Spiralanker', 1)
  707. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (43, N'Spreng', 1)
  708. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (53, N'Spritz', 1)
  709. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (46, N'Sprüh', 1)
  710. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (51, N'Stämm', 1)
  711. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (103, N'Stech', 0)
  712. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (102, N'Stech', 1)
  713. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (72, N'Steif', 1)
  714. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (45, N'Stoß', 0)
  715. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (80, N'Streichel', 1)
  716. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (29, N'Torf', 1)
  717. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (135, N'Verbrecher', 0)
  718. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (71, N'Verdau', 0)
  719. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (24, N'Vorder', 0)
  720. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (50, N'Wangen', 1)
  721. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (6, N'Zecken', 0)
  722. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (5, N'Zecken', 1)
  723. INSERT [kg].[ObjektPräfix] ([id], [wort], [kaffee]) VALUES (54, N'Zieh', 1)
  724. SET IDENTITY_INSERT [kg].[ObjektPräfix] OFF
  725. SET IDENTITY_INSERT [kg].[PluralErsatz] ON
  726.  
  727. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (1, N'die')
  728. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (2, N'unsere')
  729. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (4, N'2')
  730. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (5, N'10')
  731. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (6, N'ein paar')
  732. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (7, N'mehrere')
  733. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (8, N'viele')
  734. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (11, N'''nen paar')
  735. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (12, N'einige')
  736. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (13, N'sämtliche')
  737. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (14, N'hundert')
  738. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (15, N'tausend')
  739. INSERT [kg].[PluralErsatz] ([id], [wort]) VALUES (16, N'dutzende')
  740. SET IDENTITY_INSERT [kg].[PluralErsatz] OFF
  741. SET IDENTITY_INSERT [kg].[Praedikat] ON
  742.  
  743. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (143, N'arbeiten')
  744. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (86, N'atmen')
  745. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (119, N'baldowern')
  746. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (123, N'ballern')
  747. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (46, N'balsamieren')
  748. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (161, N'beschleunigen')
  749. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (57, N'blasen')
  750. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (99, N'bollern')
  751. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (81, N'böllern')
  752. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (103, N'bolzen')
  753. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (113, N'bonern')
  754. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (151, N'boxen')
  755. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (82, N'brechen')
  756. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (97, N'brennen')
  757. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (15, N'brettern')
  758. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (116, N'donnern')
  759. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (94, N'drehen')
  760. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (50, N'fetzen')
  761. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (163, N'feuchten')
  762. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (28, N'feuern')
  763. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (83, N'ficken')
  764. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (1, N'flanschen')
  765. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (121, N'fließen')
  766. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (45, N'flitschen')
  767. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (90, N'gatzen')
  768. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (24, N'geben')
  769. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (30, N'geifern')
  770. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (32, N'gelen')
  771. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (105, N'genießen')
  772. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (40, N'gleiten')
  773. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (44, N'gurgeln')
  774. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (149, N'gurten')
  775. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (159, N'hacken')
  776. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (137, N'hämmern')
  777. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (11, N'hebeln')
  778. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (101, N'hechten')
  779. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (14, N'hiefen')
  780. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (70, N'hinkeln')
  781. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (106, N'hobeln')
  782. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (158, N'initiieren')
  783. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (7, N'jagen')
  784. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (53, N'jubeln')
  785. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (12, N'kanten')
  786. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (42, N'kärchern')
  787. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (107, N'kegeln')
  788. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (49, N'kippen')
  789. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (165, N'klampfen')
  790. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (17, N'klauen')
  791. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (64, N'kleben')
  792. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (38, N'kleistern')
  793. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (110, N'klemmen')
  794. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (157, N'klopfen')
  795. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (67, N'kloppen')
  796. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (54, N'knebeln')
  797. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (72, N'knerbeln')
  798. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (61, N'kneten')
  799. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (125, N'knibbeln')
  800. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (95, N'kniften')
  801. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (96, N'knüppeln')
  802. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (19, N'kredenzen')
  803. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (74, N'kuppeln')
  804. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (6, N'löten')
  805. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (39, N'lutschen')
  806. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (145, N'meißeln')
  807. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (111, N'metern')
  808. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (132, N'mischen')
  809. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (36, N'möbeln')
  810. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (144, N'mörteln')
  811. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (3, N'muffen')
  812. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (98, N'mülmen')
  813. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (63, N'nageln')
  814. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (18, N'paffen')
  815. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (29, N'peitschen')
  816. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (88, N'pempeln')
  817. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (31, N'pfeffern')
  818. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (139, N'pflastern')
  819. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (89, N'pläddern')
  820. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (2, N'plätschern')
  821. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (35, N'pökeln')
  822. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (112, N'polieren')
  823. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (136, N'poltern')
  824. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (167, N'preschen')
  825. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (8, N'pressen')
  826. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (41, N'pullern')
  827. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (62, N'pumpen')
  828. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (131, N'putzen')
  829. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (33, N'qualmen')
  830. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (66, N'rammeln')
  831. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (162, N'rammen')
  832. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (129, N'rangieren')
  833. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (55, N'reiben')
  834. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (153, N'richten')
  835. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (91, N'rotzen')
  836. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (65, N'rütern')
  837. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (108, N'sägen')
  838. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (47, N'saubeuteln')
  839. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (9, N'saufen')
  840. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (5, N'saugen')
  841. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (78, N'sausen')
  842. GO
  843. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (160, N'schalten')
  844. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (92, N'scheißen')
  845. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (168, N'scheppern')
  846. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (25, N'scheuern')
  847. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (23, N'schieben')
  848. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (37, N'schießen')
  849. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (102, N'schlagen')
  850. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (26, N'schlucken')
  851. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (100, N'schlunzen')
  852. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (80, N'schmatzen')
  853. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (109, N'schmeißen')
  854. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (124, N'schmettern')
  855. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (34, N'schmieren')
  856. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (87, N'schmirgeln')
  857. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (126, N'schnabulieren')
  858. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (146, N'schnallen')
  859. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (118, N'schnucken')
  860. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (27, N'schnullern')
  861. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (73, N'schrauben')
  862. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (142, N'schruppen')
  863. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (85, N'schubsen')
  864. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (134, N'schütteln')
  865. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (16, N'schütten')
  866. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (58, N'spachteln')
  867. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (69, N'spannen')
  868. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (10, N'spaxen')
  869. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (60, N'sprengen')
  870. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (43, N'sprenkeln')
  871. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (114, N'sprühen')
  872. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (21, N'spülen')
  873. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (51, N'stämmen')
  874. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (140, N'stampfen')
  875. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (138, N'stechen')
  876. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (152, N'steuern')
  877. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (59, N'stoßen')
  878. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (104, N'streicheln')
  879. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (56, N'stürzen')
  880. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (120, N'tapezieren')
  881. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (22, N'treten')
  882. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (164, N'walzen')
  883. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (76, N'wuchten')
  884. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (68, N'zangen')
  885. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (115, N'zanken')
  886. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (75, N'zerren')
  887. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (141, N'ziegeln')
  888. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (4, N'ziehen')
  889. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (48, N'zimmern')
  890. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (52, N'zünden')
  891. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (79, N'zutzeln')
  892. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (84, N'zwackeln')
  893. INSERT [kg].[Praedikat] ([id], [wort]) VALUES (93, N'zwiebeln')
  894. SET IDENTITY_INSERT [kg].[Praedikat] OFF
  895. SET IDENTITY_INSERT [kg].[PraedikatPraefix] ON
  896.  
  897. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (1, N'ab')
  898. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (16, N'an')
  899. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (28, N'aneinander')
  900. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (29, N'aus')
  901. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (24, N'auseinander')
  902. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (30, N'be')
  903. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (31, N'blank')
  904. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (5, N'dran')
  905. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (33, N'drauf')
  906. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (22, N'drüber')
  907. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (23, N'drunter')
  908. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (39, N'durch')
  909. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (8, N'ein')
  910. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (34, N'fest')
  911. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (17, N'flach')
  912. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (36, N'frei')
  913. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (37, N'gerade')
  914. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (38, N'her')
  915. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (53, N'hin')
  916. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (7, N'hinein')
  917. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (20, N'hinzu')
  918. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (21, N'hoch')
  919. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (40, N'kaputt')
  920. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (41, N'krumm')
  921. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (35, N'lose')
  922. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (42, N'nach')
  923. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (32, N'nieder')
  924. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (25, N'quer')
  925. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (43, N'ran')
  926. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (4, N'rein')
  927. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (44, N'rück')
  928. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (45, N'rum')
  929. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (52, N'über')
  930. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (46, N'um')
  931. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (10, N'ver')
  932. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (48, N'vor')
  933. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (3, N'weg')
  934. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (11, N'zer')
  935. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (26, N'zu')
  936. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (50, N'zurecht')
  937. INSERT [kg].[PraedikatPraefix] ([id], [wort]) VALUES (51, N'zwangs')
  938. SET IDENTITY_INSERT [kg].[PraedikatPraefix] OFF
  939. SET IDENTITY_INSERT [kg].[PraedikatZusatz] ON
  940.  
  941. INSERT [kg].[PraedikatZusatz] ([id], [wort]) VALUES (1, N'lassen')
  942. SET IDENTITY_INSERT [kg].[PraedikatZusatz] OFF
  943. SET IDENTITY_INSERT [kg].[Praeposition] ON
  944.  
  945. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (1, N'durch', 1)
  946. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (2, N'hinter', 1)
  947. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (3, N'in', 0)
  948. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (4, N'an', 1)
  949. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (7, N'unter', 1)
  950. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (8, N'über', 1)
  951. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (9, N'vor', 1)
  952. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (10, N'auf', 1)
  953. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (11, N'neben', 1)
  954. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (12, N'zwischen', 1)
  955. INSERT [kg].[Praeposition] ([id], [wort], [kannPraedikatPraefixSein]) VALUES (13, N'gegen', 1)
  956. SET IDENTITY_INSERT [kg].[Praeposition] OFF
  957. SET IDENTITY_INSERT [kg].[PraepositionPraefix] ON
  958.  
  959. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (34, N'agil')
  960. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (26, N'auf 2,94 Newtonmeter')
  961. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (25, N'auf Kant')
  962. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (23, N'auf Stoß')
  963. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (19, N'bedenkenlos')
  964. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (74, N'behutsam')
  965. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (60, N'beidhändig')
  966. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (45, N'destruktiv')
  967. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (59, N'einhändig')
  968. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (51, N'entmenscht')
  969. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (48, N'explosiv')
  970. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (70, N'feste')
  971. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (47, N'flammend')
  972. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (16, N'flott')
  973. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (24, N'formschlüssig')
  974. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (29, N'ganz unverbindlich')
  975. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (71, N'gekonnt')
  976. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (77, N'genüsslich')
  977. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (76, N'genussvoll')
  978. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (10, N'gerade')
  979. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (50, N'gewalttätig')
  980. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (72, N'grenzwertig')
  981. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (9, N'großzügig')
  982. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (54, N'halb')
  983. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (38, N'heftig')
  984. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (14, N'heldenhaft')
  985. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (80, N'hinterrücks')
  986. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (2, N'hochkant')
  987. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (27, N'hurtig')
  988. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (58, N'im Liegen')
  989. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (35, N'inbrünstig')
  990. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (49, N'intensiv')
  991. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (55, N'komplett')
  992. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (53, N'konkret')
  993. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (18, N'kontrovers')
  994. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (75, N'kraftvoll')
  995. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (3, N'längs')
  996. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (41, N'leidenschaftlich')
  997. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (6, N'mit Anlauf')
  998. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (20, N'mit Bedacht')
  999. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (5, N'mit Druck')
  1000. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (64, N'mit einem Rundhaustritt')
  1001. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (17, N'mit Kraft')
  1002. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (28, N'mit maximalem Drehmoment')
  1003. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (12, N'mit Mut')
  1004. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (42, N'mit Sack')
  1005. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (40, N'mit Schmackes')
  1006. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (11, N'mit Verstand')
  1007. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (73, N'mittelfristig')
  1008. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (22, N'ohne Gnade')
  1009. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (21, N'ohne Vorwarnung')
  1010. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (8, N'präzise')
  1011. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (69, N'provisorisch')
  1012. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (1, N'quer')
  1013. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (46, N'rasant')
  1014. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (78, N'rücklings')
  1015. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (79, N'rückwärts')
  1016. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (57, N'saumäßig')
  1017. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (7, N'schief')
  1018. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (13, N'schlampig')
  1019. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (15, N'schnell')
  1020. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (33, N'schwungvoll')
  1021. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (63, N'sieben Stunden lang')
  1022. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (43, N'steil')
  1023. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (44, N'turbulent')
  1024. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (68, N'überdurchschnittlich')
  1025. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (56, N'übermütig')
  1026. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (32, N'ungestüm')
  1027. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (67, N'unterdurchschnittlich')
  1028. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (52, N'verfassungsfeindlich')
  1029. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (30, N'vorsichtig')
  1030. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (37, N'wild')
  1031. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (39, N'wuchtig')
  1032. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (36, N'wüst')
  1033. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (31, N'zaghaft')
  1034. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (4, N'zügig')
  1035. INSERT [kg].[PraepositionPraefix] ([id], [wort]) VALUES (66, N'zweckentfremdet')
  1036. SET IDENTITY_INSERT [kg].[PraepositionPraefix] OFF
  1037. SET IDENTITY_INSERT [kg].[Pronomen] ON
  1038.  
  1039. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (1, N'einen', N'm', 1)
  1040. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (2, N'eine', N'w', 1)
  1041. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (3, N'unseren', N'm', 0)
  1042. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (4, N'unsere', N'w', 0)
  1043. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (5, N'ein', N'n', 1)
  1044. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (6, N'unser', N'n', 0)
  1045. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (7, N'1', N'm', 1)
  1046. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (8, N'1', N'w', 1)
  1047. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (9, N'1', N'n', 1)
  1048. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (11, N'''ne', N'w', 1)
  1049. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (12, N'''nen', N'm', 1)
  1050. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (13, N'''nen', N'n', 1)
  1051. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (14, N'den', N'm', 0)
  1052. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (15, N'die', N'w', 0)
  1053. INSERT [kg].[Pronomen] ([id], [wort], [geschlecht], [kaffee]) VALUES (16, N'das', N'n', 0)
  1054. SET IDENTITY_INSERT [kg].[Pronomen] OFF
  1055. SET IDENTITY_INSERT [kg].[SubjektPraefix] ON
  1056.  
  1057. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (1, N'Humpen', N'm')
  1058. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (2, N'Liter', N'm')
  1059. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (3, N'Tasse', N'w')
  1060. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (4, N'Kanne', N'w')
  1061. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (5, N'Eimer', N'm')
  1062. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (6, N'Becher', N'm')
  1063. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (7, N'Schwapp', N'm')
  1064. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (8, N'Riss', N'm')
  1065. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (9, N'Fuhre', N'w')
  1066. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (10, N'Meter', N'm')
  1067. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (11, N'Tasche', N'w')
  1068. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (12, N'Elle', N'w')
  1069. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (13, N'Schippe', N'w')
  1070. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (14, N'Dose', N'w')
  1071. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (15, N'Ladung', N'w')
  1072. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (16, N'Prügel', N'm')
  1073. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (17, N'Kubikmeter', N'm')
  1074. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (18, N'Messerspitze', N'w')
  1075. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (19, N'Trog', N'm')
  1076. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (20, N'Charge', N'w')
  1077. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (21, N'Ladung', N'w')
  1078. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (22, N'Ofenfüllung', N'w')
  1079. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (23, N'Bottich', N'm')
  1080. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (24, N'Kelle', N'w')
  1081. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (25, N'Kilo', N'n')
  1082. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (26, N'Tonne', N'w')
  1083. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (27, N'Glas', N'n')
  1084. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (28, N'Fass', N'n')
  1085. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (29, N'Kiste', N'w')
  1086. INSERT [kg].[SubjektPraefix] ([id], [wort], [geschlecht]) VALUES (30, N'Menge', N'w')
  1087. SET IDENTITY_INSERT [kg].[SubjektPraefix] OFF
  1088. SET ANSI_PADDING ON
  1089. GO
  1090. /****** Object:  Index [UQ_Adjektiv]    Script Date: 10/15/2018 9:16:05 AM ******/
  1091. ALTER TABLE [kg].[Adjektiv] ADD  CONSTRAINT [UQ_Adjektiv] UNIQUE NONCLUSTERED
  1092. (
  1093.     [wort] ASC
  1094. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  1095. GO
  1096. SET ANSI_PADDING ON
  1097. GO
  1098. /****** Object:  Index [UQ_ObjektEinzeln]    Script Date: 10/15/2018 9:16:05 AM ******/
  1099. ALTER TABLE [kg].[ObjektEinzeln] ADD  CONSTRAINT [UQ_ObjektEinzeln] UNIQUE NONCLUSTERED
  1100. (
  1101.     [wort] ASC,
  1102.     [plural] ASC
  1103. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  1104. GO
  1105. SET ANSI_PADDING ON
  1106. GO
  1107. /****** Object:  Index [UQ_ObjektPräfix]    Script Date: 10/15/2018 9:16:05 AM ******/
  1108. ALTER TABLE [kg].[ObjektPräfix] ADD  CONSTRAINT [UQ_ObjektPräfix] UNIQUE NONCLUSTERED
  1109. (
  1110.     [wort] ASC,
  1111.     [kaffee] ASC
  1112. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  1113. GO
  1114. SET ANSI_PADDING ON
  1115. GO
  1116. /****** Object:  Index [UQ_Praedikat]    Script Date: 10/15/2018 9:16:05 AM ******/
  1117. ALTER TABLE [kg].[Praedikat] ADD  CONSTRAINT [UQ_Praedikat] UNIQUE NONCLUSTERED
  1118. (
  1119.     [wort] ASC
  1120. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  1121. GO
  1122. SET ANSI_PADDING ON
  1123. GO
  1124. /****** Object:  Index [UQ_PraedikatPraefix]    Script Date: 10/15/2018 9:16:05 AM ******/
  1125. ALTER TABLE [kg].[PraedikatPraefix] ADD  CONSTRAINT [UQ_PraedikatPraefix] UNIQUE NONCLUSTERED
  1126. (
  1127.     [wort] ASC
  1128. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  1129. GO
  1130. SET ANSI_PADDING ON
  1131. GO
  1132. /****** Object:  Index [UQ_PraepositionPraefix]    Script Date: 10/15/2018 9:16:05 AM ******/
  1133. ALTER TABLE [kg].[PraepositionPraefix] ADD  CONSTRAINT [UQ_PraepositionPraefix] UNIQUE NONCLUSTERED
  1134. (
  1135.     [wort] ASC
  1136. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  1137. GO
  1138. ALTER TABLE [kg].[ObjektEinzeln] ADD  DEFAULT ((0)) FOR [kannPraefix]
  1139. GO
  1140. ALTER TABLE [kg].[Praeposition] ADD  CONSTRAINT [DF_Praeposition_kannPraedikatPraefixSein]  DEFAULT ((0)) FOR [kannPraedikatPraefixSein]
  1141. GO
  1142. /****** Object:  StoredProcedure [kg].[GeneriereTabelle]    Script Date: 10/15/2018 9:16:05 AM ******/
  1143. SET ANSI_NULLS ON
  1144. GO
  1145. SET QUOTED_IDENTIFIER ON
  1146. GO
  1147. CREATE procedure [kg].[GeneriereTabelle] --3500,0,0
  1148.     @zeilen int,
  1149.     @superMode bit = 0,
  1150.     @orderByLength bit = 0,
  1151.     @searchString nvarchar(255) = null
  1152. as
  1153. begin
  1154.     set nocount on;
  1155.     declare @subject nvarchar(255),
  1156.             @subjectModifier nvarchar(255),
  1157.             @subjectArticlePronoun nvarchar(255),
  1158.             @subjectCanHavePrefix bit,
  1159.             @subjectPrefix nvarchar(255),
  1160.             @subjectPrefixCount int = 0,
  1161.             @preposition nvarchar(255),
  1162.             @prepositionPrefix nvarchar(255),
  1163.             @object nvarchar(255),
  1164.             @objectArticlePronoun nvarchar(255),
  1165.             @objectCanHavePrefix bit,
  1166.             @objectPrefix nvarchar(255),
  1167.             @objectPrefixCount int = 0,
  1168.             @predicate nvarchar(255),
  1169.             @predicatePrefix nvarchar(255),
  1170.             @predicateAddition nvarchar(255),
  1171.             @adjectivePrefix nvarchar(255),
  1172.             @gender char(1),
  1173.             @isPlural bit,
  1174.             @maxLoops int = @zeilen,
  1175.             @currentLoop int = 1
  1176.  
  1177.     drop table if exists #result;
  1178.     create table #result
  1179.     (
  1180.         coffeeAlternative nvarchar(1000)
  1181.     );
  1182.  
  1183.     while @currentLoop <= @maxLoops
  1184.     begin
  1185. -- SQL Prompt formatting off
  1186.         exec kg.LadeSubjekt @subject output, @gender output, @isPlural output, @subjectCanHavePrefix output, @selectResult = 0;
  1187.         if @isPlural = 0 and (iif(@superMode = 1, 0, rand()) < 0.2) exec kg.LadeAdjektivPraefix @adjectivePrefix output, @selectResult = 0
  1188.         if @subjectCanHavePrefix = 1 and (iif(@superMode = 1, 0, rand()) < 0.90) set @subjectPrefixCount += 1
  1189.         if (@subjectPrefixCount = 1 and rand() < 0.1) set @subjectPrefixCount += 1
  1190.         if (@subjectPrefixCount = 2 and rand() < 0.1) set @subjectPrefixCount += 1
  1191.         if @subjectPrefixCount > 0 exec kg.LadeObjektPraefix @subjectPrefix output, @kaffee = 1, @PraefixCount = @subjectPrefixCount, @selectResult = 0
  1192.         if (iif(@superMode = 1, 0, rand()) < 0.5) exec kg.LadeSubjektPraefix @subjectModifier output, @gender output, @selectResult = 0;
  1193.         set @isPlural = iif(@subjectModifier is null, @isPlural, 0) -- Subjektpräfix (noch nicht) im Plural verfügbar
  1194.         exec kg.LadeArtikelPronomen @gender, 1, @isPlural, @subjectArticlePronoun output, @selectResult = 0;
  1195.         if (iif(@superMode = 1, 0, rand()) < 0.35) declare @praepositionPraefix nvarchar(255);
  1196.         if (iif(@superMode = 1, 0, rand()) < 0.5) exec kg.LadePraepositionPraefix @prepositionPrefix output, @selectResult = 0;
  1197.         exec kg.LadePraeposition @preposition output, @selectResult = 0;
  1198.         exec kg.LadeObjekt @object output, @gender output, @isPlural output, @objectCanHavePrefix output, @selectResult = 0;
  1199.         if @objectCanHavePrefix = 1 and (iif(@superMode = 1, 0, rand()) < 0.90) set @objectPrefixCount += 1
  1200.         if (@objectPrefixCount = 1 and rand() < 0.10) set @objectPrefixCount += 1
  1201.         if (@objectPrefixCount = 2 and rand() < 0.10) set @objectPrefixCount += 1
  1202.         if @objectPrefixCount > 0 exec kg.LadeObjektPraefix @objectPrefix output, @kaffee = 0, @PraefixCount = @objectPrefixCount, @selectResult = 0
  1203.         exec kg.LadeArtikelPronomen @gender, 0, @isPlural, @objectArticlePronoun output, @selectResult = 0;
  1204.         exec kg.LadePraedikat @predicate output, @selectResult = 0;
  1205.         if (iif(@superMode = 1, 0, rand()) < 0.7) exec kg.LadePraedikatPraefix @predicatePrefix output, @selectResult = 0;
  1206.         if (rand() < 0.2) exec kg.LadePraedikatZusatz @predicateAddition output, @selectResult = 0;
  1207. -- SQL Prompt formatting on
  1208.  
  1209.         insert into #result
  1210.         (
  1211.             coffeeAlternative
  1212.         )
  1213.         values
  1214.         (
  1215.             concat(   @subjectArticlePronoun,
  1216.                       ' ',
  1217.                       @subjectModifier + ' ',
  1218.                       @adjectivePrefix,
  1219.                       iif(@subjectPrefixCount > 0,
  1220.                           concat(   substring(   @subject,
  1221.                                                  1,
  1222.                                                  patindex(   '% %',
  1223.                                                              @subject
  1224.                                                          )
  1225.                                              ),
  1226.                                     @subjectPrefix,
  1227.                                     lower(substring(   @subject,
  1228.                                                        patindex(   '% %',
  1229.                                                                    @subject
  1230.                                                                ) + 1,
  1231.                                                        len(@subject)
  1232.                                                    )
  1233.                                          )
  1234.                                 ),
  1235.                           @subject),
  1236.                       ' ',
  1237.                       @prepositionPrefix + ' ',
  1238.                       @preposition,
  1239.                       ' ',
  1240.                       @objectArticlePronoun,
  1241.                       ' ',
  1242.                       iif(@objectPrefixCount > 0, concat(@objectPrefix, lower(@object)), @object),
  1243.                       ' ',
  1244.                       @predicatePrefix,
  1245.                       @predicate,
  1246.                       ' ' + @predicateAddition
  1247.                   )
  1248.         );
  1249.  
  1250.         set @subjectModifier = null;
  1251.         set @predicatePrefix = null;
  1252.         set @predicateAddition = null;
  1253.         set @objectCanHavePrefix = null;
  1254.         set @objectPrefix = null;
  1255.         set @objectPrefixCount = 0;
  1256.         set @subjectCanHavePrefix = null;
  1257.         set @subjectPrefix = null;
  1258.         set @subjectPrefixCount = 0;
  1259.         set @adjectivePrefix = null;
  1260.  
  1261.         set @currentLoop += 1;
  1262.     end;
  1263.  
  1264.     select coffeeAlternative
  1265.     from #result
  1266.     where coffeeAlternative like iif(@searchString is not null, concat('%', @searchString, '%'), '%')
  1267.     order by iif(@orderByLength = 1, len(coffeeAlternative), 0) desc;
  1268. end;
  1269. GO
  1270. /****** Object:  StoredProcedure [kg].[LadeAdjektivPraefix]    Script Date: 10/15/2018 9:16:05 AM ******/
  1271. SET ANSI_NULLS ON
  1272. GO
  1273. SET QUOTED_IDENTIFIER ON
  1274. GO
  1275. create   procedure [kg].[LadeAdjektivPraefix]
  1276.     @adjektivPraefix nvarchar(255) = null output,
  1277.     @selectResult bit = 1
  1278. as
  1279. begin
  1280.     set @adjektivPraefix =
  1281.     (
  1282.         select top(1)
  1283.                lower(wort)
  1284.         from kg.ObjektPräfix
  1285.         order by newid()
  1286.     );
  1287.  
  1288.     if @selectResult = 1
  1289.         select @adjektivPraefix adjektivPraefix;
  1290. end;
  1291. GO
  1292. /****** Object:  StoredProcedure [kg].[LadeArtikelPronomen]    Script Date: 10/15/2018 9:16:05 AM ******/
  1293. SET ANSI_NULLS ON
  1294. GO
  1295. SET QUOTED_IDENTIFIER ON
  1296. GO
  1297. CREATE procedure [kg].[LadeArtikelPronomen]
  1298.     @geschlecht char(1),
  1299.     @istKaffee bit,
  1300.     @istPlural bit = 0,
  1301.     @artikelPronomen nvarchar(255) = null output,
  1302.     @selectResult bit = 1
  1303. as
  1304. begin
  1305. -- SQL Prompt formatting off
  1306.     set @artikelPronomen = iif
  1307.     (
  1308.         @istPlural = 0,
  1309.         (
  1310.             select top(1)
  1311.                     artikelPronomen.wort
  1312.             from
  1313.             (
  1314.                 select wort
  1315.                 from kg.Pronomen
  1316.                 where geschlecht = @geschlecht and
  1317.                         kaffee = @istKaffee
  1318.                 union
  1319.                 select artikelAkkusativ
  1320.                 from kg.Artikel
  1321.                 where geschlecht = @geschlecht
  1322.             )artikelPronomen
  1323.             order by newid()
  1324.         ),
  1325.         (
  1326.             select top(1)
  1327.                     wort
  1328.             from kg.PluralErsatz
  1329.             order by newid()
  1330.         )
  1331.     );
  1332. -- SQL Prompt formatting on
  1333.  
  1334.     if @selectResult = 1
  1335.         select @artikelPronomen artikelPronomen;
  1336. end;
  1337. GO
  1338. /****** Object:  StoredProcedure [kg].[LadeKonjunktion]    Script Date: 10/15/2018 9:16:05 AM ******/
  1339. SET ANSI_NULLS ON
  1340. GO
  1341. SET QUOTED_IDENTIFIER ON
  1342. GO
  1343. CREATE procedure [kg].[LadeKonjunktion]
  1344.     @konjunktion nvarchar(255) = null output,
  1345.     @selectResult bit = 1
  1346. as
  1347. begin
  1348.     set @konjunktion =
  1349.     (
  1350.         select top(1)
  1351.                wort konjunktion
  1352.         from kg.Konjunktion
  1353.         order by newid()
  1354.     );
  1355.  
  1356.     if @selectResult = 1
  1357.        select @konjunktion wort;
  1358. end;
  1359. GO
  1360. /****** Object:  StoredProcedure [kg].[LadeObjekt]    Script Date: 10/15/2018 9:16:05 AM ******/
  1361. SET ANSI_NULLS ON
  1362. GO
  1363. SET QUOTED_IDENTIFIER ON
  1364. GO
  1365. CREATE procedure [kg].[LadeObjekt] -- Kein Adjektiv!
  1366.     @objekt nvarchar(255) = null output,
  1367.     @geschlecht char(1) = null output,
  1368.     @istPlural bit = null output,
  1369.     @kannPraefix bit = null output,
  1370.     @selectResult bit = 1
  1371. as
  1372. begin
  1373.     -- Zusammengesetzt
  1374.     select top(1)
  1375.            @objekt = o.wort,
  1376.            @geschlecht = o.geschlecht,
  1377.            @istPlural = o.plural,
  1378.            @kannPraefix = o.kannPraefix
  1379.     from kg.ObjektEinzeln o
  1380.     cross join kg.PluralErsatz pe
  1381.     where o.kaffee = 0
  1382.     order by newid();
  1383.  
  1384.     if @selectResult = 1
  1385.         select @objekt objekt,
  1386.                @geschlecht geschlecht,
  1387.                @istPlural istPlural,
  1388.                @kannPraefix kannPraefix;
  1389.  
  1390. -- Normale Objekt-Tabelle
  1391. /*
  1392.     select top(1)
  1393.            @objekt = o.wort,
  1394.            @geschlecht = o.geschlecht,
  1395.            @istPlural = o.plural
  1396.     from kg.Objekt o
  1397.     cross join kg.PluralErsatz pe
  1398.     where o.kaffee = 0
  1399.     order by newid();
  1400.  
  1401.     if @selectResult = 1
  1402.         select @objekt objekt,
  1403.                @geschlecht geschlecht,
  1404.                @istPlural istPlural;
  1405.     */
  1406. end;
  1407.  
  1408. GO
  1409. /****** Object:  StoredProcedure [kg].[LadeObjektPraefix]    Script Date: 10/15/2018 9:16:05 AM ******/
  1410. SET ANSI_NULLS ON
  1411. GO
  1412. SET QUOTED_IDENTIFIER ON
  1413. GO
  1414. CREATE   procedure [kg].[LadeObjektPraefix] --@kaffee = 1, @praefixcount = 1
  1415.     @objektPraefix nvarchar(255) = null output,
  1416.     @kaffee bit,
  1417.     @PraefixCount int = 1,
  1418.     @selectResult bit = 1
  1419. as
  1420. begin
  1421.     declare @counter int = 1;
  1422.     set @objektPraefix = '';
  1423.     while @counter <= @PraefixCount
  1424.     begin
  1425.         set @objektPraefix =
  1426.         (
  1427.             select top(1)
  1428.                    wort
  1429.             from kg.ObjektPräfix
  1430.             where kaffee = @kaffee and
  1431.                   @objektPraefix not like concat(   '%',
  1432.                                                     wort,
  1433.                                                     '%'
  1434.                                                 )
  1435.             order by newid()
  1436.         ) + lower(@objektPraefix);
  1437.  
  1438.         set @counter += 1;
  1439.     end;
  1440.  
  1441.     if @selectResult = 1
  1442.         select @objektPraefix objectPraefix;
  1443. end;
  1444. GO
  1445. /****** Object:  StoredProcedure [kg].[LadePraedikat]    Script Date: 10/15/2018 9:16:05 AM ******/
  1446. SET ANSI_NULLS ON
  1447. GO
  1448. SET QUOTED_IDENTIFIER ON
  1449. GO
  1450. CREATE procedure [kg].[LadePraedikat]
  1451.     @praedikat nvarchar(255) = null output,
  1452.     @selectResult bit = 1
  1453. as
  1454. begin
  1455.     set @praedikat =
  1456.     (
  1457.         select top(1)
  1458.                wort praedikat
  1459.         from kg.Praedikat
  1460.         order by newid()
  1461.     );
  1462.  
  1463.     if @selectResult = 1
  1464.         select @praedikat wort;
  1465. end;
  1466. GO
  1467. /****** Object:  StoredProcedure [kg].[LadePraedikatPraefix]    Script Date: 10/15/2018 9:16:05 AM ******/
  1468. SET ANSI_NULLS ON
  1469. GO
  1470. SET QUOTED_IDENTIFIER ON
  1471. GO
  1472. CREATE procedure [kg].[LadePraedikatPraefix]
  1473.     @praedikatPraefix nvarchar(255) = null output,
  1474.     @selectResult bit = 1
  1475. as
  1476. begin
  1477.     set @praedikatPraefix =
  1478.     (
  1479.         select top(1) praedikatUndPraeposition.praedikatPraefix
  1480.         from
  1481.         (
  1482.             select wort praedikatPraefix
  1483.             from kg.PraedikatPraefix
  1484.             union
  1485.             select wort praedikatPraefix
  1486.             from kg.Praeposition
  1487.             where kannPraedikatPraefixSein = 1
  1488.         )praedikatUndPraeposition
  1489.         order by newid()
  1490.     );
  1491.  
  1492.     if @selectResult = 1
  1493.         select @praedikatPraefix wort;
  1494. end;
  1495. GO
  1496. /****** Object:  StoredProcedure [kg].[LadePraedikatZusatz]    Script Date: 10/15/2018 9:16:05 AM ******/
  1497. SET ANSI_NULLS ON
  1498. GO
  1499. SET QUOTED_IDENTIFIER ON
  1500. GO
  1501. CREATE procedure [kg].[LadePraedikatZusatz]
  1502.     @praedikatZusatz nvarchar(255) = null output,
  1503.     @selectResult bit = 1
  1504. as
  1505. begin
  1506.     set @praedikatZusatz =
  1507.     (
  1508.         select top(1)
  1509.                wort praesikatZusatz
  1510.         from kg.PraedikatZusatz
  1511.         order by newid()
  1512.     );
  1513.  
  1514.     if @selectResult = 1
  1515.         select @praedikatZusatz wort;
  1516. end;
  1517. GO
  1518. /****** Object:  StoredProcedure [kg].[LadePraeposition]    Script Date: 10/15/2018 9:16:05 AM ******/
  1519. SET ANSI_NULLS ON
  1520. GO
  1521. SET QUOTED_IDENTIFIER ON
  1522. GO
  1523. CREATE procedure [kg].[LadePraeposition]
  1524.     @praeposition nvarchar(255) = null output,
  1525.     @selectResult bit = 1
  1526. as
  1527. begin
  1528.     set @praeposition =
  1529.     (
  1530.         select top(1)
  1531.                wort praeposition
  1532.         from kg.Praeposition
  1533.         order by newid()
  1534.     );
  1535.  
  1536.     if @selectResult = 1
  1537.         select @praeposition wort;
  1538. end;
  1539. GO
  1540. /****** Object:  StoredProcedure [kg].[LadePraepositionPraefix]    Script Date: 10/15/2018 9:16:05 AM ******/
  1541. SET ANSI_NULLS ON
  1542. GO
  1543. SET QUOTED_IDENTIFIER ON
  1544. GO
  1545. create procedure [kg].[LadePraepositionPraefix]
  1546.     @praepositionPraefix nvarchar(255) = null output,
  1547.     @selectResult bit = 1
  1548. as
  1549. begin
  1550.     set @praepositionPraefix =
  1551.     (
  1552.         select top(1)
  1553.                wort praepositionPraefix
  1554.         from kg.PraepositionPraefix
  1555.         order by newid()
  1556.     );
  1557.  
  1558.     if @selectResult = 1
  1559.        select @praepositionPraefix wort;
  1560. end;
  1561. GO
  1562. /****** Object:  StoredProcedure [kg].[LadeSubjekt]    Script Date: 10/15/2018 9:16:05 AM ******/
  1563. SET ANSI_NULLS ON
  1564. GO
  1565. SET QUOTED_IDENTIFIER ON
  1566. GO
  1567. CREATE procedure [kg].[LadeSubjekt] -- Kein Plural!
  1568.     @subjekt nvarchar(255) = null output,
  1569.     @geschlecht char(1) = null output,
  1570.     @plural bit = null output,
  1571.     @kannPraefix bit = null output,
  1572.     @selectResult bit = 1
  1573. as
  1574. begin
  1575.     select top(1)
  1576.            @subjekt = concat(iif(o.plural = 0, concat(a.wort, ' '), null),
  1577.                              o.wort
  1578.                             ),
  1579.            @geschlecht = o.geschlecht,
  1580.            @plural = o.plural,
  1581.            @kannPraefix = o.kannPraefix
  1582.     from kg.ObjektEinzeln o
  1583.     inner join kg.Adjektiv a
  1584.         on o.geschlecht = a.geschlecht
  1585.     where o.kaffee = 1
  1586.     order by newid();
  1587.  
  1588.     if @selectResult = 1
  1589.         select @subjekt subjekt,
  1590.                @geschlecht geschlecht,
  1591.                @plural plural,
  1592.                @kannPraefix kannPraefix;
  1593.  
  1594. -- Normale Objekt-Tabelle
  1595. /*
  1596.     select top(1)
  1597.            @subjekt = concat(iif(o.plural = 0, concat(a.wort, ' '), null),
  1598.                              o.wort
  1599.                             ),
  1600.            @geschlecht = o.geschlecht,
  1601.            @plural = o.plural
  1602.     from kg.Objekt o
  1603.     inner join kg.Adjektiv a
  1604.         on o.geschlecht = a.geschlecht
  1605.     where o.kaffee = 1
  1606.     order by newid();
  1607.  
  1608.     if @selectResult = 1
  1609.         select @subjekt subjekt,
  1610.                @geschlecht geschlecht,
  1611.                @plural;
  1612.     */
  1613. end;
  1614.  
  1615. GO
  1616. /****** Object:  StoredProcedure [kg].[LadeSubjektPraefix]    Script Date: 10/15/2018 9:16:05 AM ******/
  1617. SET ANSI_NULLS ON
  1618. GO
  1619. SET QUOTED_IDENTIFIER ON
  1620. GO
  1621. create procedure [kg].[LadeSubjektPraefix]
  1622.     @subjektPraefix nvarchar(255) = null output,
  1623.     @geschlecht char(1) = null output,
  1624.     @selectResult bit = 1
  1625. as
  1626. begin
  1627.  
  1628.     select top(1)
  1629.            @subjektPraefix = wort,
  1630.            @geschlecht = geschlecht
  1631.     from kg.SubjektPraefix
  1632.     order by newid();
  1633.  
  1634.     if @selectResult = 1
  1635.         select @subjektPraefix subjektPraefix,
  1636.                @geschlecht geschlecht;
  1637. end;
  1638. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!