Topics
Started by
Posts
Last post
I want to get a complete copy (with indexes) of a very large table to a new temp table in the faste…
4 replies
my mssql server has a linked table to an oracle db I have this stored procedure DECLA…
5 replies
Good day I have a request to query against some fax DB (rightfax) for the following: A query to ind…
14 replies
hi all, I need some help with a stored proc to select the date in table that is closest to today's …
7 replies
what are the events occur when a trigger is fired.
1 replies
By: stax68
we dealing with flat tables in SQL Server, as i am beginner, i dont understand how flat table is go…
2 replies
By: stax68
Hi i have table like below SNONAMEMARKSRANK ---------------------------- 1A56 2B35 3C77 4…
3 replies
select * from bills a WHERE 3= ( select count(*) &…
3 replies
I've got a table with 22,000 rows. The rows consist of 4 fields, varchar(32), varchar(254), c…
5 replies
By: jcb
i want to limit the data being stored in a table to the past 6 months only. data in the table is re…
9 replies
By: stax68
Hi, I'm trying out the table variable for the first time in 2000 and am struggling to get this SP t…
3 replies
By: stax68
Greetings All, Is there an elegant way to generate the resultset indicated from the data described…
7 replies
By: R2ro
I get the error beolow when I'm creating a table (further below). It's referring to the varchar8000…
4 replies
Hai, I want to get the last inserted record from the table. Note: Table not having identity …
3 replies
Hi I wrote a stored procedure which inserts multiple rows into a database. After writing the store…
4 replies
By: daniel
Viewing 15 topics - 6,766 through 6,780 (of 17,081 total)
You must be logged in to create new topics.