sql-server

Insert Java Object In Sql Server

Hi! How Can I Insert/Retrive A Java Object Into/From Sql Server? THX ...

SQL WHERE.. IN clause multiple columns

i need to implement the following query in SQL Server select * from table1 WHERE (CM_PLAN_ID,Individual_ID) IN ( Select CM_PLAN_ID, Individual_ID From CRM_VCM_CURRENT_LEAD_STATUS Where Lead_Key = :_Lead_Key ) but the WHERE..IN clause allows only 1 column. How to compare 2 or more columns with another inner select? ...

SQL Server Plans : difference between Index Scan / Index Seek

In a SQL Server Execution plan plans what is the difference between an Index Scan and an Index Seek I'm on sql server 2005 ...

Cannot find the object because it does not exist or you do not have permissions , error in SQL Server

Hi All, I have a database and have a sql script to add some fields in a table called "Products" of the database. But when i am executing this script , I am getting the following error: Cannot find the object "Products" because it does not exist or you do not have permissions Why it's error occured and what should I do to resolve it?...

Datatable.select with byte array VB.NET

I have populated a datatable from a SQL stored procedure and need to do further filtering on the datatable. The datatable holds data that is returned from the SQL DB as varbinary and is stored in the datatable as a byte array. I am attempting to pass TheData!Hash which is also a byte array. When I need to filter the datatable I have use...

SQL server backup restore issue

Asking this question for a friend of mine. My client had send me a Back up file of a database in SQL Server 2008. I installed SQL Server 2008 Express Edition. Then i tried to Restore the given Back file with this but unfortunately its throwing an error "The media family on device is incorrectly formed . SQL Server can not process t...

how long must a sql server connection be idle before it is closed by the connection pool?

I have a client-server app that uses .NET SqlClient Data Provider to connect to sql server - pretty standard stuff. By default how long must connections be idle before the connection pooling manager will close the database connection and remove it from the pool? What setting if any controls this? This MSDN document only says The con...

Decryption problem

Hi, I have inserted some data in table using encryption (encrypted by creating my own certificate.). INSERT INTO Person2(ContactID, eFirstName, eMiddleName, eLastName) Values (1, EncryptByCert(Cert_ID('TestCertificate'), 'FirstName'), EncryptByCert(Cert_ID('TestCertificate'), 'Middle Name'), EncryptByCert(Cert_ID('TestCertificat...

MS SQL Server 2000 - check for existing database error

I use MS SQL Server 2000 SP4 and I have this part of script, that checks for existing database: IF EXISTS (SELECT * FROM sysdatabases WHERE name='MY_DBNAME') BEGIN PRINT 'Using the existing database MY_DBNAME.' USE MY_DBNAME END ELSE BEGIN PRINT 'Creating new database MY_DBNAME.' CREATE DATABASE MY_DBNAME END GO I keep...

How to write a stored procedure that will create 20 databases

Hi Can anybody tell me how to write a stored procedure that creates 20 databases in c:\test\ if i put a storedprocedure for database creation in a loop then if i create a first db as test again loop will calls sp.but it shows test alredy there. I don't know how to concatenate a variable to this so that i wil create test1 test2 test3...

Random Records & SQL2005 Stored Procedure Insert

Hi, I need to submit data from a form to an SQL2005 database via a stored procedure. The difficult part is that i also need to get 5 random records from a secondary table and insert these as part of the inserted record in table 1. My structure is akin to this: Tbl_Organisations (table to get the 5 random records from) Key | organis...

problem with selecting date from dropdownlist

Hi all, I am selecting the date from dropdownlist. but i am getting this exception "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM." Here is my code: DateTime dateofjoining = new DateTime(DropDownListDay.SelectedIndex, DropDownListMonth.SelectedIndex, ...

Understanding Update and Delete Rules for Relationships in SSMS 2008

Hello everyone, I am confused about what means the update and delete rule in SQL Server 2008 Management Studio when we define foreign key constraints. I also did not find related help documents (e.g. F1 help). Here is the screen snapshot. Appreciate if anyone could describe what do they mean and recommend some related documents to read...

Alias parameters in SSIS

I am using an OLE DB command in SSIS for which the SQL command looks like this: UPDATE DBO.CLIENT SET TimeZoneID = ?, DaylightSavingTime = ?, ModifiedBy = ?, MicrosPropertyID = ?, IsOffline = ?, GlobalReporting_MaskPatronNumberType = ?, GlobalReporting_PatronNumberReadableCharacters = ?, GlobalReporting_M...

Code version control when developing in .NET/SQL Server 2005 on a Mac

I recently started a new job where the office environment is Mac-based, but I will be developing in .NET and SQL Server. I'm already pretty sold on installing VMWare Fusion to set up a virtual XP box, but I'm wondering if anyone would be able to recommend a solution for code version control. Specifically, should I be installing somethi...

Problem with SET QUOTED IDENTIFIER??

Hi, I am stuck in a rather strange problem with SQL Server 2005, which throws "SET QUOTED IDENTIFIER should be on when inserting record" (using as SP) to the particular table. This worked fine earlier but is throwing this error randomly. I have verified the SP. We didn't manually specify SET QUOTED IDENTIFIER settings inside, so it mus...

How do I create parametrized XPath queries in SQL server?

I am trying to write a parametrized query in SQL server that uses a parameter value as part of the XPath, however it does not seem to work the way I would expect it to. Here is my sample: create table ##example (xmltest xml) declare @LanguagePath varchar(75) set @LanguagePath = '(/languages/language[@id="en-US"])[1]' insert into ##ex...

How do I update two tables that have a reference table in SQL Server?

I have 3 tables. 1. Users 4 Cols UserID - UserName - RealName - Flags 2. UsersGroups 2 Cols UserID - GroupID 3. Groups 3 Cols GroupID - GroupName - Flags What I want to do is select a specific UserName ie USERA and update the Flags column. but I also want to update the Flags column in the Groups table to the same value. The only co...

PHP SQL Server Insert issue

The following statement runs fine in the MS SQL server management studio. However when I try to execute via PHP the insert does not occur and no errors are returned. I know my connection is valid, all my select statements return properly. What am I missing? DECLARE @id bigint; SET @id = (SELECT MAX(application_track_id) + 1 FROM appl...

SQL Server performance with many concurrent, long-running queries.

I'm wondering how executing many long-running queries simultaneously will impact SQL Server's ability to service each query in a timely fashion. [Edit] It wasn't my intention to be vague, it's more a hypothetical. Let's just assume the queries are select statements with some kind of predicate on tables with millions of rows. ...