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*
  
9,760 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


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

Tag filtered by:  SQL2005 [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
If you type "ORA-06550" in google (or any other ORA error) you'll get the explanation. In this case, not much of help as it seems to be a generic error. My guess is that it might be because you add prm3 twice (not sure though): //btw is "paramters" a typ-o ? ...
.NET1.0.NET1.1SQL2005C#ASPASP.NETSQL.NET.NETSQL-Server, +
Question 13 May 2013   license: CPOL
In my code am getting following error.ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'SAVE_DATA'ORA-06550: line 1, column 7:PL/SQL: Statement ignoredWhat will be the reason for this?code am using is, List listparamters =...
.NET1.0.NET1.1SQL2005C#ASPASP.NETSQL.NET.NETSQL-Server, +
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 13 May 2013   license: CPOL
Try this:DECLARE @tbl TABLE (myText NVARCHAR(30))INSERT INTO @tbl(myText)VALUES('Friday,May,05,2013');WITH cte AS( SELECT LEFT(myText, CHARINDEX(',', myText)-1) AS Word, RIGHT(myText, LEN(myText) - CHARINDEX(',', myText)) AS Remainder FROM @tbl WHERE CHARINDEX(',',...
SQL2005SQL-Server
Answer 13 May 2013   license: CPOL
ALTER PROCEDURE StoredProcedureName( @customer_id smallint, @balance smallint )AS SET NOCOUNT ON UPDATE sale SET balance = @balance WHERE (customer_id = @customer_id) RETURN
SQL2005SQL-Server
Answer 13 May 2013   license: CPOL
Have a look at this code project article[^] on the subject
SQL2005SQL-Server
Answer 13 May 2013   license: CPOL
This does rather more than you need: Using comma separated value parameter strings in SQL IN clauses[^] - but it's doing the same task, just a bit more completely.
SQL2005SQL-Server
Question 13 May 2013   license: CPOL
How Can I get substring between commas?eg: Thursday,May,05,2013 Friday,May,05,2013how can i get the month 'May' from this.
SQL2005SQL-Server
Question 12 May 2013   license: CPOL
Dear,I have faced a query problem.I have table name sale(sale_id,balance,customer_id)Data like assale_id, balance, customer_id1 , 500 , 22 , 600 , ...
SQL2005SQL-Server
Answer 11 May 2013   license: CPOL
There are way too many things that could be the issue. Try troubleshooting these and see if problem is there:Are running on a slow connection? Is it a server in your local network?Are there any other heavy queries being run on the server?Try pinging the sever and see what are response...
SQL2005SQL-ServerCommandsquery
Answer 11 May 2013   license: CPOL
int Days = 0; DateTime bookingTime = ----; DateTime vacateTime = ---; TimeSpan roomHeldFor = vacateTime - bookingTime; decimal heldTime = Math.Ceiling(((decimal)roomHeldFor.TotalHours)); if (heldTime
SQL2005.NET3.5C#.NETSQL-Server
Answer 11 May 2013   license: CPOL
To be able get human readable transaction log you need to use some of the tool that decodes transaction log. Here is one transaction log reader tool[^] that can read transaction log and present you complete information stored in transaction log.Other option is to try with fn_dblog but it...
SQL2005SQL-Server
Question 10 May 2013   license: CPOL
I have a local and remote server and I’m executing same query on both but it takes a lot longer to execute on the remote server. I’ve checked the query plans and they are same on both servers
SQL2005SQL-ServerCommandsquery
Answer 10 May 2013   license: CPOL
You can try Log reader[^] This tool is compatibile with SQL Server 2005
SQL2005SQL-Server
Answer 9 May 2013   license: CPOL
Please, read solution1 by _Damian S_. It's very good.Please, change your query:Declare @active tinyintset @active=select IsActive from tbl_OPDappointment where Docket_no=@Docket_nowith:Declare @active tinyintselect @active=COALESCE(IsActive, 0) from tbl_OPDappointment where...
SQL2005SQL-Server
Question 9 May 2013   license: CPOL
ALTER proc [dbo].[Sp_Update_OPD_Docket]@Docket_no varchar(50)asDeclare @active tinyintset @active=select IsActive from tbl_OPDappointment where Docket_no=@Docket_noif (@active3)BEGINupdate tbl_OPDappointment set IsActive=3 where Docket_No=@Docket_noENDi just want to assign...
SQL2005SQL-Server
Answer 9 May 2013   license: CPOL
Since your stored procedure simply checks whether the IsActive value is 3, and if it's not, update to 3, you could achieve the same thing with this code:update tbl_OPDappointment set IsActive=3 where Docket_No=@Docket_noand IsActive3
SQL2005SQL-Server
Answer 9 May 2013   license: CPOL
I think you cannot do this to PDF file. I belive you can do this with .doc format.Try Googling! :)
SQL2005ADO.NETSQL-Server
Question 9 May 2013   license: CPOL
actually im create one report data contain tables information like (name,contactno,address etc) this report im tried in excel and its generated successfully but when i deploy my winform application it's through oledb32.dll error so that's why i think now to show contain in pdf file can u all...
SQL2005ADO.NETSQL-Server
Answer 9 May 2013   license: CPOL
Hi,Check the following Query... use OR Operator for this simple checking.Declare @RRPTDemandStatus char(7) = nullselect mpd.MPD_DemandStatus, m.Description,* from RPT_MRFProgressDetails mpdleft outer join MasterData M on mpd.MPD_DemandStatus = M.Idwhere ((mpd.MPD_DemandStatus =...
SQL2005SQL-Server
Answer 9 May 2013   license: CPOL
Try using Right outer Join as below. Let me know the result.Declare @RRPTDemandStatus char(7) = nullselect * from RPT_MRFProgressDetails mpdright outer join MasterData M on mpd.MPD_DemandStatus = M.Id
SQL2005SQL-Server
Question 9 May 2013   license: CPOL
Hi friends,I have 2 tables1. RPT_MRFProgressDetails 2. MasterData RPT_MRFProgressDetails has column MPD_DemandStatus which has values as well as null valueI tried following:Declare @RRPTDemandStatus char(7) = nullselect mpd.MPD_DemandStatus, m.Description,* from...
SQL2005SQL-Server
Answer 8 May 2013   license: CPOL
You can use "between" or ">, '2010/05/26' AND [DATEFIELDNAME] =
SQL2005SQL-Server
Answer 8 May 2013   license: CPOL
SELECT * FROM TabelName WHERE ColumnName BETWEEN '2010/02/25' and '2011/02/27'
SQL2005SQL-Server
Answer 8 May 2013   license: CPOL
I suppose nobody have ever had a similar requirement, so you wouldn't be able to find anything just using Google[^].
SQL2005SQL-Server
Question 8 May 2013   license: CPOL
How can we find data from database between a particular start date and end date?eg:select * from table where 26-05-2010 and 26-05-2010How can we find data from database between 26-05-2010 and 26-05-2013
SQL2005SQL-Server
Answer 8 May 2013   license: CPOL
Have a look at this article for 2005[^]I actually found this one easier to follow[^] but it's for an earlier version
SQL2005SQL-ServerSQL-Server
Question 8 May 2013   license: CPOL
Hi I have an encrypted procedures sql 2005 how can i Decrypt this procedures and open it . I do not have the script and want to want do some modification
SQL2005SQL-ServerSQL-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
Tip/Trick 6 May 2013   license: CPOL
This article explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by Sql Server.
WinXPWin2003VistaSQL2005SQLWindowsSQL-ServerDBAWindowsSQL-Server, +
Answer 6 May 2013   license: CPOL
Hi,It seems that your answer is here :http://stackoverflow.com/questions/803211/how-to-get-sp-executesql-result-into-a-variable[^]Good Luck
SQL2005SQL-Server
Question 6 May 2013   license: CPOL
Hi all, How do we assign a value to scalar variable based on some condition in Dynamic SQL .After assigning i have to returnthe value.Example.CREATEPROCEDURE PROC_LOCALVAR --'1'(@V aS varchar(1))ASDECLARE @SQL AS VARCHAR(MAX)DECLARE @LOCAL AS VARCHAR(20)SET...
SQL2005SQL-Server
Answer 5 May 2013   license: CPOL
To check duplicates, you can simply check whether such record exists. Use if exists with Where condition
SQL2005SQL-Server
Answer 5 May 2013   license: CPOL
If it is windows application,set welcome label's properties...Label1.Dock = Fill;Label1.TextAlign = MiddleCenter;Happy Coding!:)
SQL2005.NET3.5C#.NETSQL-ServerC#4.0
Question 5 May 2013   license: CPOL
Hi To All!Respected sir/ma'am.This is first time i am developing software so i have one question i want to display One label(Welcome to user) on the middle(center) of my monitor screen but as you know screen size is vary like mine is 19Inc others(my client)might have larger than it or may...
SQL2005.NET3.5C#.NETSQL-ServerC#4.0
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
Answer 4 May 2013   license: CPOL
This code exports from DataGridView to ExcelPrivate Sub Export_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles VIEW_Button.Click Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook ...
SQL2005VBSQL-ServerVB.NET
Question 4 May 2013   license: CPOL
How can I Crack dbforge sql complete standard edition?
SQL2000SQL2005SQLSQL-ServerSQL-ServerSQL2008sqldatasourceSQL2008R2
Answer 4 May 2013   license: CPOL
Try: DateTime startBooking = ... DateTime vacated = DateTime.Now; TimeSpan roomHeldFor = vacated - startBooking; int heldTime = (int) roomHeldFor.TotalMinutes; Console.WriteLine(heldTime > (25 * 60) ? "Two days" : "One day");
SQL2005.NET3.5C#.NETSQL-Server
Answer 4 May 2013   license: CPOL
Usually people must vacate the room before 13:00 otherwise it is put on their account.
SQL2005.NET3.5C#.NETSQL-Server
Question 4 May 2013   license: CPOL
Hi,This is Bala, i am very new to .net window applications. i am using .net framework 3.5 with c# language and sql server 2005 now i am developing a project for hotel management in window application. modules are, booking of room and vacate a room based on the time not day. now i have...
SQL2005.NET3.5C#.NETSQL-Server
Question 4 May 2013   license: CPOL
hi all,im here because i dont know where i can find any solution for my problem. i developed ticket fare collections.and it is online (intranet company).i manage to print the ticket through thermal printer.no problem at all.but come the problem is when i test the web page at user's...
SQL2005VBSQL-ServerVB.NET
Answer 4 May 2013   license: CPOL
I'm not sure I understand all the details here, so if I'm wrong about any of this, please correct me.1.) The printer connected to your server is not the printer connected to the remote user's computer. And your remote user is not on the same network... is he/she? If this is the case, then...
SQL2005VBSQL-ServerVB.NET
Question 3 May 2013   license: CPOL
Hi Expert,Sql Server Database table contains more than 1 millions entries. And default sql server transaction timeout is 30 seconds.I am using winform for front end(C#).And some of the long running queries showUnable to modify table.Timeout expired. The timeout period...
SQL2005SQL-Server
Answer 3 May 2013   license: CPOL
There are some links for you.1. Backup SQL Database Through Code In VB.NET[^].2. How to backup database SQL SERVER from VB NET?[^]. Follow the accepted answer by Martin Xie - MSFT.UtilitySQL Server Database Backup Utility using VB.NET and SQL-DMO (New version)[^]
SQL2005VBSQL-ServerVB.NET
Answer 3 May 2013   license: CPOL
You can use SMOAdd these references:'//***** Add these references**********'//Microsoft.SqlServer.Smo'//Microsoft.SqlServer.SmoExtended'//Microsoft.SqlServer.Management.Sdk.Sfc'//Microsoft.SqlServer.ConnectionInfoAdd these Imports:Imports...
SQL2005VBSQL-ServerVB.NET
Question 3 May 2013   license: CPOL
In my desktop application i want to Export data directly from a SQL database to MS Excel with customize heading.I want to export my database which contains many tables to the excel 2007.When user clicks on Export button, it will directly export data into Excel using VB.Net.How can i achieve...
SQL2005VBSQL-ServerVB.NET
Page 1 of 196
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


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