Microsoft SQL Server Forum

hi all, is it possible to Search data in database? with a single sql script or some tools will help me? for example ,I have a HR database ,and I want to search 'CEO', $2354.00 or '12/4/1996' in all of the records.

Hello, how can I replace numbers from -1 to 15 with string in MSSQL? For e.g.: -1 = TEST1 1 = TEST2 2 = TEST3 ... 12 = TEST123 13 = TEST1234

I declare to a variable equivaclent to cedil DECLARE @TAB CHAR(1)=char(199) but everytime I export it it's giving me different char. Is there's a way to write U+00C7 which is equivalent to cedill? You help will be much appreciated. thank you.

Ben, Hi, First of all, here are my work tools : I have an Access 2003 app that uses an SQL Server DataBase (i know it's weird). I am using Microsoft SQL Server Management Studio Express. I am now trying to execute a query from my app to insert some rows from 2 tables into another. My query works well when i use it rigth into SQL Server...

Hi, I have a small problem of the following Tables, I have MyTable1 (for example) and I want to attach content of following MyTable2 to MyTable1, but MyTable2 have the Data just 1 week ago, and it should be in appropriate columns against that columns in MyTable1, pl tel me what can I do? MyTable 1 : Id_Date Id_Branch NewBalance...

I am having a problem for which I have done numerous online searches but have not yet found an answer. I hope someone can help with it. SQLServer 2008r2 on Microsoft Windows 2008r2 There is a stored procedure which runs nightly. I did not write the stored procedure and I do not have the right to change it. Here is what the stored...

Hey ALL, I have the following table-valued functions that works well if I pass its arguments with literal numbers or from declared variables. USE GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON

I am trying to create a data extract report in report builder 2.0 in sql 2008. I developed the report on my server in report builder 3.0 (2008R@) and it ran fine. I duplicated the report in report builder 2.0 and it executes through all the records but only displays the first one in the report. My data source is a stored proc.

I've closed all SQL Server service except the MSSQLSERVER, and have set that service to startup in single user mode by using the -m switch in the Configuration Window. However, when I tried to login using the "sa" account" a dialog box popped up telling me that the service was in single user mode and only one Administrator could login. I am...

I want add a number to a text value and have it appear in output. Original value column Extension is a text that I want to add 2100, but I want to have it output to a text. Using Northwind database, table Employees: Select (E.EmployeeID) as 'EmployeeID_ab', (E.Extension) as 'Extension_ab'

can we use "contains" as filter condition under where clause for a Date Field?if yes please give me example?if no please give me any alternate option?

Hi, In SQL clustered tables (B tree), pages are linked in all levels by doubly linked list. Already the index is pointing to the corresponding pages then why we need the doubly linked list between pages? Any help is appreciated. Thanks in Advance, Malathi

Hi, I have this working fine from a mysql database. I am trying to use it from a sql server 2008 database but cannot get it working, just error 500. Does anyone know how the driver info might have to change or is there anything else in the code that might be mysql specific? Thanks for any help in advance Richard the connection strung that...

Hello. I want to ask for a question. I have a software which uses MS SQL database for storing data, i have to deploy this software different machines for different clients. The question is how can i protect my database so that no one even the administrator of the server or the machine administrator can view my database structure or the...

Hello out there here i am having difficulty in fetching the Brands Per ctegory in the sidebar of my website Here is the description .. I am using the feeds and feed uploader to upload feeds and create brands and Product categories in wordpress The Problem is there is No link Within the Product_category and product_brand and i want too show...

I have two different source locations. One has a file share assoicated with it and it works, the other is a UNC path to a NAS device and the file cannot be found. When I cut paste the XCMD to a dos window it works. Is there something related to the location, device, share that causes it to fail when running in XMDShell .

OK, using SELECT I can view a database record from one of my tables, but now that I can see the selected record I notice that the first name, for example, is spelt incorrectly, and I wish to manually correct this mistake. Using transact SQL how do I, or can I, instruct SQL Server Management Studio that I wish to make specified column editable. I...

I am running MS SQL Server 2008. I frequently need to manually run a large quantity of query files at a time. I need to log the results of the queries to a file without having to enter a new file name with each query executed. I wanted to automate the running of the batch of queries through the OSQL command specifying an output file, but...

encrypting coloumn ..hiding password charecter use CRM create table h1 ( uname varchar(20) null, pwd varchar(20) null, varbinary(200) null )

Hi, how do I write this in sql script. I want to count the records from two or more joined tables and place the result in a new table. Attached is my tables. Thanks. http://bytes.com/attachments/attachment/6809d1357733881/count_sql.jpghttp://bytes.com/attachments/attachment/6814d1357788796/updated_tables.jpg

Hi Everyone, I'm running a delete statement to remove millions of records in a table on a live environment in full recovery mode. Because of the amount of transactions the delete is sure to create, I decided to run the operation in batches of 250000 records each. In order to control the size of the transaction log, I've also scheduled a job to...

All, I am new to creating scripts to run on SQL. My goal is to create a script that allows me to query one table for an "id" value and then run a delete statement on another table to delete a row. These are the SQL commands I run manually and I would like to automate this so I don't have to get into SQL MGMT Studio each time. select id...

What would be a quick way to allow users to connect to sql server 2008 server or express editions no matter their username, password, windows group or domain? My app is been installed from various accounts and i am forced to create the same username and password, or windows group. I don't have such power on the users who are going to work with...

SELECT DISTINCT broker, COUNT(case when cntsze=20 then cntsze end) as '20', COUNT(case when cntsze=40 then cntsze end) as '40', COUNT(case when cntsze=45 then cntsze end) as '45' FROM CYMgps WHERE ( sysdte BETWEEN '2012-11-01 00:00:00' and '2012-11-30 23:59:59') GROUP BY broker ORDER BY broker asc

i have deleted once sql server 2005 from control panel and from all programs also then i reinstaling thq sql server 2005 at that time i m getting error the message shows like"software is installed already" what should i do pls give me details