SQL Server Newbies
-
Topics
-
saving and retrieving jpeg or bmp files?
I understand that you are able to save and retrieve picture files to a SQL server, is this correct,…
-
Primary key Violation Error In Cursor
Hi Everybody, I am writing a cursor for change the Zone_Id column in a table. I don't know this z…
-
Set ANSI Warning Off
I am creating an SP and I forgot what the code was to turn the little messages off is something did…
-
An INSERT EXEC statement cannot be nested
Hi, I want to record the (file) sizes of database and logfiles periodically. I’ve found a nice stor…
-
Beginner in Sql 2000
I'm a beginner in Sql 2000 and in this forum too. I have two tables, one with general informa…
-
How to convert rows of data into table stucture
Hi all, This is very simple but I don't have the know how... I want to take a column (field) and ma…
-
Job is failing with error: "Could not complete cursor operation because the table schema changed after the cursor was declared"
Hi All, I have a job which is failing sometimes
with the error "Could not complete cursor operati… -
Tutorial on Administration
Hello All, I have never been into Administration of SQL, I am a programmer and fluent with SQL quer…
-
Differences between MSDE and SQL 2000
Is their a fundemental difference between MSDE and SQL 2000? The reason I ask is that I am de…
-
Decimal/float/etc.
Can someone explain to me whether it's best to use decimal or float when dealing with monetary amou…
-
A Question on IsPersisted Property of Computed Columns
Hi all, I have a pretty basic question on computed columns. What difference does it make if the IsP…
-
Can''t create local DB (SQL 2k)
I cannot seem to create a local database. I have used sql server 2000 for years on a remote s…
-
problem using MAX on date
I've used the stored procedure below on a database I keep a caller ID log on, basically there is a …
-
Stored Procedure vs Function - Calculations
Venturing off into a new area... I have written a stored procedure which retreives a recordset base…
-
Dates
What's the best way to get a yyyymmdd field into something useful for publication... i.e. 12/5/1950…
Viewing 15 topics - 1,546 through 1,560 (of 2,871 total)
You must be logged in to create new topics.