Database

SELECT * FROM dbo.Books
WHERE title LIKE '%search%' OR author LIKE '%search%'

Declare @a varchar(50)<br />
<br />
SELECT * FROM dbo.Books<br />
WHERE title LIKE '%' + @a + '%' OR author LIKE '%' + @a + '%' 

Rob Graham wrote:

You set the field datatype when you create the table.

Rob Graham wrote:

There are restrictions on what changes can be made whithout losing data

eMtek wrote:

There is no option to choose memo, so how to do it?

EricDV wrote:

Click it, and choose Memo.

Select Name,Email,Phone
from Members
Where ValidateIDNum<code><big>(</big></code>Members.IDNum<code><big>)</big></code> = 'IN-Valid'

CREATE TRIGGER InsteadUpdateTrigger on tblTable
INSTEAD OF UPDATE
AS
BEGIN
   UPDATE tblTable
        SET a=i.a,b=i.b,c=i.a+i.b
	FROM INSERTED i
        WHERE tblTable.IDField = i.IDField
END


CREATE TRIGGER InsteadInsertTrigger on tblTable
INSTEAD OF INSERT
AS
BEGIN
   INSERT INTO tblTable
       SELECT a,b,a+b
       FROM INSERTED
END

CREATE TABLE [tblTable] (
	[IDField] [int] IDENTITY (1, 1) NOT NULL ,
	[a] [int] NULL ,
	[b] [int] NULL ,
	<code>[c] AS ([a] + [b]) </code>,
	CONSTRAINT [PK_tblIDField] PRIMARY KEY  CLUSTERED 
	(
		[IDField]
	)  ON [PRIMARY] 
) ON [PRIMARY]