Retrive The Images From Database using Vb.Net
how Storing AND Retrieving Images in Sql Server using vb.net

Answer Question   |  April 28, 2011  3:33 PM
SQL Server, VB.NET

Microsoft Visual Studio 2008 Express edition
Hello everybody, i recently downloaded the Microsoft Visual Studio 2008 Express Edition. It has Visual Basic 2008, Visual C# 2008, Visual C++ 2008 and Visual Web Developer 2008 (all Express editions). The problem is i dont know where to start. I have programming background. i have programmed in C++ and Visual Basic 6.0 (at university). [...]

Answer Question   |  February 24, 2010  1:23 PM
C#, SQL Server 2005, Visual Basic, Visual C# 2008, Visual C++ 2008, Visual Studio 2008, Visual Studio 2008 Express Edition, Visual Web Developer 2008

Multiple instances with SQL Server
Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?

Answer Question   |  December 17, 2008  8:56 AM
Database instance, SQL Server 2000, SQL Server 2005, SQL Server clustering, SQL Server multiple instances

How to connect PowerBuilder 10 with Microsoft SQL Server?
connect Powerbuilder 10 with Microsoft SQL??

Answer Question   |  June 15, 2010  6:43 AM
Database connectivity, PowerBuilder, PowerBuilder 10, RAD, Rapid Application Development, SQL Server connectivity, SQL Server interoperability

SQL Server – where clause
When I execute query like below select * from A where bb in (’1′,’2′,’3′) That is very fast. not a problem. But in procedure first, if I make a “B” table with ’1′,’2′,’3′ and join with A table like below, select * from a a , B b where a.xx = b.xx and than it [...]

Answer Question   |  December 17, 2008  7:21 PM
SQL Server, SQL Server performance, WHERE clause

ALTER INDEX statement
‘ALTER INDEX ‘ || C_Indices.INDEX_NAME ||’ REBUILD ‘; ‘ALTER INDEX ‘ || C_Indices.INDEX_NAME || ‘ REBUILD ONLINE COMPUTE STATISTICS’; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code , i am using execute immediate [...]

Answer Question   |  December 17, 2008  12:54 PM
ALTER INDEX statement, EXECUTE IMMEDIATE statement, Oracle development, Oracle SQL, Oracle stored procedures, SQL statements, Stored Procedures

How to configure the database instance to respond slowly for any request?
With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can be connect to [...]

Answer Question   |  December 24, 2008  7:24 AM
Database configuration, Database instance, Database testing, DB2, Oracle, SQL Database, SQL Query, SQL Server

PL/SQL: How to handle OUT Parameter during INSERT
HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) — Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am unclear on this please [...]

Answer Question   |  December 17, 2008  6:56 AM
INSERT statement, OUT parameters, PL/SQL, PL/SQL block, SELECT statement, SQL statements

Inserting rows and multiple rows in SQL Server 2005 Express
Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three tables where [...]

Answer Question   |  December 15, 2008  2:16 PM
INSERT statement, SQL Server 2005, SQL Server 2005 error messages, SQL Server 2005 Express, SQL Server stored procedures, Stored Procedures, VB.NET, Visual Basic .NET

SBS 2003, SQL Server 2005 and database mirroring
Hello! I m trying to get db mirroring to work between two sbs 2003 premium based sql (2005) servers. Am I just plain stupid or did I miss sth? And please dont tell me about traceflags becaouse they dont seem to have an effect on my … problem? Perhaps I came out as a bastard [...]

Answer Question   |  December 22, 2008  11:21 AM
Database mirroring, SBS, SBS 2003, SBS 2003 mirroring, Small Business Server 2003, SQL Server 2005, SQL Server 2005 mirroring

IF ELSE in SQL Server stored procedure
I am using this code which is giving error: if (@report_type = 'CM') Begin Select distinct Region,sum(ClientCount) as ClientTotal Into #NewTemp From ( End else if (@report_type = 'AM' ) Begin ( Select distinct Region,Area,sum(ClientCount) as ClientTotal Into #NewTemp1 From End else if (@report_type = 'BM' or @report_type ='UM' or @report_type ='AUM') Begin ( Select [...]

