Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
1,775 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 36
Page Size: 10 · 25 · 50

Tag filtered by:  SQL2000 [x]
Article 13 May 2013   license: CPOL
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables
SQL2000SQL2005SQLSQL-ServerDBADevBeginnerIntermediateSQL-ServerSQL2008, +
Answer 13 May 2013   license: CPOL
See my past answers: How to restore table after delete[^]Rollback DROP TABLE command[^]database could not be restored[^]Undo update command in Sql Server[^]
SQL2000SQL2005SQL-Server
Question 13 May 2013   license: CPOL
How to recover the deleted data from Previous year????Please help me anybody....
SQL2000SQL2005SQL-Server
Answer 10 May 2013   license: CPOL
It is a permissions issue. When it runs as a job it is using the account on the SQLAgent. Whatever account is running your SQLAgent service will need to have proper permissions. I believe there is also a setting in the job to tell it to use a specific account.
SQL2000SQL-Server
Question 10 May 2013   license: CPOL
Hi All,I have trying to copy one databse from one server to another server.DTS package run manually, but the DTS package fails when it is scheduled to run as a job. Executed as user: ServerName\WindowsAuthontication. ... DTSRun OnStart: DTSStep_DTSTransferObjectsTask_1 DTSRun...
SQL2000SQL-Server
Catalog 7 May 2013   license: Commercial
dbForge Data Compare for MySQL is a tool to compare and synchronize data of MySQL databases. You can quickly analyze data differences in a well-designed user interface and synchronize comparison results in a convenient wizard with additional options.
SQL2000SQL2005SQL-CESQLSQL-ServerDBASQL-ServerMySQLOracleSQL2008
Answer 6 May 2013   license: CPOL
Sometimes all the alternative solutions to resolves the errors in SQL database is fail, at this condition you need trustworthy program which solves all errors and get out of this circumstance. At that point of time you can use SQL Server database Recovery Software that helps you to extract data...
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008SQL2012
Article 5 May 2013   license: CPOL
CAST(), CONVERT(), PARSE(), TRY_PARSE(), TRY_CONVERT(), FORMAT(), SQL Server Functions, SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.
SQL2000SQL2005SQL-ServerDevBeginnerIntermediateSQL-ServerSQL2008SQL2008R2SQL2012
Question 4 May 2013   license: CPOL
How can I Crack dbforge sql complete standard edition?
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008sqldatasourceSQL2008R2
Article 2 May 2013   license: CPOL
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Date and Time Data Types and Functions with Sample SQL Statements. Data Type Tables, Function Tables
SQL2000SQL2005SQLSQL-ServerDevBeginnerIntermediateSQL-ServerSQL2008SQL2008R2, +
Answer 2 May 2013   license: CPOL
select * from ( select Row_Number() over(Partition by KitComponentID,Created_on order by KitComponentID,Created_On desc) as SrNo, * from tblnm ) as tmptbl where SrNo=1for sql 2000select * from tblnm t1 where t1.stgID = (select top 1 stgid from tblnm t2 where...
SQL2000SQL-Server
Answer 2 May 2013   license: CPOL
You should try the SQL server recovery software for your recover corrupt SQL database . This software is recovering corrupt database (.mdf file) and effective data recovery services for all users.
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008SQL2012
Question 2 May 2013   license: CPOL
Hello All,I have one table with columns and values like belowstgID--CMD---KitProductID---KitComponentID--KitQty created_On updated_On14-----Insert-26532-00-0131--26532-00-0123--123 ---2013-05-01 18:50:50.447 2013-05-01 18:50:50.430 15-----UPDATE-26532-00-0131--26532-00-0123--123...
SQL2000SQL-Server
Answer 30 Apr 2013   license: CPOL
Please, see this: Adding Rows by Using INSERT and SELECT[^].Another solution is to use: CTE[^]. You did not provide enough information, so i can't show you an example.
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008SQL2008R2
Catalog 30 Apr 2013   license: Shareware
LinqConnect is a LINQ to SQL compatible ORM solution with extended functionality, support for SQL Server, Oracle, MySQL, PostgreSQL, and SQLite, its own visual model designer, seamlessly integrating to Visual Studio, and SQL monitoring tool.
SQL2000SQL2005SQL-CE.NET3.5C#ASP.NETXMLSQLWindows.NET, +
Question 29 Apr 2013   license: CPOL
I have two temporary table #CoreUtilizationForRole1 and #RoleID2Details. I want to insert values into a third temp table using these two temp table. Below are the table Structure of both the Temp table.create table #CoreUtilizationForRole1(roleid int,SupervisorName...
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008SQL2008R2
Question 29 Apr 2013   license: CPOL
I am getting output for a report in SQL as mentioned below :-create table ReportCustom (RoleID int, Supervisor varchar(250),UserECode int, UserName varchar(250),TimeSpent float,Activityname varchar(250))goinsert into ReportCustom values(1,'Naveen Kumar Chitrapu',20201,'Uma Maheshwar...
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008SQL2008R2
Answer 29 Apr 2013   license: CPOL
In SQL you can't really determine the order that records will appear (physically) in the table. You can control how they are retrieved though for example you could use select * from OutputReportCustom order by UserECodeIf it is really important to you that the records are retrieved in the...
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008SQL2008R2
Answer 28 Apr 2013   license: CPOL
*Nodding to Zoltán Zörgő*It's almost certainly down to your table definition ... best demonstrated with an example ...-- This version will FAIL if there is a null in FKIDcreate table parent( ID int IDENTITY(1,1) NOT NULL, SomeData varchar(20), CONSTRAINT PK_parentID PRIMARY KEY...
SQL2000SQL-Server
Answer 28 Apr 2013   license: CPOL
I recently had the very same problem in linq. I had another column that I could declare unique. I allowed the column to have null values, and thus, I could use it as a foreign key. Often, you tend to grab the primary key, but when you do so, you must realize that the foreign key and the...
SQL2000SQL-Server
Question 27 Apr 2013   license: CPOL
I define a primary key on column and I define foreign key in the another table. If I enter null value in the foreign key column it is showing the error.How to allow the null value in the foreign key?
SQL2000SQL-Server
Catalog 27 Apr 2013   license: Free For Personal Use
SQLServerBooster is an application for DBA or people that do programming around Microsoft SQL Server ® and need to make backups automatically, compress and send through FTP, Amazon S3 ®, Amazon Glacier ®, Windows Azure ® or network.
WinXPWin2003VistaSQL2000SQL2005WindowsSQL-ServerDBADevADO.NET, +
Answer 26 Apr 2013   license: CPOL
Try:SELECT MIN(Id) AS Id, Name FROM myTable GROUP BY Name
SQL2000SQL-Server
Question 26 Apr 2013   license: CPOL
Hello All,I have a table likeId Name 1 Naveen2 Naveen 3 Kumar 4 Kumar 5 Alex 6 Alex I want out put like belowId Name 1 Naveen 3 Kumar 5 Alex Please help me on this... I have used Rowcommand()...
SQL2000SQL-Server
Article 24 Apr 2013   license: CPOL
Create a SQL Server database using C#.
.NET1.1Win2KSQL2000VS.NET2003C#SQLDBADevIntermediateWindows, +
Tip/Trick 24 Apr 2013   license: CPOL
Custom StringPadding functions for SQL Server
SQL2000SQL2005SQLSQL-ServerBeginnerIntermediateSQL-ServerSQL2008
Answer 18 Apr 2013   license: CPOL
You need to set up a column with the IDENTITY property (link to documentation[^]The number will automatically be incremented everytime you add a row. If you delete a row the id number is not reused, so the number can be deemed to always be unique within this table.Be very cautious of...
SQL2000SQL-Server
Answer 17 Apr 2013   license: CPOL
I think you're after a group of related TSQL statements, all of which summarily perform the above desired work:USE [cpqaAnswers]IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[cpqa].[tbl_ID_ProcessDCI]') AND type in (N'U'))DROP TABLE...
SQL2000SQL-Server
Question 17 Apr 2013   license: CPOL
Hi AllI have to generate serial number which will insert in table if we delete any row from the table then it should serialize the number now I have a Store procedure through which I am inserting data in the table from Front End so the same I have to insert serial number in the table. How it...
SQL2000SQL-Server
Answer 15 Apr 2013   license: CPOL
You can attach the mdf file by following below steps:1. Stop the SQL Server instance.2. Copy MDF and LDF files to another location.3. Delete original MDF and LDF files.4. Start SQL Server instance again.5. Create new database with exact same name and file names.6. Stop SQL...
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008SQL2012
Answer 14 Apr 2013   license: CPOL
hi....check the following link.... Export data from mdf and ldf files[^]How to recover data from corrupted SQL Server database?[^]SP_ATTACH_SINGLE_FILE_DB failed with error message "The FILE SIZE property is incorrect."[^]Regards,GVPrabu
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008SQL2012
Question 13 Apr 2013   license: CPOL
SQL Server Management Studio is showing me this error:Msg 5172, Level 16, State 15, Line 1I can't attach this database.Can i extract data from MDF file and how ?
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008SQL2012
Answer 10 Apr 2013   license: CPOL
Hello,The ISNULL function replaces NULL with the specified replacement value. Your query just double checks the nullness of a column. You can safely remove this condition. Instead use columnName IS NULL.Regards,
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008
Question 10 Apr 2013   license: CPOL
In SQL Server 2005, What is difference between((SELECT ISNULL(columnName,CONVERT(DATETIME,'January 01,1900',101))) = CONVERT(DATETIME,'January 01,1900',101)) and columnName = nullCan I replace [((SELECT ISNULL(columnName,CONVERT(DATETIME,'January 01,1900',101))) = CONVERT(DATETIME,'January...
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008
Answer 10 Apr 2013   license: CPOL
You can run the components of the first query in sql server management studio.This will give you a fair idea of what the final query is doing.
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008
Question 10 Apr 2013   license: CPOL
helloin sql server 2000 i have a error when runnin procedurem_Server: Msg 3624, Level 20, State 1, Procedure sp_rpt_hoghogh, Line 43Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447Expression: m_SizeRec > 0 && m_SizeRec
SQL2000SQL-Server
Answer 8 Apr 2013   license: CPOL
in Sqlserver2008:Select cast(your Column as time) [time]from yourtable
SQL2000SQL2005ASP.NETSQL-ServerVBSQL-ServerVB.NET
Answer 8 Apr 2013   license: CPOL
SELECT (getdate()),substring(CONVERT(VARCHAR, GETDATE(), 108),0,6) AS Time
SQL2000SQL2005ASP.NETSQL-ServerVBSQL-ServerVB.NET
Answer 8 Apr 2013   license: CPOL
SELECT CONVERT(VARCHAR, GETDATE(), 108) AS TimeIn format hh:mm:ss
SQL2000SQL2005ASP.NETSQL-ServerVBSQL-ServerVB.NET
Answer 8 Apr 2013   license: CPOL
Try this:SELECT CONVERT(VARCHAR(5),GETDATE(),108) AS Time--From your table--Assume AttDate is DateTime column of Table1SELECT AttDate, CONVERT(VARCHAR(5), AttDate,108) AS Time FROM Table1ORSELECT LTRIM(RIGHT(CONVERT(VARCHAR(20), GETDATE(), 100), 7)) AS TimeSELECT AttDate,...
SQL2000SQL2005ASP.NETSQL-ServerVBSQL-ServerVB.NET
Answer 8 Apr 2013   license: CPOL
Check this link:sql-server-get-time-in-hourminute-format-from-a-datetime-get-date-part-only-from-datetime/[^]
SQL2000SQL2005ASP.NETSQL-ServerVBSQL-ServerVB.NET
Answer 8 Apr 2013   license: CPOL
use thisSelect AttDate,RIGHT(CONVERT(VARCHAR, AttDate, 100),7) as Time From Tablename
SQL2000SQL2005ASP.NETSQL-ServerVBSQL-ServerVB.NET
Question 8 Apr 2013   license: CPOL
I want to get only Time from DateTime column using SQL query using SQL Server 2005 and 2008 Default output:AttDate==2011-02-09 13:09:002011-02-09 14:10:00I'd like this output:AttDate Time==2011-02-09 13:09:00 13:092011-02-09 14:10:00 14:10
SQL2000SQL2005ASP.NETSQL-ServerVBSQL-ServerVB.NET
Answer 6 Apr 2013   license: CPOL
If i good remember, you want to read values stored in a DataTable object to sort records and do some other operations, because MS SQL server functionality is less than MS SQL Server 2005 and does not contains functions like ROW_NUMBER...You want to go through the collection of records...
SQL2000VBSQL-ServerVB.NET
Answer 4 Apr 2013   license: CPOL
Try:UPDATE MyTable SET Qty=0 WHERE ItemCode='AAA' AND Harga!=100
SQL2000SQL-Server
Question 4 Apr 2013   license: CPOL
I have table :ItemCode Qty HargaAAA 10 100.000AAA 10 150.000AAA 10 200.000Plesa help me to make this table :ItemCode Qty HargaAAA 10 ...
SQL2000SQL-Server
Question 2 Apr 2013   license: CPOL
Hi can any one help me to give me a suggestion how to get alias column value from i'm trying to use a for each loop in vb.net using a datatable.My code is actually shown below If CInt(RowItem.Item("TOTALLINENO")) 500 Then ...
SQL2000VBSQL-ServerVB.NET
Question 28 Mar 2013   license: CPOL
HI friends,,,,I am counting total customers in a state using Subscription date in SQL SERVER 2000 or MSDE.select state,count(*) as Total from custdetail where active='T' and convert(varchar(20),startdate,103) between convert(varchar(20),'1/12/2005',103) and...
SQL2000SQL-Server
Article 28 Mar 2013   license: CPOL
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
Win2KWinXPWin2003VistaSQL2000SQL2005SQLWindowsSQL-ServerArchitect, +
Answer 23 Mar 2013   license: CPOL
Hey,You can use COUNT function.select count(*) from your_tableGet the count of the record in the table and add 1 to it.But, this will work fine only if you are not deleting the records physically from the table otherwise it will work in any condition.Hope this helps...
SQL2000SQLSQL-Server
Page 1 of 36
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web02 | 2.6.130513.1 | Last Updated 13 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid