-
as seen on Programmers
- Search for 'Programmers'
I am new to oracle 11G programming and i have run into a tough situation with pl\sql funtions and automation. I ame unsure how to create the function for the automation of Registration system for a College registration system. Here is what i want to do. I want to automate the registrations system…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello Everyone
I'm stuck and any help you can give me is greatly appreciated.
create table stackoverflow_rules(myguid uniqueidentifier primary key, myvarchar50 varchar(50))
insert into stackoverflow_rules(myguid, myvarchar50) values('27C4CF31-2C4C-4C78-BBDC-2D0FDAA891CF','9985276')
insert into…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi, basically, I have 3 tables; users and projects (which is a many-to-many relationship), then I have 'usersprojects' to allow the one-to-many formation. When a user adds a project, I need the project information stored and then the 'userid' and 'projectid' stored in the usersprojects table. It sounds…
>>> More
-
as seen on SQL Authority
- Search for 'SQL Authority'
Recently I wrote about SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT I mentioned about how TOP works with INSERT. I have mentioned that I will write about the performance in next article. Here is the performance comparison of the two options.
It is clear that performance of the Insert…
>>> More
-
as seen on SQL Authority
- Search for 'SQL Authority'
During my recent training at one of the clients, I was asked regarding the enhancement in TOP clause. When I demonstrated my script regarding how TOP works along with INSERT, one of the attendees suggested that I should also write about this script on my blog. Let me share this with all of you and…
>>> More
