Click here to Skip to main content
15,671,955 members
Home / Discussions / Database
   

Database

 
QuestionTrouble joining between 3 tables Pin
dlarkin773-Jul-08 10:14
dlarkin773-Jul-08 10:14 
AnswerRe: Trouble joining between 3 tables Pin
Paul Conrad3-Jul-08 11:15
professionalPaul Conrad3-Jul-08 11:15 
AnswerRe: Trouble joining between 3 tables Pin
Blue_Boy3-Jul-08 22:39
Blue_Boy3-Jul-08 22:39 
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 
i have a column its values must started with 1 and incrementing by 1
this column repeatly looses his rows
so i can not use identity here
so i tried to raise a trigger to do the job
but i have some probelems with the following statments

create trigger dbo.insertNum
on testIcreTrigger --table name
for insert
AS
begin
declare @insVal int --value to insert
declare @MaxVal int
select @MaxVal= Max(Num) from hitTheatre
select @insVal=@MaxVal+1
insert into testIcreTrigger (Num)
values (@insVal)
End
Go
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 
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 

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.