MS MSQL 2012 Server Event Type How to?

Question

Hi all,

How to use sql event type? Please help me! :)

I have a table:

CREATE TABLE LendingLog ( LendingLogId INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
			  EventDate DATETIME NOT NULL,
			  LendingLogEvent Event /*Here is need with two values, */
						);

Thank you!

Kugynok

Answer 1

You have to use SQL Server data types or user-defined data types.

Event is not a T-SQL data type.

No structures allowed, just list the columns one by one.

You can use XML data type for semi-structured data.

This is not C++. T-SQL is a very simple yet immensely powerful language.

Provide more information for quick assistance.

---

Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours
New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

Answer 2

Thank You! :)