Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime
Hi, This is Pushan Chakraborty from Kolkata.I have complied 2 stored procedure to retrieve the names of 2 user defined tables that I have created . The stored procedures are: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author:...
Hi, This is Pushan Chakraborty from Kolkata.I have complied 2 stored procedure to retrieve the names of 2 user defined tables that I have created . The stored procedures are: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author:...
5 pts.
How do I confirm all the data moved from Source to target for different tables
How do I confirm all the data moved from Source to target for different tables. I am not able to phrase this question. Bottom line I want to make sure all the data was transferred to target database. That is my test to validate. Thanks Software/Hardware used: SQL
How do I confirm all the data moved from Source to target for different tables. I am not able to phrase this question. Bottom line I want to make sure all the data was transferred to target database. That is my test to validate. Thanks Software/Hardware used: SQL
The most-watched IT questions this week: Nov. 24, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Cluster drives moving windows server 2003 r2 32 bit was asked by a reader and answered by Mrdenny. 2. Migrating to virtualized environment purely to retain support for legacy...
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Cluster drives moving windows server 2003 r2 32 bit was asked by a reader and answered by Mrdenny. 2. Migrating to virtualized environment purely to retain support for legacy...
hardware requirement for sql 2005.
Hi all, We are planning into SQL 2005 server (windows server 2003)with multipledatabases of sizes of around 10gb.What should be the CPU speeds ,type of CPU and RAM requirements for ir
Hi all, We are planning into SQL 2005 server (windows server 2003)with multipledatabases of sizes of around 10gb.What should be the CPU speeds ,type of CPU and RAM requirements for ir
SQLRPGLE Cursors and Recursion
I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms b dprintPrograms PI d...
I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms b dprintPrograms PI d...
Msg 102, level 15, State 1, Line 14
Hi, I'm ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the 'ON' on the line "SET ANSI_NULLS ON". Could you please help me? I can't see what's wrong. Here's my code: CREATE PROCEDURE InsertDBTables AS BEGIN SET NOCOUNT...
Hi, I'm ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the 'ON' on the line "SET ANSI_NULLS ON". Could you please help me? I can't see what's wrong. Here's my code: CREATE PROCEDURE InsertDBTables AS BEGIN SET NOCOUNT...
The IT Blog Top 10: Nov. 19, 2009
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...
MS SQL Server to Oracle Applications
We have MS SQL Server Data and need to get into Oracle Applications. Data Source – MS SQL database – Data is to be summarized by transaction type; needs to provide parameter for transactions dates to be extracted.[o:p][/o:p] Data to be loaded initially to STG table and then to GL journal...
We have MS SQL Server Data and need to get into Oracle Applications. Data Source – MS SQL database – Data is to be summarized by transaction type; needs to provide parameter for transactions dates to be extracted.[o:p][/o:p] Data to be loaded initially to STG table and then to GL journal...
How to encrypt a big list of sp's at once
I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn't be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I'll like to know if there is a way to...
I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn't be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I'll like to know if there is a way to...
FULL BACKUP taken by SQLExecDirect function works, but backup is not taken why?
I try to backup SQL server database using ODBC native client apis. One weird error occurs. When I run, SQLExecDirect(stmt, "BACKUP DATABASE dbname TO DISK='C:TESTBK.BAK' WITH FORMAT ", sql_nts ) There are no errors during runtime, and message shows backup taken . But it is not seen innthe specified...
Answer Question
| Nov 17 2009 2:49 PM GMT
SQLExecDirect, SQL Server backup, SQL Server error messages
I try to backup SQL server database using ODBC native client apis. One weird error occurs. When I run, SQLExecDirect(stmt, "BACKUP DATABASE dbname TO DISK='C:TESTBK.BAK' WITH FORMAT ", sql_nts ) There are no errors during runtime, and message shows backup taken . But it is not seen innthe specified...
Answer Question
| Nov 17 2009 2:49 PM GMTSQLExecDirect, SQL Server backup, SQL Server error messages
Composite foreign Key in SQL Server
I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel,...
I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel,...
Email Notification
Hey i am creating an application front end = vb.net and back end = sql server db!! the application helps assign staff to jobs and when an assignment occurs i would like the staff to recieve an email informing them that they have been assigned to a job... can anyone help me out with how i would go...
Hey i am creating an application front end = vb.net and back end = sql server db!! the application helps assign staff to jobs and when an assignment occurs i would like the staff to recieve an email informing them that they have been assigned to a job... can anyone help me out with how i would go...
passing data between two SQL Server databases
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables. Also we are not allowed to use the...
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables. Also we are not allowed to use the...
Passing data between two SQL Server databases
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server,...
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server,...
pl/slq procedures - POSITIVE and POSITIVEN as IN OUT parameters
Hi, I have a simple PL/SQL procedure with IN and OUT parameter of type POSITIVEN. CREATE or REPLACE PROCEDURE PROC ( inval IN POSITIVEN, outval OUT POSITIVEN ) AS BEGIN outval := inval; END; I pass the value 1 for the IN value using the sql type INTEGER in a jdbc application. But oracle throws a...
Hi, I have a simple PL/SQL procedure with IN and OUT parameter of type POSITIVEN. CREATE or REPLACE PROCEDURE PROC ( inval IN POSITIVEN, outval OUT POSITIVEN ) AS BEGIN outval := inval; END; I pass the value 1 for the IN value using the sql type INTEGER in a jdbc application. But oracle throws a...
The IT Blog Top 10: Nov. 12, 2009
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...
SA Password change for SQL
What is the easiest procedure for changing the SA password, and what is the procedure for testing the password change? Software/Hardware used: SQL 2005 SP3
What is the easiest procedure for changing the SA password, and what is the procedure for testing the password change? Software/Hardware used: SQL 2005 SP3
Can we get sql server authenticated logins and passwords?
Plz forward me the solution of the above query. Thanks & Regards, Gangadharan M Software/Hardware used: Software
Plz forward me the solution of the above query. Thanks & Regards, Gangadharan M Software/Hardware used: Software
How do I fetch synonym names with the SQLTables function in ODBC API?
Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0,...
Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0,...
SQL select for month date range
Hello, I am attempting to obtain a count of visits each patient comes in in one month, so for example of they were a new patient in January on the 4th, I would want from the 4th of January to the 4th of February. The code I am attempting to use is below, but every time I use it, no records are...
Hello, I am attempting to obtain a count of visits each patient comes in in one month, so for example of they were a new patient in January on the 4th, I would want from the 4th of January to the 4th of February. The code I am attempting to use is below, but every time I use it, no records are...
