Topics
Started by
Posts
Last post
I have a table in SQL2000 with about 2.9 million records and I need to count the number of distinct…
5 replies
hi friends I've following simple query which will return new id everytime i insert new row into a t…
5 replies
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LV_Group]') and OBJECTPROPERT…
2 replies
Interesting, if somewhat frustrating, morning... A couple of weeks ago, one of our developers compl…
15 replies
I am trying to import new zip codes into an existing database. However, I only want to add new one…
8 replies
I am deleting rows out of a table, when I insert values back in the primary key is starting the num…
5 replies
Hi ppl, I need a little help with a sql statement I have 8 fields like this q1a,q1b,q1c,q1d,q2a,q2b…
11 replies
How do you add a NOT NULL CONSTRAINT after the column was created ALTER TABLE dbo.STATES ADD CONSTR…
4 replies
Hi SQL Gurus, I am facing problem with data type datetime. I am writing sql queries which will be c…
3 replies
What is the best way to create a proc that takes in a 'Path' parameter and then dumps the result of…
2 replies
I have a table with a field: cfield1 char(10) NOT NULL default '' I need to change this field progr…
1 replies
I am trying to write a stored procedure that has nested cursors. The table name of the second leve…
10 replies
Hi all, A newbie question for you all. I'm trying to use sp_dboption to make the same change on mul…
6 replies
Hi, I am writing following code: SET QUOTED_IDENTIFIER OFF Drop Table #T1 Create Table #T1 (UID int…
2 replies
Does anyone know how to write this Oracle update statement for SQL Server? I can't seem to find a …
3 replies
Viewing 15 topics - 13,966 through 13,980 (of 17,082 total)
You must be logged in to create new topics.