[mssql] Forum Topics

I got some experience working and managing ms sql databases, but now I am in a need to replicate 2 databases and I can't make it work. Please advise. If it's possible step by step. Thanx

Hi, I've had a website built for me using asp and mssql. Im getting errors relating to the date format in queries being submitted. The asp is trying to insert dates in format dd/mm/yyyy, but after testing my mssql server is expecting the dates in format yyyy/mm/dd. Is there a …

Hello every body, Iam santhosh .I need help.Iam using MS Sql server 2000.I have one database.In a column of one table i haved set that to identity property that property generating serial numbers for that table .But that table is not updating. Table 1 Sno SID Name 1 212 Klen …

Does anyone know how to connect to an MSSQL View in syntax. If you know please right back asap. I need this project done quick. Thanks.

Gallery database -------------------------------------------------------------------------------- Hello averybody I would like to know your opinion how do you design a database that will works as photo gallery, let's count there will be a lot of pictures. Do you save the pictures on the disk or directly on the database? Write please your ideas …

while iam running a jdbc connection program iam getting the following exception : Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.jdbc. sqlserver.SQLServerDriver at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at DBCreate.main(DBCreate.java:7) plz …

I have a value E101 as my empId in my employees table and now i need to increment this value, i.e. E102, E103...etc. How can i get this to work? I've used the procedure but it's not working what am i doing wrong? ALTER PROCEDURE CalcPrimaryKey AS DECLARE @numValue int, …

[B][I]MSSQL Where Statement Problem[/I][/B] [COLOR=BLACK] [LEFT]I want to select all in a column if variable = null I am placing a php variable in there and i know how to do that so i no that is not the problem but i want a where statement to return all rows …

Situation table1 has 2 columns: userid and requiredInfo It will have an entry for every user table2 has 2 columns: userid and optionalInfo It will have entries for some users but not others Problem: need a statement that returns either userid, table1.requiredInfo, table2.optionalInfo --if table2 has an entry OR userid, …

PLs could somebody tell me how in MS SQL set the default value of a column as the sum of 2 columns column3=column1+column2 where column3 is bigint column1 and column2 are int column1 is primary key with identity incresed by 1 if posibble column2 is a column from another table …

hi all i wanna to use sql server 2005 but i never use it or any sql server before can any one help me what steps i should follow to learn it i will use jsp . as i used it before but with access thank u

Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I …

I'm working with sql servre database I have two tables in the same database. thse are my tables, [code] CREATE TABLE [dbo].[Applicant] ( [UserID] [int] IDENTITY (1, 1) NOT NULL , [UserName] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails2] [varchar] (50) COLLATE Latin1_General_CI_AS …

Hi, I have a database table which has a Field called birthday.I want to write SQL script which automatically search database every day and if someones birthday equal today then display a reminder(alert).how can I do this? can anyone help me? Thanks, aish. :o

I have asp.net C# web application I want to search jobvacancy details using jobrole. if user did not select any value I want to select all the details including null values. this Jobvacancy table has JobRole feild and it allow to insert null values, this is my stored procedure [Code] …

hello i m using MSDE version with the web site i have developed for ASP but i m unable to create guest user for internet access, which is defult builtin account by windows plz help me this is very urgent issue for me take care bye

I run MS SQL 2000, database is growing and my concern is the hard drive will soon run out of disk space. i wonder if i can add a new hard drive and tell SQL there is more space. my question is how i can combine the two hard disks …

This is about a stored procedure I'm working on. I have a field which gives me a value of datetime type. I need to display the 6 months starting from the month in the field. E.g. field gives me Feb, I have to display Feb, Mar,April, May, June, July seperately. …

I'm trying to populate a table from a sub-query. [CODE] CREATE TABLE test ( ID int ) INSERT INTO test VALUES (SELECT [Customer Id] FROM [Customers]) [/CODE] QUESTION: I know you can do this in ORACLE but Is something like this possible in T-SQL. I can also write something like …

How would you calculate the difference between two dates?

I have developed some webpages using asp and they work fine on my computer with Access 2003 (using iis as a local server). However, I am aware that SQL 2000 is a better db to use, but I am not sure in which ways. Since I intend to put my …

i decided to switch over to ms access (thinking it would be easier) from mssql but i am having the same problem that i had with ms sql: "SQL Server does not exist or access denied" i have put the ms access db into the web server from the web …

ok, here is the script I ran to create the stored procedure [code] SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE [insertFunction] (@Id [int], @class [nvarchar], @type [nvarchar], @name [nvarchar]) AS declare @classID [int] select @classID = tblClass.ID from tblClass where tblClass.Name = @class INSERT INTO tblFunction ([ID],[Name],[ReturnType],[Class]) …

Hi, I have a dts package that I created which uses an odbc connection to go and copy a dbf file using visual fox pro drivers. The package runs fine when I execute it. But whenever I try to use the sql server agent to run it as a job …

The MS SQL 7.0 Server is installed on a Windows server, not placed in my home. I want to make a SQL query from my home, using java JDBC, but I get an error: java.sql.SQLException: Network error IOException: Connection timed out: connect - This error I don´t get if I´m …

Hi, I am in the process of deciding the database and application language. We have exising MS SQL server running on windows OS, to save the company's product data, right now I need to build another seperate system for intranet use, as I am more familiar with PHP+Mysql, I want …

I need a help. I have a SQL SERVER database where I have put persons with their birthdate. I need to calculate ages of them. For examble my birthdate is 12/27/1982 and I have to debit (minus) from current date. Does anyone have any idea how to solve this problem.

Can someone enlighten me on this issue ? I have data source A - with a stored procedure in which I'd like to select records from tables in a different data source, B.

SELECT NZDate - CAST(NZDate - '2005-01-01' AS int) % 7 AS WeekStarting, sum(score)/7 from myTable where (NZDate between '2005-01-01' and '2005-01-21') and name IN ('John','Bob','Harry') group by NZDate - CAST(NZDate - '2005-01-01' AS int) % 7 order by weekstarting Hi, I have a query (above) that given any start date …

Current app runs a stored procedure which runs 16 nested procedures and takes from 3 to 10 min depending on how must data needs download from the as400. The problem is that there are some other web apps on the web serverr that use old com objects that have memory …