Answer Question   |  April 17, 2013  5:43 AM
IF ELSE statement, SQL Server 2005, SQL Server development, SQL Server stored procedures, SQL statements

PLS-00103: Encountered the symbol “E_PROD_REQ_ID_NOT_FOUND” when expecting one of the following:
how can i resolve that error? when i compile the store proc….it compiled without any errors….but in a package its throwing error

Answer Question   |  December 13, 2008  8:50 PM
Oracle error messages, PLS-00103, Stored Procedures

Error in SQL Server 2005 with passing a variable
In T-SQL code on SQL Server 2005, the variable :t_id is being passed from other pages and works in other statements, but it is not parsing within this statement: define(“TF_T_INFO_INSERET”, ” insert into TFT (WG_ID,task_id,tf_id) SELECT (select WGID from LU_T where TID= :t_id ), :t_id , (select max(TF_ID) from LU_TF); “); If I replace :t_id [...]

Answer Question   |  December 12, 2008  4:23 PM
SQL Server 2005, SQL Server errors, SQL Server Variables, T-SQL

System tables in SQL Server 2005
What is the role of system tables in SQL Server 2005 and how do you update them?

Answer Question   |  December 13, 2008  4:20 PM
SQL Server 2005, SQL Server System Tables, SQL Server tables, SYSTEM TABLESPACE

Error when updating SQL Server 2000 from SQL Server 2005
Hi, I am using sqlServer 2005 and sqlServer 2000. When i update on sqlServer2000 from sqlServer2005 then following error was occured. Msg 682, Level 22, State 148, Line 1 Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

Answer Question   |  December 13, 2008  12:07 PM
DBCC CHECKDB, SQL Server 2000, SQL Server 2000 interoperability, SQL Server 2005, SQL Server 2005 interoperability, SQL Server error messages, SQL Server upgrades

How to save the output from an SQL select statement to a spool file
Please can someone tell me how I can save the output from an SQL select statement to a spool file. Thanks, Tom

Answer Question   |  June 19, 2011  10:23 AM
SELECT statement, Spool files, Spool to Flat, SQL, SQL statements, Start Structured Query Language, STRSQL

Impact on application after upgrade from SQL Server 2005 to SQL Server 2008?
What would be impact/changes to be done in my application which is using general SQL for upgradation from SQL Server 2005 to SQL Server 2008 ?

Answer Question   |  December 12, 2008  8:15 AM
SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008, SQL Server 2008 performance, SQL Server migration, SQL Server performance, SQL Server upgrades

How to use SQL triggers to log errors in a SQL table?
How to log errors in sql table using sql triggers

Answer Question   |  December 17, 2008  6:55 AM
SQL Server, SQL Server error logs, SQL Server triggers

Sql Server Agent
What causes an agent not to start? It appears in the services view as starting (instead of Started). WWhen it does start it, you try to do a job and it states that it cannot do so because the agent has not started.

Answer Question   |  December 11, 2008  3:23 PM
SQL Server Agent

Scope identity on a stored procedure in SQL
I have created the following stored procedure in SQL: CREATE procedure [dbo].[sp_trip_number] @Table_Name nvarchar(100), @Trip_Number int output as begin set nocount on begin transaction DECLARE @DynamicSQL NVARCHAR(1000) DECLARE @New_Trip_Number int SET @DynamicSQL=’INSERT INTO ‘ + @Table_Name + ‘ DEFAULT VALUES’ + ‘;’ + ‘SELECT’+ @New_Trip_Number+ +’=’ + ‘SCOPE_IDENTITY()’ EXEC (@DynamicSQL ) SET @Trip_Number = @New_Trip_Number [...]

Answer Question   |  December 11, 2008  7:54 PM
Parameters, scope, SQL Server stored procedures