Home > Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.
DTS closing SQL server
I have a DTS that runs fine from a client desktop - but the file being created is about 10M rows, so I want to run from the server to save time. When I go in using Terminal services directly to the server and try to map the DTS to a new tex...
I have a DTS that runs fine from a client desktop - but the file being created is about 10M rows, so I want to run from the server to save time. When I go in using Terminal services directly to the server and try to map the DTS to a new tex...
answer(0) view(363) status(
)
)
An easy one for you all!
I'm confident that this is a really easy function that everyone except me knows! Using SQL Server 2000 I have the following Query: Code: SELECT DISTINCT Busno FROM Route Which returns all t...
I'm confident that this is a really easy function that everyone except me knows! Using SQL Server 2000 I have the following Query: Code: SELECT DISTINCT Busno FROM Route Which returns all t...
answer(1) view(519) status()
)
DateTime Conversion and Comparison
Hi All, New to SQL and I'm having some trouble trying to do something simple. I need to pull data from a table that is corresponding to a month that is determine by the user. I have created a stored procedure and it looks like this c...
Hi All, New to SQL and I'm having some trouble trying to do something simple. I need to pull data from a table that is corresponding to a month that is determine by the user. I have created a stored procedure and it looks like this c...
answer(1) view(455) status()
)
Number of Days determination
hi friends, I have a Date.. i want to find the difference between that date & current date in days:hrs:min:sec format.. i'm a newbie to sql server..pls help me in this regard.. i already tried with datediff which returns...
hi friends, I have a Date.. i want to find the difference between that date & current date in days:hrs:min:sec format.. i'm a newbie to sql server..pls help me in this regard.. i already tried with datediff which returns...
answer(2) view(713) status()
)
Yes/No data type on microdoft sql ?!?!
hi guys , which data type i have to choose for the field , if i would like to make it only Yes or No 0 for no , 1 for yes?!
hi guys , which data type i have to choose for the field , if i would like to make it only Yes or No 0 for no , 1 for yes?!
answer(4) view(931) status()
)
how to insert an imageon on a field data type
i want to save an image on my db table field , then i choose that the the data type is image so what i supposed to put in this field , so when i call it throw an asp for example i will get the the picture ?!?!?
i want to save an image on my db table field , then i choose that the the data type is image so what i supposed to put in this field , so when i call it throw an asp for example i will get the the picture ?!?!?
answer(0) view(113) status()
)
MS sql server to MS access
my web system ( asp code ) is build in sql server database. After i change or convert to access database. my web system got an error ( Microsoft JET Database Engine (0x80040E07) Data type mismatch in criteria expression. ) pls help me a...
my web system ( asp code ) is build in sql server database. After i change or convert to access database. my web system got an error ( Microsoft JET Database Engine (0x80040E07) Data type mismatch in criteria expression. ) pls help me a...
answer(3) view(207) status()
)
SQL and Exchange
Has anyone ever tried to have SQL communicate with Exchange Server, where if you want to query the Exchange database to extract information?
Has anyone ever tried to have SQL communicate with Exchange Server, where if you want to query the Exchange database to extract information?
answer(5) view(272) status()
)
Querying on first few characters in a field
I have a query that pulls records based on data matching an ID field. Normally, the ID's are 3 digits and are all that exists in the ID field. However, the ID field sometimes contains two ID's (comma separated). So usually you have "73...
I have a query that pulls records based on data matching an ID field. Normally, the ID's are 3 digits and are all that exists in the ID field. However, the ID field sometimes contains two ID's (comma separated). So usually you have "73...
answer(2) view(316) status()
)
how to copy my Sql server Db from my computer and put it on a CD>>!
hay guys i have this simple problem , which is i already develop a database throw microsoft SQL server 2000 , and make the relatioships , but now i want to put them on a cd to put it on another computer. so which exactly files i have...
hay guys i have this simple problem , which is i already develop a database throw microsoft SQL server 2000 , and make the relatioships , but now i want to put them on a cd to put it on another computer. so which exactly files i have...
answer(1) view(985) status()
)
Restoring full-database on server
Hey everyone. I抦 stuck on something very essential. How do I transfer my entire SQL Database with tables,procedures and users from my personal workstation to another server? I used the Backup function to save a backup as a file. Restor...
Hey everyone. I抦 stuck on something very essential. How do I transfer my entire SQL Database with tables,procedures and users from my personal workstation to another server? I used the Backup function to save a backup as a file. Restor...
answer(4) view(553) status()
)
Computing a value
I'm wondering if someone knows how to do this. I am trying to add a sum of to two values within a column. I know it's easy but for some reason I can't this to function properly so I can use this value in Crystal. I'm trying to add hudnu...
I'm wondering if someone knows how to do this. I am trying to add a sum of to two values within a column. I know it's easy but for some reason I can't this to function properly so I can use this value in Crystal. I'm trying to add hudnu...
answer(17) view(907) status()
)
Select query
hi all does any one no how to using sql select * from table where id=x and then wanna select the next 5 rows from the record x
hi all does any one no how to using sql select * from table where id=x and then wanna select the next 5 rows from the record x
answer(5) view(948) status()
)
How do I get the record number when created?
How can I get the record number of a record when it is added to the DB? I'm trying to name a dynamically created table with the record number of a new record inserted into a different table. Any help is greatly appreciated...
How can I get the record number of a record when it is added to the DB? I'm trying to name a dynamically created table with the record number of a new record inserted into a different table. Any help is greatly appreciated...
answer(2) view(673) status()
)
group by
Select sum(Val1) 'Value 1', sum(Val2) 'Value 2', Case Valu3 When 'Green' Then 1 When 'Yellow' Then 1 When 'Orange' Then 2 When 'Red' Then 2 End From Table1 Group by Valu3 Value 1 Value 2 Valu3 59353881.0 56468059.0 1 ...
Select sum(Val1) 'Value 1', sum(Val2) 'Value 2', Case Valu3 When 'Green' Then 1 When 'Yellow' Then 1 When 'Orange' Then 2 When 'Red' Then 2 End From Table1 Group by Valu3 Value 1 Value 2 Valu3 59353881.0 56468059.0 1 ...
answer(1) view(352) status()
)
Combine update stmts into one
How I can combine these two update statement. I tried using a If Else but I received the following error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subq...
How I can combine these two update statement. I tried using a If Else but I received the following error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subq...
answer(1) view(367) status()
)
XML & SQL Server 2000
I am new to XML, and could use a little help. I am writing a program that will receive an XML feed, insert that feed in a SQL table, and then process the data. I will have access to a sample XML feed, the schema, and the DTD (none of whic...
I am new to XML, and could use a little help. I am writing a program that will receive an XML feed, insert that feed in a SQL table, and then process the data. I will have access to a sample XML feed, the schema, and the DTD (none of whic...
answer(3) view(237) status()
)
String Manipulation in Query Result
I have the following rows in a table, i have to write a query which returns results as shown Table Values Result -------------- ---------------- 100 --> 100 100N ...
I have the following rows in a table, i have to write a query which returns results as shown Table Values Result -------------- ---------------- 100 --> 100 100N ...
answer(1) view(828) status()
)
Sp Parameters using 'In()'
I have a MS Access projects database that抯 linked to an Sql Server database. I want to base my reports on stored procedures that have parameters. How would I pass an 慽n?statement to my parameter so that instead of @Location = ?/font>Dall...
I have a MS Access projects database that抯 linked to an Sql Server database. I want to base my reports on stored procedures that have parameters. How would I pass an 慽n?statement to my parameter so that instead of @Location = ?/font>Dall...
answer(1) view(881) status()
)
need a sql query
Hi All , i need to craete a query - as per following requirement . there is two table 1) spocemployee fields type lengh employeeid varchar 10 team varchar 50 2) employee ...
Hi All , i need to craete a query - as per following requirement . there is two table 1) spocemployee fields type lengh employeeid varchar 10 team varchar 50 2) employee ...
answer(6) view(649) status()
)
Update syntax
Does know where I am incorrect in this simple update? Update Revenue set Difference_Flag = 'Yellow' From Revenue where (select((TY_Revenue - LY_Revenue)/LY_Revenue)*100 = 0)From Revenue
Does know where I am incorrect in this simple update? Update Revenue set Difference_Flag = 'Yellow' From Revenue where (select((TY_Revenue - LY_Revenue)/LY_Revenue)*100 = 0)From Revenue
answer(1) view(242) status()
)
Problem with DAO OpenRecordSet
I am using a MS Access Project (.adp) to link to a SQL Server 2000 database. My problem is that I need to use DAO 3.6 in some of my code. I am using the following code and keep getting the following error. The code is falling over on the...
I am using a MS Access Project (.adp) to link to a SQL Server 2000 database. My problem is that I need to use DAO 3.6 in some of my code. I am using the following code and keep getting the following error. The code is falling over on the...
answer(2) view(568) status()
)
Link Access 2000 to SQL Server 2000
I have a table on an SQL Server, have setup a DSN pointing to the SQL Server and then a link to the table in an Access 2000 database. When using the following code keep getting the error message below: Run-time error '3622' You must u...
I have a table on an SQL Server, have setup a DSN pointing to the SQL Server and then a link to the table in an Access 2000 database. When using the following code keep getting the error message below: Run-time error '3622' You must u...
answer(2) view(310) status()
)
Filter
I need to write a query that pulls a single record, then tie the form to the query. I would probably need a parameter in the query that specifies which record to pull, maybe the primary key value from the table (for example, Account_Num). ...
I need to write a query that pulls a single record, then tie the form to the query. I would probably need a parameter in the query that specifies which record to pull, maybe the primary key value from the table (for example, Account_Num). ...
answer(1) view(821) status()
)
Comments in views and procedures
I am new to sql server and thought it was great that you were able to comment what you were doing when writing sql. I was using query analyzer to work out some of my sql. I even learned how to use the if and case statements creating comm...
I am new to sql server and thought it was great that you were able to comment what you were doing when writing sql. I was using query analyzer to work out some of my sql. I even learned how to use the if and case statements creating comm...
answer(2) view(826) status()
)
Convert char to DateTime
All, I must convert a char to a datetime. What function do I have to use ? Code : declare @Date datetime declare @StartHour char(100) select @Date = ShiftDate from inserted set @StartHour = rtrim(convert(char(2),DATEPART(dd, @Date))) + ...
All, I must convert a char to a datetime. What function do I have to use ? Code : declare @Date datetime declare @StartHour char(100) select @Date = ShiftDate from inserted set @StartHour = rtrim(convert(char(2),DATEPART(dd, @Date))) + ...
answer(1) view(492) status()
)
a query : this one stops me
Hi again, I was practicing queries and this one I tried to find how to write it but I can't find how to do it. I think a single table is enough. The table : CREATE TABLE COURSE ( NUMCOURSE NUMERIC(4) PRIMARY KEY, DATECOURSE DA...
Hi again, I was practicing queries and this one I tried to find how to write it but I can't find how to do it. I think a single table is enough. The table : CREATE TABLE COURSE ( NUMCOURSE NUMERIC(4) PRIMARY KEY, DATECOURSE DA...
answer(3) view(473) status()
)
basic : how to insert a date in a table ?
Hi all, I am new here. I am a student and I am working on SQL Server 2000. I am kind of lost ... I have never used it in the past. I am trying to create a database and one of tables has a date. I couldn't find how to declare a date, I chos...
Hi all, I am new here. I am a student and I am working on SQL Server 2000. I am kind of lost ... I have never used it in the past. I am trying to create a database and one of tables has a date. I couldn't find how to declare a date, I chos...
answer(5) view(51) status()
)
Automated procedure calling
I'm working on a database where i currently have a table with active and inactive product and i wish to move all the inactive products to a new inactive product table. But i want to add the flexibility of whenever the status change for a p...
I'm working on a database where i currently have a table with active and inactive product and i wish to move all the inactive products to a new inactive product table. But i want to add the flexibility of whenever the status change for a p...
answer(1) view(272) status()
)
Stored Procedure doubt
I wanted to know whether there is any limitation of stored procedure. If yes whats that limitation? Please help me knowing this Sony
I wanted to know whether there is any limitation of stored procedure. If yes whats that limitation? Please help me knowing this Sony
answer(2) view(229) status()
)
Programming
Related Pages
- Temporary Tables
- Gruop By And Sorting Records..
- Where to Install SQL Server for best performance
- How to get recordset from Stored procedure?
- Deleting data by calling the stored procedure in the .NET
- connecting to postgres database
- Recovering SQL database on new PC
- SqlMembership users
- Stored procedure returns unpredictable results through OLEDB
- cross referencing tables
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved