|
|
-
Raj Acharya Liked 1 Years ago through Just Learned | 1 Point
We can insert all the default values in tables without specifiying values while insert in table, how? See here we have tables defined all columns with default,
[code]
CREATE TABLE defaultval(
id int default 0,
name varchar(10)
de...
|
-
Raj Acharya Learned 1 Years ago through Just Learned | 1 Point
We can insert all the default values in tables without specifiying values while insert in table, how? See here we have tables defined all columns with default,
[code]
CREATE TABLE defaultval(
id int default 0,
name varchar(10)
de...
|
-
Raj Acharya Liked 1 Years ago through Just Learned | 1 Point
We can insert all the default values in tables without specifiying values while insert in table, how? See here we have tables defined all columns with default,
[code]
CREATE TABLE defaultval(
id int default 0,
name varchar(10)
de...
|
-
Raj Acharya Learned 1 Years ago through Just Learned | 1 Point
We can insert all the default values in tables without specifiying values while insert in table, how? See here we have tables defined all columns with default,
[code]
CREATE TABLE defaultval(
id int default 0,
name varchar(10)
de...
|
-
Raj Acharya Posted 1 Years ago through Just Learned | 5 Points
Within an INSERT/UPDATE trigger, we can use the UPDATE() function to determine where a specific column is part of the updated/inserted column list. For example:
IF UPDATE(CustomerName) BEGIN
PRINT 'Customer name is being updated'
--...
|
-
Raj Acharya Posted 1 Years ago through Just Learned | 5 Points
Within an INSERT/UPDATE trigger, we can use the UPDATE() function to determine where a specific column is part of the updated/inserted column list. For example:
IF UPDATE(CustomerName) BEGIN
PRINT 'Customer name is being updated'
--...
|
-
Raj Acharya Posted 1 Years ago through Just Learned | 5 Points
this can be useful when we need to perform some action when only particular column update of table.
UPDATE() is used anywhere inside the body of a Transact-SQL INSERT or UPDATE trigger to test whether the trigger should execute certain actions.
I hav...
|