Topics
Started by
Posts
Last post
Hi, A audit table is having more than 4 crores of records. I am trying to fetching the first 3 la…
12 replies
I know I have the inserted table, but how could I reference the old value of a column? The problem …
15 replies
the columns are as follows date c_type c_status dd/mm/yy L P '' …
8 replies
Hello all I register linked server and i can perform select query using this query SELECT * FROM OP…
5 replies
The specified schema name "dbo." either does not exist or you do not have permission to use it.
1 replies
What set of SELECT statements would provide the same results as DBCC INPUTBUFFER(@@spid)? Thanks!
3 replies
The specified schema name "dbo." either does not exist or you do not have permission to use it. I a…
1 replies
I am trying to simple this query: select field 1, (complicated sql involving, ISNULL, rtrim. left,…
6 replies
you can see from this what I would like to do but of course it does not work INSERT INTO PS_CUST_RE…
4 replies
Maybe I'm having a brain fart today but here's my situation. I have two tables: calls and sales. Ea…
2 replies
Hello, I need to add some columns to several existing tables. Some have over three hundred thousand…
15 replies
Hi, I just need a quick and dirty for dropping a foreign key constraint on a table. I don't want t…
4 replies
I have a table XXX with only 1 record and columns as col1 col2 col3 col4 col5 col6 col7 col…
14 replies
is it possible to add ON UPDATE CASCADE to existing table? I have tried a number of different combo…
1 replies
Colleagues; I have an interesting, multi-faceted challenge. Six months ago (as an IT contractor) I…
5 replies
Viewing 15 topics - 7,951 through 7,965 (of 12,230 total)
You must be logged in to create new topics.