hello.. i have a database table which contains some fields. one of the field's value is as like ,code,removeformat,undo,redo,cut,copy,color,|1|1,2,3,|0|500,400|1078,|False|500| how can i insert "color" as shown using sql query this ? i using sql server 2005,c#. thank you ...
Hello Everyone, I'm creating a Windows Application in Visual Studio 2008. I've got experience developing business applications using SQL Database and Access Databases as well. But, I've seen "Service-based Database" in Visual Studio 2008 and I've made my whole application working with that Service-based Database. and It works pretty fin...
I need to get data out of SQL Server2005 tables, and into another system. My vendors says: "We don´t recommend that you go directly in the SQL and collect data, because it can result in corruption of data or you can lock tables while exporting." Is that true? ...
Hi All, The WHERE clause of one of my queries looks like this: and tbl0.Type = 'Alert' AND (tbl0.AccessRights like '%'+TblCUG0.userGroup+'%' or tbl0.AccessRights like 'All' ) AND (tbl0.ExpiryDate > CONVERT(varchar(8), GETDATE(), 1) or tbl0.ExpiryDate is null) order by tbl0.Priority,tbl0.PublishedDate desc, tbl0.Title asc ...
I have a sql2005 server connected to oracle 10g , the account on the sql is given privileges to access certain tables. Intermittently the Oracle privileges get revoked.. Oracle DBA tells me that he had not revoked the permissions (I tend to believe him).. Is there a way to figure what is going on.. ...
We are developing an application against a SQL Server 2005 database that uses several schemas for security purposes. The application will be using EF 2 in the .NET 4.0 framework. What I'm wondering is how those SQL Schemas (Support, Admin, Employee) etc. can/will/should be represented on the EF side. Should I separate the various entit...
This will involve monitoring, coldfusion, sql server 2005, iis, coldfusion errors, hardware. For example, I want to create graphical easy to understand charts showing coldfusion performance, but I want to know what data can i access underneath the system to get that? Are there any resources for that? Yes I know there is a balance from...
I'm running a PHP web app running on Ubuntu 8.04 which is interfacing with SQL Server 2005. I use FreeTDS to connect to MSSQL2005 with the following lines in my freetds.conf [MYDB] host = 192.168.1.11 port = 1433 tds version = 7.0 client charset = UTF-8 This works perfectly however if I switch to tds version = 8.0 (whi...
i need to connect to a database that is on a different server on the company network i am using sql server 2005 i went to connect to server --> browse for more --> Network servers but in the network servers list i am not seeing the server that i need. how do i find the server that i need and connect to it? ...
Wich SQL sentence (function or stored procedure) i can use to monitor an SQL Server DeadLock , caused by an UPDATE statement? ...
i need execute un update statement over an sql server table, this table is used by another process at the same time. because that sometimes deadlocks ocurs. wich Isolation Level do you recomend to avoid or minimize this deadlocks? ...
I am currently writing a script that intelligently strips a database down into a series of ordered INSERT statements with seeded identity columns that will allow me to place the records into a new database without destroying any keys or relationships. I am using the PRINT function to write the finished insert statements to the message w...
Simplifying what I'm doing somewhat, as an example, say I have the following tables: declare @elements table (id int, name nvarchar(20)) insert into @elements (id, name) values (1, 'FirstName') insert into @elements (id, name) values (2, 'Surname') insert into @elements (id, name) values (3, 'Address') declare @values table (id int, v...
Hello friends, I have a not so hard problem for SQL Server Expertise. Although I have another alternative but i want to know this can solved using CASE statement in SQL Server 2005. I have various category tables with same columns. What i need is to call SELECT statement based on category. Below is the code what i am trying to do ALTE...
i need to connect SQL Server 2008 instance with SQL Server 2005 Management Studio. There is a limitation on my Box that i can not upgrade the framework to 3.5. There are few applications running on my box which will stop functioning after 3.5 upgrade. Is there any way to achieve this? I GOOGLE this problem and found a Cumulative update p...
I am inserting record in the database (100,1.000, 10.000 and 100.000) using 2 methods (is a table with no primary key and no index) using a for and inserting one by one using a stored procedure The times are, of course better using stored procedure. My questions are: 1)if i use a index will the operation go faster and 2)Is there any...
I need to write SQL Query to Retrive the Following Settings of SQL Logins for SQL server 2005: 1.Enforce password policy 2.Enforce password expiration 3.User must change password at next login Thanx in advance. ...
Hello, I have had my experience with MSSQL Server somewhat 6 years ago, so I have only basic knowledge of its workings now. The problem I'm posed with is that of syncing the databases between two live CRMs (NopCommerce and Rainbow Portal-based one if anyone's curious) running on the same DB server. The data I'm interested in is spread ...
Let's consider this basic insert insert into TableName (Col1,Col2,Col3) values (Val1,Val2,Val3) i want this insert to be done only if Val1 !=null and Val3!=null How to accomplish this? ...
I have this stored procedure, that reads data from xml and make some inserts ALTER procedure [dbo].[SP_InsertIOs] @iosxml xml AS DECLARE @currRecord int -- parse the records from the XML EXECUTE sp_xml_preparedocument @currRecord OUTPUT, @iosxml BEGIN TRY INSERT INTO SN_IO ( [C1] ,[C2] ,[C3] ) SELECT [C...