String search problem in SQL Server - Database Discussion Boards

Re: user import

loyal ginger1-Dec-09 7:01

loyal ginger

1-Dec-09 7:01

Good point! The question did not describe that clearly.

Re: user import

AndyInUK1-Dec-09 22:08

AndyInUK

1-Dec-09 22:08

Sql server 2008.

i have already imported the excel spreadsheet with all the users info to database. Now for instance there are different table for address field, different table for name field , differnt table for email etc. So my question is do i have to use curser so that i can insert the users value from this temp table to all the necessary table. if yes then how or if not then what's the best way ?

Thank You.
Andyyy

Re: user import

Shameel2-Dec-09 6:53

Shameel

2-Dec-09 6:53

If your database is properly designed and normalized, then simple update statements will work, otherwise you may have to use cursors.

Re: user import

AndyInUK3-Dec-09 0:34

AndyInUK

3-Dec-09 0:34

simple update statement works to enter one record by manually writing the details that i need to update but how to go to the next row in the table, get all the details and enter it to specific tables.
So i am not interested in this manual process. Looking for something automatic - say cursor ? but not getting how to use that.

Re: user import

Shameel4-Dec-09 6:59

Shameel

4-Dec-09 6:59

The INSERT and UPDATE statements have a syntax that can be used to update multiple rows in the destination table from values in one or more source tables. The syntax is different for each database.

These are examples for SQL Server:

SQL

INSERT INTO EmployeeMaster (FirstName, LastName, EmpID)
SELECT EmpFirstName, EmpLastName, EmpID
FROM EmployeeTemp
WHERE (...........)

SQL

UPDATE EmployeeMaster
SET EmployeeMaster.FirstName = EmployeeTemp.EmpFirstName,
    EmployeeMaster.LastName = EmployeeTemp.EmpLastName,
    EmployeeMaster.EmpID = EmployeeTemp.EmpID
FROM EmployeeTemp T INNER JOIN EmployeeMaster M ON T.EmpID = M.EmpID
WHERE (...........)

TSQL for creating SQL Server Logins and Users

David Mujica1-Dec-09 7:44

David Mujica

1-Dec-09 7:44

Check these referencs out ...

Logins
http://msdn.microsoft.com/en-us/library/ms189751.aspx[^]

Users
http://msdn.microsoft.com/en-us/library/ms173463.aspx[^]

Re: TSQL for creating SQL Server Logins and Users

AndyInUK1-Dec-09 22:08

AndyInUK

1-Dec-09 22:08

String search problem in SQL Server

hvgyufg28fh38tyr78hf1-Dec-09 1:57

hvgyufg28fh38tyr78hf

1-Dec-09 1:57

Hai all,

I am searching one string (ex.Hello-Welcome) in text file using SQL query.
its searching Hello and Welcome seperatly and giving a result , i think bcoz hyphen(-) is a word breaker
in SQL .can any one give me the idea how to resolve the problem.
i need to use hyphen in searching string, and i need a combined string search result.

how to form the query?, if any one have sample pls send me.

thanks
mahe

Re: String search problem in SQL Server [modified]

Niladri_Biswas1-Dec-09 2:04

Niladri_Biswas

1-Dec-09 2:04

Let me know if u r not looking for this -

declare @t table(record varchar(100))
insert into @t 
	select 'Hello-World' union all
	select 'code - project codes are good' union all
	select 'hello' union all
	select ' world' union all
	select ' how are u-?'

Query

select * from @t where record like '%[-]%'

Output:

record
Hello-World
code - project codes are good
 how are u-?

Niladri Biswas

modified on Tuesday, December 1, 2009 8:12 AM

Re: String search problem in SQL Server

hvgyufg28fh38tyr78hf1-Dec-09 2:27

hvgyufg28fh38tyr78hf

1-Dec-09 2:27

thanks 4 ur reply

its like same but i am searching the hyphenated string
in text file.

if u know any SQL query to searchin the string in any file pls let me know.

thanks
mahe

Re: String search problem in SQL Server

The Man from U.N.C.L.E.1-Dec-09 2:28

The Man from U.N.C.L.E.

1-Dec-09 2:28

How are your searching?
Using Like, or some varieant of FullText searching?

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
[My Articles] [My Website]

Re: String search problem in SQL Server

hvgyufg28fh38tyr78hf1-Dec-09 2:30

hvgyufg28fh38tyr78hf

1-Dec-09 2:30

i am searchin with CONTAINS keyword.

select statement to display name 1000 times

