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*
  
11,271 Results

Search



Sort by



Match


Rating Range

Advanced Filters:
Page 1 of 226
Page Size: 10 · 25 · 50

Tag filtered by:  SQL-server-2005 [x]
Answer 19 Mar 2015   license: CPOL
is there any solution example in MS SQL .i have a only more than 2 gb xml file . i am unable to import in my data base .through the MS SQL . i am getting the error ."Msg 6365, Level 16, State 1, Line 1An XML operation resulted an XML data type exceeding 2GB in size....
SQL-server-2005 SQL-Server C#3.5
Answer 13 Mar 2015   license: CPOL
This is an old question but I'm posting this solution to counter Solution 1 which uses a CURSOR - not a recommended approach (see SQL Server DO's and DONT's[^])The following solution uses constructs available from SQL 2005 - Common Table Expressions and Pivot. Some CP articles that may be...
SQL-server-2005 SQL-Server
Answer 6 Mar 2015   license: CPOL
http://www.c-sharpcorner.com/U...
SQL-server-2005 SQL-Server C#5
Question 6 Mar 2015   license: CPOL
dear allHow to create a lo-gin page in C# and database is sql server 2005, with permeation?with regards.
SQL-server-2005 SQL-Server C#5
Answer 5 Mar 2015   license: CPOL
The INSERT query should have a valid value for the Foreign Key column of that Table, where you are inserting a row.Otherwise it will give you foreign key constraint conflict error.
SQL-server-2005 C# ASP.NET SQL-Server NoEffort
Question 5 Mar 2015   license: CPOL
hello,i wanted to know how to write the insert query when we have created the foreign key in the database
SQL-server-2005 C# ASP.NET SQL-Server NoEffort
Answer 4 Mar 2015   license: CPOL
Perhaps the easiest way is to use SELECT INTO structure.For example if both databases reside on the same SQL Server, something like:SELECT Column1, Column2, ....INTO NewTableFROM DatabaseName.Owner.TableNameFor more info, see INTO Clause[^]
SQL-server-2005 SQL-Server
Answer 4 Mar 2015   license: CPOL
Refer: SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects[^]
SQL-server-2005 SQL-Server
Question 4 Mar 2015   license: CPOL
hello sir,i wanted to copy tables created in one database to the other database using sql server management studio 2005. can i know the steps to do the same
SQL-server-2005 SQL-Server
Answer 23 Feb 2015   license: CPOL
This is a quick run through to generate Insert statements for all of the data in your table, using no scripts or add-ins to SQL Management Studio 2008:1.Right click on the database and go to Tasks -> Generate Scripts2.Select the tables (or object) that you want to generate the script...
SQL-server-2005 SQL SQL-Server
Question 23 Feb 2015   license: CPOL
Hello. I have SQL Server 2005. I have my database and tables. I am trying to export the tables to .DBF file for a Foxpro program. How can I export or convert my SQL 2005 Database to a .DBF file for Foxpro?
SQL-server-2005 SQL SQL-Server
Answer 19 Feb 2015   license: CPOL
Ref This website:1) Send Sms from ASP.NET using Full On Sms2) Send free and bulk SMS to mobile numbers using Way2SMS and FullOnSMS accounts using ASP.Net
SQL-server-2005 ASP.NET SQL-Server
Answer 19 Feb 2015   license: CPOL
this code throws error as "An exception of type 'System.Net.WebException' occurred in System.dll but was not handled in user codeAdditional information: The remote server returned an error: (403) Forbidden."Please help me....
SQL-server-2005 ASP.NET SQL-Server
Question 5 Feb 2015   license: CPOL
string ADDRES = Convert.ToString(comboBox1.SelectedItem); SqlConnection con = new SqlConnection(); con.ConnectionString = "Data source=.;User ID=sa;Password=password;Initial Catalog=bank"; string sql = "select NAME_PEOPLE from PEOPLE where...
SQL-server-2005 C# SQL-Server
Answer 5 Feb 2015   license: CPOL
Hi Here i added solution please check thatprivate void Form2_Load(object sender, EventArgs e) { comboBox1.Items.Add("a"); comboBox1.Items.Add("b"); comboBox1.Items.Add("c"); comboBox1.Items.Add("d"); ...
SQL-server-2005 C# SQL-Server
Question 15 Jan 2015   license: CPOL
DECLARE @maxcount1 float DECLARE @maxcount0 float DECLARE @start datetime SET @start = getdate() - 2 DECLARE @end datetime SET @end= getdate() + 2SELECT @maxcount1 = max(OnTimeCount),@maxcount0 = max(DueTimeCount)FROM (SELECT DISTINCT COUNT(DISTINCT CASE WHEN ontime = 1 THEN...
SQL-server-2005 SQL-Server
Article 14 Jan 2015   license: CPOL
In this article, you will learn how to customize the built-in Select Names dialog and use different external data sources for your own dialog.
WinXP Win2003 Vista SQL-server-2005 C#3.0 .NET3.5 VS2008 C# DBA Dev , +
Answer 8 Jan 2015   license: CPOL
go to the file right click- property - security- full control -oksame on log file
SQL-server-2005 SQL SQL-Server
Question 6 Jan 2015   license: CPOL
I'm trying to configure Log Shipping in SQL 2005. I have 2 servers,each running an instance of SQL 2005. The services are all high-permissions accounts.After I configure Log shipping for a database, the process completesand all tasks (Backup, copy, restore) Are listed as...
SQL-server-2005 SQL DBA SQL-Server database
Answer 2 Jan 2015   license: CPOL
Have you tried searching this in Google?There are few free addins and external tools available in the internet.1. Here is a detailed blog on ApexSQL Complete[^]2. dbForge SQL Complete[^]Hopefully, it helps.Note: I don't recommend to use third party plugins or tools because...
SQL-server-2005 SQL-Server SQL-Server software
Answer 2 Jan 2015   license: CPOL
Try the following link!save image in folder and path to database in asp.net c#
SQL-server-2005 SQL-Server C#3.5
Answer 28 Dec 2014   license: CPOL
Thank you very much!!!This solved my problemSet objRS = Server.CreateObject("ADODB.Recordset")objRS.CursorLocation = adUseClientobjRS.Open strSQL, objConn,,adLockReadOnly, adCmdText
SQL-server-2005 VBScript SQL-Server
Answer 28 Dec 2014   license: CPOL
See this: RecordCount returns -1[^]
SQL-server-2005 VBScript SQL-Server
Question 28 Dec 2014   license: CPOL
Hi, I´m trying to ReDim my array from RecordCount, the problem is my query use PIVOT Table and then RecordSet.RecordCount return -1 I know that I can do two while, once for count and movefirts to works with datacount = 0While Not Recordset.EOF count = count + 1 ...
SQL-server-2005 VBScript SQL-Server
Answer 23 Dec 2014   license: CPOL
Take a look at http://msdn.microsoft.com/en-us/library/system.io.compression.zipfile%28v=vs.110%29.aspx[^].
SQL-server-2005 C# SQL-Server
Answer 21 Dec 2014   license: CPOL
check below tutorial :Send free and bulk SMS to mobile numbers using Way2SMS and FullOnSMS accounts using ASP.Net[^]
SQL-server-2005 ASP.NET SQL-Server
Answer 15 Dec 2014   license: CPOL
What about..using.http://msdn.microsoft.com/en-in/library/ms186734.aspx[^]andhttp://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx[^]
SQL-server-2005 SQL-Server SQL-Server Interview
Answer 11 Dec 2014   license: CPOL
ALTER PROCEDURE [dbo].[sp_Sample] @param1 VARCHAR(100),@name varchar(30)ASBegin DECLARE @Sql NVARCHAR(MAX) ---- SET @param1 = Replace(@param1, ',', ''',''') SET @Sql = '(select * from tblsample where name='''+ @name +''' and [Escalate to] IN ('+ @param1 + '))' exec...
SQL-server-2005 SQL-Server
Answer 8 Dec 2014   license: CPOL
Hi, to achive the task you need to split the variable using split function.like thisselect value from fn_Split ('par1,par2',',')use the above query like this IN(select value from fn_Split (@param1,','))first execute thiscreate FUNCTION [dbo].[fn_Split](@sText...
SQL-server-2005 SQL-Server
Answer 8 Dec 2014   license: CPOL
Check this hope this will work for you.ALTER PROCEDURE [dbo].[sp_Sample] @param1 VARCHAR(100),@name varchar(30)ASBegin DECLARE @Sql NVARCHAR(MAX) ---- SET @param1 = Replace(@param1, ',', ''',''') SET @Sql = '(select * from tblsample where name='''+ @name +''' and...
SQL-server-2005 SQL-Server
Answer 8 Dec 2014   license: CPOL
Alter procedure sp_sample3@Escalation varchar(30),@InClause NVARCHAR(100)asDECLARE @SafeInClause NVARCHAR(100)SET @SafeInClause = ',' + @InClause + ','SELECT * FROM tblSample WHERE [Escalate To]=@Escalation and CHARINDEX(',' + [Owner Dept] + ',', @SafeInClause) > 0exec...
SQL-server-2005 SQL-Server
Question 8 Dec 2014   license: CPOL
Dear all,write a stored procedure to pass one value in one parameter and two values in another parameter in sql server.I was tried with the below code.I got result when i pass only param1 (multiple values)BUt when i add another param (@name)., not getting result.Please correct me...
SQL-server-2005 SQL-Server
Tip/Trick 3 Dec 2014   license: CPOL
Perform SQL Server Instance health check simultaneously on more than one server using Powershell
SQL-server-2005 SQL Windows SQL-Server Architect DBA Dev QA Beginner Intermediate , +
Answer 1 Dec 2014   license: CPOL
Hi You need to do the following stuff in your grid set Autogeneratedcolumn ="false"Thanks,Mukesh
SQL-server-2005 C# SQL-Server C#4.0
Answer 20 Nov 2014   license: CPOL
I was getting this error in the following case:1. Have a grid of say 20 rows.2. My active cell was on say row 10. 3. I would filter the grid down to something less than 10 rows based on a simple find feature I have.4. This caused the error because the current cell address no longer...
SQL-server-2005 C#3.0 C# SQL-Server
Tip/Trick 18 Nov 2014   license: CPOL
Quick C# console application to encrypt all your database stored procedures
SQL-server-2005 C# SQL-Server Visual-Studio SQL-Server Encryption smo
Answer 12 Nov 2014   license: CPOL
Change the permission levels to FullControl for that *.mdf file, which ever you trying to attach the database for loggedIn user account.
SQL-server-2005 SQL SQL-Server
Answer 12 Nov 2014   license: CPOL
dasf dsafsdpublic static void mainResponse.Write("Error Message" + EX.exception);
SQL-server-2005 C# ASP.NET SQL-Server
Answer 8 Nov 2014   license: CPOL
To solve this problem, you may need to repair your SQL Server 2005Simple steps can be1. Update/Install .Net 2.0 framework. Windows Installer 3.1 available online recommended2. Download the setup file from Microsoft website...
SQL-server-2005 SQL-Server
Answer 8 Nov 2014   license: CPOL
Your question is not clear. But I am assuming that your first table is the Salary table and the second one which has been paid out.Based on the vagueness of your question, I guess this is what you want:SELECT Salary.ID, Salary.Name, Salary.Address, CASE WHEN...
SQL-server-2005 SQL-Server
Question 8 Nov 2014   license: CPOL
table 1ID Name Address Basic_Salary Basic_Allowance1 Moses MTM 1000 5002 GEO NGL 3000 1500Another table table 2ID Name Address Salary Allowance Month1 Moses MTM 800 220 NovI Need...
SQL-server-2005 SQL-Server
Answer 6 Nov 2014   license: CPOL
You may try this alsoSELECT col1,col2,col3,col4, col5into #DuplicatesFROM table2GROUP BY col1,col2,col3,col4, col5HAVING count(1) > 1 delete from table2 tbl2 where exists(select col1,col2,col3,col4, col5 from #Duplicates dupwhere tbl2.col1=dup.col1 and tbl2.col2=dup.col2 and...
SQL-server-2005 SQL SQL-Server
Answer 6 Nov 2014   license: CPOL
If I understand your requirements correctly.The primary key constraint on table1 needs to be dropped.--data setup for testingdeclare @table2 table(col1 int, col2 int, col3 int, col4 int, col5 int, col6 varchar(10));declare @table1 table(col1 int, col2 int, col3 int, col4 int, col5 int,...
SQL-server-2005 SQL SQL-Server
Answer 6 Nov 2014   license: CPOL
check this DEMO[^]you can use SQL INSERT INTO SELECT Statement[^] with group by
SQL-server-2005 SQL SQL-Server
Answer 6 Nov 2014   license: CPOL
1- Run SQL Server Management as Administrator2- Login SQL Server with Windows Authenticate3- Attach you DB Files
SQL-server-2005 SQL SQL-Server
Answer 5 Nov 2014   license: CPOL
I am not sure why you need to delete rows before you copy them to Table1.What I would suggest is get the DISTINCT rows from Table2 and then insert them in Table1INSERT INTO Table1SELECT DISTINCT Column1, Column2, Column3 Column4, Column5 FROM Table2
SQL-server-2005 SQL SQL-Server
Question 5 Nov 2014   license: CPOL
My scenario is this:I have two tables table1 and table2.Both of them are identical except that table2 has no primary key or constraints.I need to copy data from table2 to table1.table1 does not accept duplicate rows.The primary key in table1 is based on 5 columns col1, col2,...
SQL-server-2005 SQL SQL-Server
Answer 4 Nov 2014   license: CPOL
I prefer CTE[^] rather than WHILE loop ;)DECLARE @startDate DATETIME = '2014-10-30'DECLARE @finishDate DATETIME = '2014-11-04' ;WITH MyDates AS( SELECT @startDate AS MyDate UNION ALL SELECT DATEADD(DD,1,MyDate) AS MyDate FROM MyDates WHERE...
SQL-server-2005 SQL-Server
Answer 4 Nov 2014   license: CPOL
sample code:SET @CurrentDate = @startDateWHILE @CurrentDate
SQL-server-2005 SQL-Server
Page 1 of 226
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web03 | 2.8.150321.1 | Last Updated 23 Mar 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid