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 created a table in SQL Server as- create table weatherreport (places varchar(20), cdate datetime, maxm int, minm int, vdescription varchar(40))...
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 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: 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: 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: 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: 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 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: I think you should stick with SQL express. The .NET System.Data.Sql namespaces work very nicely with it and in general your code will look a bit clea...
Summary: I am trying to create a search function in a form. it wil search the specified table and return the results in a subform on the same form. This is the...
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: 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 currently working in mainframe.I like to learn SQL.can anyone suggest the best way to get excel in SQL and ORACLE. how the SQL differ from O...
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: 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...
![[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