arun_pk30-Nov-09 23:16

arun_pk

30-Nov-09 23:16

pls help me out to display a string for example 'abcd' 1000 times
using select statement in SQL

Re: select statement to display name 1000 times [modified]

Niladri_Biswas30-Nov-09 23:27

Niladri_Biswas

30-Nov-09 23:27

select REPLICATE ('abcd', 1000)

PRINT 'abcd'
   GO 10000

c) If using sql server 2005+

with cte as
( select 1 as rn,'abcd' as data
union all
select rn+1, 'abcd' as data from cte where rn<1000)

select data from cte option (maxrecursion 0)

DECLARE @x XML
SELECT @x =   REPLICATE ('<x>abcd</x>', 1000)
SELECT i.value('.', 'VARCHAR(MAX)') ReplacedStrings
		FROM @x.nodes('//x') x(i)

Niladri Biswas

modified on Tuesday, December 1, 2009 6:10 AM

Re: select statement to display name 1000 times

arun_pk30-Nov-09 23:31

arun_pk

30-Nov-09 23:31

thanks for the response
but this gives me an output in this manner
abcdabcdabcdabcd..................
i m looking for
abcd in 1000 records
likes this
abcd
abcd
abcd
abcd
.
.
.
.
.
.
.
.

Re: select statement to display name 1000 times

Niladri_Biswas30-Nov-09 23:35

Niladri_Biswas

30-Nov-09 23:35

Follow the third approach i.e.

recursive cte

Niladri Biswas

Re: select statement to display name 1000 times

arun_pk30-Nov-09 23:42

arun_pk

30-Nov-09 23:42

thanks
its coming
how will i be able to insert that 'abcd' 1000 times in my insert given below

insert into [dbo].[Test](NAME)

Re: select statement to display name 1000 times

Niladri_Biswas30-Nov-09 23:52

Niladri_Biswas

30-Nov-09 23:52

A) With recursive cte approach

declare @t table(name varchar(50))
;with cte as
( select 1 as rn,'abcd' as data
union all
select rn+1, 'abcd' as data from cte where rn<1000)

insert into @t
select data from cte option (maxrecursion 0)

select * from @t

B) Xquery approach

declare @t table(name varchar(50))
DECLARE @x XML
SELECT @x =   REPLICATE ('<x>abcd</x>', 1000)
insert into @t
SELECT i.value('.', 'VARCHAR(MAX)') ReplacedStrings
		FROM @x.nodes('//x') x(i)
		
select * from @t

Niladri Biswas

Re: select statement to display name 1000 times

arun_pk1-Dec-09 0:20

arun_pk

1-Dec-09 0:20

thnks a looooooot

Re: select statement to display name 1000 times

Blue_Boy30-Nov-09 23:38

Blue_Boy

30-Nov-09 23:38

One of the ways is:

create table #tblname ( 
col1 varchar(200)
)

declare @i as int
set @i=0
while @i<=1000
begin
set @i=@i+1
insert into #tblname  values ('abc')
end

select * from #tblname

drop table #tblname

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Re: select statement to display name 1000 times

arun_pk30-Nov-09 23:42

arun_pk

30-Nov-09 23:42

thanks for the response i m looking for doing with out looping

Re: select statement to display name 1000 times

Ashfield1-Dec-09 0:09

Ashfield

1-Dec-09 0:09

use the same method as you were told previously, a cartesian join, and limit it

select top 1000 'a' 
from dbo.sysobjects as so1, dbo.sysobjects as so2

and buy a book on SQL.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: select statement to display name 1000 times

arun_pk1-Dec-09 0:22

arun_pk

1-Dec-09 0:22

thanks for ur advice
but u are failed to answer my q
u buy SQL basics

Re: select statement to display name 1000 times

Ashfield1-Dec-09 0:25

Ashfield

1-Dec-09 0:25

arun_pk wrote:
but u are failed to answer my q

In what respect?

select top 1000 'a' from dbo.sysobjects as so1, dbo.sysobjects as so2

will do as your (vague) question asks.

arun_pk wrote:
u buy SQL basics

Why? Its not me asking basic questions about sql, its you that doesn't understand what you are being told will work.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: select statement to display name 1000 times

Shameel1-Dec-09 7:05

Shameel

1-Dec-09 7:05

arun_pk wrote:
but u are failed to answer my q

Ashfield's query works perfectly for your requirement.

arun_pk wrote:
u buy SQL basics

I just saw you being spoon fed by Niladri_Biswas and you are advising others to learn SQL basics ? Funny.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.