Topics
Started by
Posts
Last post
Hi all Let i have a table named test and in that table 20 records are there When i execute th…
37 replies
Hi there Was trying to update various columns from varchar(2000) to nvarchar(2000) in a table and r…
6 replies
Here is my code: declare @p1 int, @p2 int, @server varchar(16), @dB varchar(16), @sproc_call varch…
6 replies
Hi, I need a set based solution that will incrememnt a column based on the Max value of anot…
16 replies
This works sp_who 'keough', (it gives me only my SPIDs). This, sp_who2 'keough' gives me all …
5 replies
good morning guys! i tried to create a one-to-many relationship between two tables not in the same…
6 replies
Hello, I would like to use a cursor to browse through a chosen sub-set of the databases resid…
5 replies
Here is a query I use to add up some number. The counts for lcount and scount total up to match tot…
3 replies
Hi Friends I want to change datatype of a column from text to varchar.I know i can do one at a time…
15 replies
Hello, i have this query SELECT sum(draw) as tot_draw , sum(returns) as tot_returns, s…
11 replies
Greetings all, I have been asked to submit data to a third party. The format is really a pain so he…
4 replies
Greetings all. Does anybody know of an elegant way in SQL Server 2000 of achieving the results of t…
12 replies
I need to select the next available customer from a list and automatically feed it to an agent…
3 replies
When I run the script below (#1), I receive an error (#2). All seems fine regarding the prope…
2 replies
Which command using Query Analyzer will give you the version of SQL server and operating system &nb…
3 replies
Viewing 15 topics - 9,451 through 9,465 (of 17,082 total)
You must be logged in to create new topics.