If I have a date in a sql table 1900-01-01 00:00:00.000 how do I display it as 1/1/1900?
The below statement returns: 01/01/1900.
select convert(varchar, getdate(),101)
Sql 2000
Hello,
I need to be able to update the SQL command default timeout of 30 to something greater. I KNOW this can be done super easy through code, however, I do not have that luxury and need ...
if sp returns resultset with variable column count, how can i insert it into #temp?
for each name, there is a column in recordset from myproc.
----
create table #temp ( id int, val varchar...
I realise this question has no doubt been asked and answered many times, however I'm asking it anyway.
I need to convert a varbinary data type to Varchar so the results are viewable to cert...
I need command or script to convert rows into columns or vice-versa in MS SQL 2000. Any one has ideas or commands?
Hello,
I have a query and I want to retrieve the last 10 rows instead of the first 10 rows.
I know that the typical way is to just switch the order that you sort on.
But, I need the b...
I am trying to convert a date (in milliseconds) to Date Time format from 1/1/1970
I am already able to convert the current date/time into milliseconds using this code (snippet):
But I ...
I'm just curious if someone can give me some info about sp_execute and what it's used for.
How do I calculate thee week of the year if my fiscal year does not start Jan 1.
Some years will have 53 weeks and I would like to calculate that as well
I know that these values will have t...
when i write Store Procedure
use by Linked Server Connection
CREATE PROCEDURE MyProc as
Select * from [LinkedServer].DBname.dbo.Mytable
go
when app...
How do I change the value of an identity column for a record?
I am trying to do something like the following, where ID is an identity column.
UPDATE COMPANY SET ID = 7 WHERE ID = 6
When I try to do this, I get an invalid syntax near ',' error. Is this not possible? I am just trying to get a count of how many insurance claims each individual member(memid) has for each pr...
Hi, I have set a linked server sql2k sp3 in another sql2k sp3.. when i try to run a job I'm geting the following error:
The operation could not be performed because the OLE DB provider 'SQL...
i am getting this error Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ':'.
Server: Msg 259, Level 16, State 2, Line 4
Ad hoc updates to system catalogs are not e...
I've imported a CSV file into my SQL server where it sits a table. All the datatypes are VARCHAR. There is 1 field that I would like to convert from VARCHAR ->>NUMERIC with 2 decimal places; ...
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...
If I run this query on my database:
DELETE from products
WHERE id='30'
I get this error:
Delete statement conflicted with COLUMN REFERENCE constraint 'FK_product_g_prudu_OF582957'. The ...
I have a table named Table1 contains records like the following,
field name data type length
------------ ----------- --------
field1 nv...
Does anyone have any experience of migrating SQL Server servers from standalone servers
to virtual servers running under VMWARE ESX
The environment i have is a mixture of Windows NT4 and...
hi i get this error when trying to load SQL Server Management Studio Express. i used CTP version previously. i uninstalled the CTP before installing the new one.
both also gave me this erro...
HI,
I have a default install of SQLEXPRESS installed on my worstation. The instance of course is named localhost\SQLEXPRESS. Is there a way to change the instance name to just "localhost"?
...
For the life of me I can't figure out why this is not working.
My SQL Server is set to using US dates. I have a list of dd/mm/yyyy formatted strings that I would like to update the smalldat...
I want to get back a recordset based on a nested sql statement that returns a count of 0, but I can't remember the syntax. It needs to return the count based on a field in the parent sql state...
I am getting an error when i try to parse the query:
Server: Msg 2714, Level 16, State 1, Procedure ap_rpt_chunit, Line 32
There is already an object named '#baseline1' in the database.
S...
I am looking for a good How to Guide on setting up a cluster for SQL 2005 ent on a Win 2003 ent box (2 servers exactly the same) SAN is not yet installed but will be soon. I know i have to wai...
