Topics
Started by
Posts
Last post
Hello friends I have two tables like Master_E and Child_E CREATE TABLE [Master_E] ( [ID] [int…
1 replies
Good Morning everyone, I am trying to run a .bat file in SQL that open an excel file automatically …
14 replies
Hi experts, I am in Server A and querying Server B from SQL query analyzer by : select * from [Serv…
1 replies
Hello! I would like to update some column values in the table using CURSORS. I would like to iterat…
13 replies
Hello gang! I know this is very simple for you SQL gods, but me here is breaking my head. My …
7 replies
My question is this, if a trigger is written with an update, insert or delete, and it fails whether…
1 replies
Hi experts, How to insert data into a table which has a column with not null row_id (numeric)…
9 replies
I came across some bad code at a new job and was wondering why this works or compiles? SELECT a.* F…
5 replies
I need to essentially do 2 loops. One loops through each record and then inside each r…
21 replies
The reference/test SUBSTRING(COLUMNS_UPDATED(),1,1)=power(2,(col-1)) in an UPDATE trigger appe…
4 replies
The developers did not name any of their Primary Keys, Foreign Keys, Defaults or Indexes when they …
2 replies
I just rec'd a product catolog which list the products in this format: SKU Name&n…
1 replies
Hi, I have a table variable of records. Each record has a type, a group id and a urn. I need to sel…
5 replies
I have a table which has about 500 unique records all with a unique id (T1) I need to join this to …
9 replies
I posted this thread at another site and did not get any meaningful responses. I'm assuming i…
1 replies
Viewing 15 topics - 8,371 through 8,385 (of 17,082 total)
You must be logged in to create new topics.