Hi,
How can I get the 50 to 100 records of a select query (something like "rownum > 50 and rownum < 100" in Oracle)?
Thanks
I'm looking to return a date format of DD:MM:YY in query analyzer and I keep getting the same format (YYYY:MM:DD)..
Here is my query: select convert(smalldatetime, getdate(), 1)
I also ...
Hi
How do you escape an american apostrophe (') to be input into a text field in MS SQL Server 2000
I don't have a choice but to use an actual apostrophe because this is for a language ...
I am missing something but do not know what it is.... i am trying to convert the Amount Field which is a varchar to a float... please Help
INSERT INTO tblLSWA15
(PolicyNumber, CompanyCo...
Just quickie,
I need to return a string value based on data from a column.
For example, if data from a column contains "0" I need to return the string "Z", if it doesn't I need to return "...
Hello, I'm a relative newbie to this since the SQL database person at my work is out for an extended period of time. Recently, on of the applications we use stopped working and returned the er...
I want to convert integer into date format.
Example :
Database 1 : import_date(field)(value is in format ddmmyyyy - e.g 10012003)
Datebase 2 : importdate(field) Format is datetime
I ...
Hi There
I am trying to import data into my SQL server from a csv file. I imported the file into a staging table on the SQL server, and all fields are varchar (8000).
I am using the code...
Attempting to repair_rebuild database.
1. Stopped SQL services by running sqlservr -m within the command prompt
2. Logged on as Sa within Query Analyzer
3. Executed command Dbcc Checkdb('S...
To create a new instance I would normally reinstall SQL 2005 and create a new instance but this does not work. I have installed SP2 and currently have one instance with SQL 2005
When I use...
When I look at my DBs in the MS SQL Server Management Studio, I have three DBs that say (In Recovery) next to their names. One of the DBs have been this way for over 12 hours.
What is the ...
I have a database in SQL Server 2000 where the MDF file is 61MB and the LDF file is is 5.3GB. I am not sure why the LDF file size is so huge! How can I shrink the LDF file? Will shrinking t...
Hello,
I have an issue and I cant figure it out. I have a date column that shows as 8/30/2002 in MSSQL. When I export it to a txt file it shows as 2002-08-30 00:00:00. I need the date ...
Can't quite get my head around this Run-Once script, at the moment, appreciate any quick help, so I can get on with my favourite job, reviewing all the uploaded images, for approval. - LOL
ht...
How do i compare new and old value in a trigger after update?
if update() is no good because i want to know if the value is changed and not if the column was updated.
Keren
Hi Experts
I have tables whose IDENTITY starts at 100; I use 1 to 99 for Test ID's. So, I frequently have to clean out these tables and start again, during development. What is the easiest ...
How do I list all the tables in a database?
I'd like to cycle through all the tables in a database and push the contents into an ado.net dataset for export to an XML file.
This would be fo...
not familiar with sql server stored procedures. i am only knowledgable in oracle and informix.
i need to know if it is possible to return a loaded resultset from a sql server stored procedu...
Hi All,
I am taking a chance on this.I am using SQL Server 2005 with t-sql syntax.
Now this is a bit of a guess that this would work as the other ways didnt:
I have 2 databases.
I am ...
I have a user that gets this error when opening an application:
"Unhandled exception has occurred in your application. If you click conttinue, the application will ignore this error and att...
Hi,
I've wrote a search module for SQL Server 2000 a while back and it produces queries like:-
SELECT tblSection.SectionShortDesc as SectionShortDesc, tblPage.PageID, tblPage.PageName, t...
Dear all,
I know this question has been asked many times, but I still got the error after tried their solution.
I have MS sql Db table named [Testing] contains four rows and column
[my_...
is there any built-in function or udf to convert Timestamp to Readable date/time format.
pls help me with this.
tnx in advance!
Hi guys
Has anyone found a method in sqlserver 2000 to 'aggregate' strings in a Group By query. Like using 'Sum' for numerics...
e.g. table values:
cGroup cText
A L
A ...
I have a field in table Appointment called Memo (type text)
I would like a sql script which will remove all carriage returns in the text of the memo field and replace with a space or colon or...
