Microsoft SQL Server Forum

Hi, I have an application that used to need SQL Server but no longer does. I have removed all database modules and references to SQL wherever I can find it. I have also removed the Prerequisite checkbox for SQL Server 2008. However the application still has the following notice on installing. Component SQL Server 2008 Express has failed...

Hi every one. i want to write a query to get the records of last 12 months in sql like in LINK in its ARCHIVES section at side bar. any kind of help will be greatly appreciated. Regards Mudassir

good day. sample database: table1 col1 col2 col3 A item1 100 A item2 200

select interid from Messages where (text like '%あなたの机に2014-10-16-11-31-41%'

I need to do the smilar vlookup (Excel function) in SQL command. Just explain to the below example Table 1 Store Type Region AA12 RGS AAA AA13 REM BBB AA14 RBK CCC Table 2

Hello all, I'm new. I'm trying to run a scheduled task from SQL Server. The meaning is to run it from a server to another server. Let's say that Server1 is where the command is executed and the scheduled task exists in the Server2. Here's what i do : EXEC master.dbo.xp_cmdshell "net use \\Server2 password /user:username /persistent:yes"...

update tbl_ApplicantInfo set PinNo=substring(pinno,2,10) hear pinno is numeric, for this reason this comd is not execute

can someone pliz help in sql 2005 when i want to create a new database this mesage appeared"CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)" am using admin account i will be thankfull for your assistance as soon as possible

i have four table table user info = there are 6 columns one is primary key tables user roles = two columns one is primary key table user dep = two fields one is primary key table user profile = there are four fields one is primary key others fields are foreign keys(table info,table roles,table dep) questions is of which table we have to...

how to delete last inserted row in sql server

Hi All, I have a table in sql server with some tables. And in that,one of the column on one table has the data like shown in figure 1. Now i want to separate(or)split in to two columns like shown in the figure 2. so could any one please provide the query for getting my required output. Thanks In Advance,

My output should be like this No.of Employees SALARY ------------------------------------------------------- Department Permanent Temp Total Permanent Temp Total ------------------------------------------------------- Admin 2 1 3 25000 15000 40000 General sales 2 2 4 15000 ...

On my system there is sql server 2008 enterprise edition and 2008 express edition. i want to uninstall sql 2008 express edition. I tried add/remove programs then remove and then selected instance of sql express but it also removed enterprise edition. Please guide me on how to do it Regards

buyer(name item) product(code sp cp) john a a 5 8 bella b b 4 4 john b c 5 9 smith a john c bella b

Good Afternoon Pro's, I would have submitted this question in the R group but didn't see one. I am trying to connect to SQL Server from R with the RODBC Package. In my SQLQuery line I'd like to user a LIKE operator but SQL Server doesn't recognize my syntax. How is the LIKE operator written in R when connecting to SQL Server? ...

hi could anyone help me fix my code.. i executed this line of code delete from Test.dbo.Test where Password='0x4465727374696E65' the password column has a data type of varbinary and i inserted a string into it.

hello bytes :) i have a problem inserting a record into my database.. i want to insert F into column serial where reference=1. How could i accomplish it. Thank You.

Hi, I am working on a table that has millions of records located on SQL Server unfortunately the table is dropped and remade everyday so they don't index this table. It takes a while to query this table because it is not index. It contains appointment information from all departments of course we only care about our department. So when we...

I am an Access 2010 novice who is trying to update one table with information from another i.e. when table 1 col 1 = table 2 col 1, update table 1 col 2 with table 2 col 2, but keep getting syntax errors when using the following code. Can anyone help point out where I am going wrong. UPDATE TrafficApr11toDate SET = (SELECT...

Hi all, Can any one please provide me the SQL Query for getting my required Output. I have a table in my sqlserver.That table stores the values like shown in the Figure 1. From that Input i want the Output as Shown in Figure 2. Please provide me the SQL Query to get that Output

Hi all, Can any one please provide me the SQL Query for my following requirement. As showing in the Figure one i have the Input. From that Input i want the Output as shown in figure 2. Thanks In Advance Phani Kumar.

I have created indexes for data base on my home machine in sql server 2008 R2 When i will restore data base to my work machine, indexes will also get restored or not. Work machine also has sql server 2008 R2 I hope i am clear. thanks in advance.

Hi, I have a table 1 with the following values: ITEM LOCATION SS_DAYS 316TA/JP415 052 21 316TA/JP415 062 0 316TA/JT266 052 43.17 316TA/JP415 062 0 I have table 2 with the relationship between item and location from table 1. That table reads as follows Original...

Hi Because VS 2013 dropped SQL COMPACT databases, I need to convert Access 2013 databases into SQL COMPACT in order to be able to use Linq to SQL in VB 2013. Anybody can help me? Thanks

Here's my SQL: INSERT INTO HFIAAREF (Select Distinct PolSt, PolNo, PolCn, PolYr, PstDa@, 0, 0, 0, 0, Compny, AgHd, AgBr, AgDv, AgID, 0, 0, 0, BlRatB, AlRatB, BlRatC,AlRatC, ' ', ' ', ' ', ' ', 'HFIAAPF12 ', 'SUSMST ',Current_Timestamp,...