Summary: Hi! i would like some help to figure this out: How can i select a datetime field in sql server in an specific format? ie: when i execute: select (date...
Summary: I have developed a few reports on SQL Server 2008+VS 2008 and deployed them to the SSRS built in reporting URL (http://servername/reports) During the ...
Summary: Hey All, I think I may have a corrupt table in SQL Server. When I go in through Enterprise Manager and I right click on one of my tables the followin...
Summary: I have created a table in SQL Server as- create table weatherreport (places varchar(20), cdate datetime, maxm int, minm int, vdescription varchar(40))...
Summary: Hello, I am Software Development Intern at a small company. We run Microsoft SQL Server 2000 on Win2k. One of our database tables was recently destroy...
Summary: When I Add or Configure a DSN using SQL server as a datasource, on the screen which pops up with the Name, Description and Server field - there is a d...
Summary: i just cant connect to my MS SQL server. the server is MS SQL server 2000 enterprise edition (installed in w2k advanced server), and i'm connecting to...
Summary: When using SQL Server or MySQL, is there a way to create a statement to update/change a letter in a field. Specifically if I have a list in a specific...
Summary: Hello, I just installed SQL Server 2005 Express, and am having trouble starting the Service for it. I accessed the SQL Server Configuration Manager, a...
Summary: I am trying to update a field in a sql server table. There are times when I may get multiple records returned in which case they will all need to be ...
Summary: I am trying to connect to a SQL database on windows 2000 advance server and it returns the following error when I want to connect SQL Server through t...
Summary: Greetings Maina, I am not a very experienced programmer but I would like to try to help in some way. If you have SQL Server 2008 and Visual Studio 200...
Summary: Hi, We have just installed visual studio 2008 which includes sql server compact edition 3.5. We want to export an sql server 2000 based database to ne...
Summary: After installation of SQL Server 2005 Developer Edition, only have Configuration Tools available, I have XP SP3, and I have SQL Server 2000 already in...
Summary: I am using windows 2000 recently the Ip of my system has been changed and now I am unable to connect to the databse server can anybody tell me that ho...
Summary: Hi I am new in SQL server. I am trying to find out which tables contain a specific column name in entire database. Is there any equivalent dictionary...
Summary: Hello, here is my short script in sql server 2000: [b]Create Table #tmp(ID int,y_val char(30),...) Insert Into #tmp exec stored_procedure[/b] now my #...
Summary: dear all, i have made a stored procedure to generate auto id . when iexecute the pro i get folowing error: Incorrect syntax near '0'. at the highlig...
Summary: I have a database in SQL Server that already has tables and data in it. I also have and Excel 97/2000 workbook which has sheets named corresponding to...
Summary: I have two very different reports that I have to run to get all the info out of an inventory database. The first one extracts the current inventory, ...
Summary: I try to include MS Access 2003 crosstab query design code (internally generated SQL) into a VB6 module. Here is the ColumnHeadings definition which ...
Summary: In the interest of the first one to post on the forum and because I'm having a tough time wrapping my head around this one, here goes: I have a table ...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
