Could someone have a look at my below delete statements and inform me how I could modify them (so that they work :)) to include the inner join and where not exists. At the moment I get the err...
I would like to know how can i reduce the size of .LDF file?????
The log file of one of the databases on my SQL SERVER 2000 has grown to over 123GB. I need to shrink it down and control it's growth. It's on a 250GB drive with only 15GB free.
In SQL Ser...
how do i do "OR" inside the case statement?
please look at the below sql query:
SELECT
id,stat,
(CASE (flag_cd)
WHEN '1' THEN 'asdf'
WHEN '2' THEN '23423' END) AS mystatus,
(C...
I'm attempting to write a function that will provide me with next day of a given date. For instance, if the date I have is April 8 2004 (thursday) and I need the first monday following that d...
Is there a TSQL command to remove the identity attribute from a column? I can add one easily enough, and know that I could do this through the UI, but really need a TSQL query for this. I'm ...
Setup:
SQL Server 2005, VB.Net 2005 Windows Application
Problem:
at present i have a VB.Net program that creates CSV files, its opening the datareader and writing to the CSV File. the pro...
I tried to give myself datareader and datawriter for my domain login and got this error below. I'm logged into the server with my domain account which has admin rights.
TITLE: Microso...
Greetings!
I've written a stored procedure which pulls data and dumps it into a temp table...however, I'm trying to figure out if its possible to send the data (hundreds of rows) to a text ...
I'm working on an ASP.NET application that will update times from a table. I have a stored procedure to select the data that formats the date as a time value only, for example 16:00. In the ...
I'm trying to get the count of unique records returned to a subquery. The query returns 1 row for each deptement. I need to reach across to another db where all users' logins are recorded. B
...
Hi Experts,
I am junior Sql DBA. I have migrated a few Databases from sql 2000 Sp4 on windows 2000 server to sql 2008 on windows 2003 server. I had no issues during migration, when i ran th...
Hi All,
I am needing to create a temp table using Where NOT EXISTS. I am trying to compare data from the temp table and a permanent table to see how much data is missing. What am I doing...
I need to alter an existing column and I cannot seem to get the syntax editor to like what I enter or if it likes it, I get invalid data type.
ALTER MyTable ALTER myColumn int IDENTITY(1,1)...
I'm getting the following error when I try to import a database from our live server to our test server:
Could not find server 'tmviis1' in sysservers. Execute sp_addlinkedserver to ad...
How do I convert a field with the type of datetime to int ?
I need to convert the data it contains too.
Thanks !
To me this makes perfect sense, but it never matches anything. However, I know there are some identical IP's in each of the two columns.
select distinct col_DestinationIp, col_SourceIp from...
Why doesn' t the following work in the scalar valued function? I keep getting an error:
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value '10/16/' to ...
Good afternoon expert,
Have installed MS SQL Server 2005 (I think) but
I can find no Enterprise Manager when I go to
Start, Programs, Microsft SQL Server, the only
option available is ...
I have a file located at c:\mydb.7.7.2006.bak. I need to restore it to a location on my local computer running win xp with sql express.
Here is what I have done:
restore filelistonly
...
Hi, I can limit the rows by the rowcount with the following code, but how can I get the row count with the same query. I don't want to run another query because of performance issues.
I have a problem with sorting a alpha numeric field.
location_tag (type nvarchar(50))
1
2
3
4
10
11
20
Pad A
Pad B
If I do :
"SELECT location_tag from location ORDER BY locatio...
I am in the process of upgrading the default instance of SQL Server 2000 to SQL Server 2005 on Windows Server 2003 SP2 machine. This server is set to mixed authentication and all passwords fa...
My stored porcedure receives a very large number as a string something like this:
'123456789333501E+15'
and I need to convert that to a numeric value with 25 digits but if I try and call...
Hi ,
I have a VB program which access MS SQL Server.Sometimes the program encounter this problem.
Error:[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network docu...
