Click here to Skip to main content
15,905,874 members
Home / Discussions / Database
   

Database

 
QuestionRTF in Reporting services reports Pin
AlterD3-Jul-08 9:14
AlterD3-Jul-08 9:14 
QuestionHelp in get Time Pin
Senthil S3-Jul-08 4:08
Senthil S3-Jul-08 4:08 
AnswerRe: Help in get Time Pin
DerekFL3-Jul-08 4:39
DerekFL3-Jul-08 4:39 
AnswerRe: Help in get Time Pin
Blue_Boy3-Jul-08 22:43
Blue_Boy3-Jul-08 22:43 
Questiontrigger instead of identity Pin
Mr.Kode3-Jul-08 1:04
Mr.Kode3-Jul-08 1:04 
AnswerRe: trigger instead of identity Pin
DerekFL3-Jul-08 4:43
DerekFL3-Jul-08 4:43 
AnswerRe: trigger instead of identity Pin
DerekFL3-Jul-08 4:55
DerekFL3-Jul-08 4:55 
AnswerRe: trigger instead of identity Pin
leoinfo4-Jul-08 4:26
leoinfo4-Jul-08 4:26 
You should replace *for insert* with *INSTEAD OF INSERT*.
When FOR is the only keyword specified, AFTER is used by default.

CREATE TRIGGER dbo.insertNum
ON testIcreTrigger  
INSTEAD OF INSERT 
AS
BEGIN
  INSERT INTO testIcreTrigger (Num)
  SELECT MAX(Num)+1 FROM hitTheatre
END

Questionbegin tran... commit and stored procedures/functions Pin
blakey4043-Jul-08 0:21
blakey4043-Jul-08 0:21 
AnswerRe: begin tran... commit and stored procedures/functions Pin
DerekFL3-Jul-08 4:52
DerekFL3-Jul-08 4:52 
GeneralRe: begin tran... commit and stored procedures/functions Pin
blakey4043-Jul-08 5:11
blakey4043-Jul-08 5:11 
QuestionUnable to view SQL Report with normal login Pin
Ankur.Bakliwal3-Jul-08 0:09
Ankur.Bakliwal3-Jul-08 0:09 
Questioninstallation Pin
Kissy162-Jul-08 23:50
Kissy162-Jul-08 23:50 
AnswerRe: installation Pin
John_Adams3-Jul-08 5:35
John_Adams3-Jul-08 5:35 
QuestionStored Procedure or Trigger for Autogenerate Colunm Pin
rrrriiizz2-Jul-08 20:45
rrrriiizz2-Jul-08 20:45 
AnswerRe: Stored Procedure or Trigger for Autogenerate Colunm Pin
Mycroft Holmes2-Jul-08 20:56
professionalMycroft Holmes2-Jul-08 20:56 
GeneralRe: Stored Procedure or Trigger for Autogenerate Colunm Pin
rrrriiizz2-Jul-08 21:34
rrrriiizz2-Jul-08 21:34 
GeneralRe: Stored Procedure or Trigger for Autogenerate Colunm Pin
rrrriiizz3-Jul-08 1:09
rrrriiizz3-Jul-08 1:09 
GeneralRe: Stored Procedure or Trigger for Autogenerate Colunm Pin
Mycroft Holmes4-Jul-08 0:26
professionalMycroft Holmes4-Jul-08 0:26 
GeneralRe: Stored Procedure or Trigger for Autogenerate Colunm Pin
rrrriiizz5-Jul-08 1:35
rrrriiizz5-Jul-08 1:35 
QuestionTrigger with Time Pin
obarahmeh2-Jul-08 20:08
obarahmeh2-Jul-08 20:08 
AnswerRe: Trigger with Time Pin
Mycroft Holmes2-Jul-08 21:00
professionalMycroft Holmes2-Jul-08 21:00 
GeneralRe: Trigger with Time Pin
obarahmeh2-Jul-08 22:50
obarahmeh2-Jul-08 22:50 
QuestionsqlDataReader Execution in a Function Pin
IlseBrase2-Jul-08 18:29
IlseBrase2-Jul-08 18:29 
AnswerRe: sqlDataReader Execution in a Function Pin
Vimalsoft(Pty) Ltd3-Jul-08 4:03
professionalVimalsoft(Pty) Ltd3-Jul-08 4:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.