Topics
Started by
Posts
Last post
Hi All, I am adding a username column to an existing users table. I am generating the usernames ba…
12 replies
Hi, Even with my limited experience, I should be able to figure this out, but I'm stumped. In SQL S…
5 replies
CREATE OR REPLACE TRIGGER TR_UPDATE_EMRMedicationsInfo AFTER INSERT OR UPDATE OR DELETE ON EMRUNCO…
3 replies
Hi, I need to insert large amount of data into a table lets say some lakhs. Can anyone please tell …
2 replies
Hi, I am creating a after insert trigger. I am declaring some variables and doing some calculation.…
2 replies
Hi all, I have a simple query: SELECT @myVar = someValue FROM [server].[database].schema.table WHE…
10 replies
Say i have following three tables License: Id, SerialNum 1, x123 2, x234 Product: Id, Description, …
1 replies
Is it possible to JOIN to the result of a StoreProcedure directly? Previously I've been doing this …
7 replies
I have a sql script which is supposed to load rows to a remote db. It has been getting an error (w…
4 replies
Hi. I need to call a variety of procedures in ORACLE Database, from a SQL CLR .NET Application... I…
5 replies
Hey - had a bit of a discussion with one of the other DB guys at my company, regarding what the bes…
11 replies
Hai! How can i achive the nested transaction. The following code give error, whats the err…
6 replies
Hi, i am creating a huge table(arround 500 millions rows) using select into statement. My query se…
2 replies
Hi, I had a question about this script. select a.name, a.length, b.name from syscolumns a, sysobjec…
3 replies
Hi, I have a database with thousands of tables, I have a list of some table names, I want to progra…
3 replies
Viewing 15 topics - 5,581 through 5,595 (of 12,234 total)
You must be logged in to create new topics.