|
Hi,
I would like to retrieve specific region names, where a region code is less then 3 characters. I cant just do a normal select query, as some of the codes are more then 3 characters. Here is my sql query, but its not returning anything.
SELECT RegionName, RegionCode
FROM Region
WHERE DATALENGTH(RegionCode) < 3
ORDER BY RegionName
|
|
|
|
|
Change query as below and try
SELECT RegionName, RegionCode
FROM Region
WHERE len(RegionCode) < 3
ORDER BY RegionName
|
|
|
|
|
Thanks alot. It worked. I never thought of LEN()...
|
|
|
|
|
hi everyone,
i need sample or tutorial of an application that work with ms access database (*.mdb) or sqlserver that installed in server and clients could run application with shortcut and work
i wanna create a networking application
many thanks
|
|
|
|
|
hamid_m wrote: clients could run application with shortcut and work
What does that mean?
hamid_m wrote: i wanna create a networking application
And what do you mean by "networking application"? To me a "networking application" means an application that configures networks.
|
|
|
|
|
hi,
i have two databases which are used for different projects. but i need to update a column of one database with the data from another database.
is there a way to do that using SPs? or any other way?
thanks.
regards.
|
|
|
|
|
You can do this job by these statement.
1)Declare a Variable like v
2)Select the record you want use by SELECT Statement and assign it to the v by = operator
3)Update the record you want by UPDATE Statement and set it to the v.
I hope this solution is useful
|
|
|
|
|
Here we go!!
Use joins (normal, left or right) between tables across the databases. You can call different databases in TSQL with dot operators (..).
Eg:-
Select n.name from northwind..authors n, pubs..aurhors p
where p.authorid = n.authorid
|
|
|
|
|
You need to prefix the schema.tablename with the name of the database. For instance:
Update database1.myschema.table1 set value = 10 where id = 20
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
hi
i want to see an example that how to use trigger in sql server 2005,thanks ..
|
|
|
|
|
Now, repeat after me:
Google is my friend. Google is my friend.
Clickety[^]
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
I use SQL Server 2005 and Visual Basic 2005.
I write these Statement in SQL Server but it executes these with error and the record dose not inserted into table Project.
CREATE PROCEDURE Insert_Project
(@pNumber_M int,
@pRow_Agreement int,
@pRow_Machine int,
@pRow_Language int)
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
DECLARE @Number_O int;
SELECT @Number_O=Number-sum(Number_A) FROM Machine_View WHERE Row=@pRow_Machine GROUP BY Number
SET @Number_O=@Number_O-@pNumber_M;
INSERT INTO Project
(Number_A,Number_D,Row_Agreement,Row_Machine,Row_Language)
VALUES
(@pNumber_M,@Number_O,@pRow_Agreement,@pRow_Machine,@pRow_Language)
UPDATE Project
SET Number_D=@Number_O
WHERE Row_Machine=@pRow_Machine
END TRY
BEGIN CATCH
SELECT ERROR_PROCEDURE() AS ErrorProcedure;
END CATCH
END
GO
Please help me.
Thank you.
|
|
|
|
|
mghiassi wrote: it executes these with error
What error?
|
|
|
|
|
Hi
The statement below return another code and not zero
SELECT ErrorProcedure AS ERRORPROCEDURE
Thanks for your help
|
|
|
|
|
mghiassi wrote: The statement below return another code and not zero
That is hardly helpful information. What code? If you remove the TRY/CATCH, what error is given (That should give you a textual description of the error)
|
|
|
|
|
Hi guys ! I have installed windows vista and i also installed microsoft sql sever 2005 express edition, and also I have downloaded the requierd update ! but when i want to create a database i get this message :
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
The server principal "MRK\Mr.K" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916)
|
|
|
|
|
hi,
i need a help in an automation of data fetch from db to excel.
I am having 2 tables in sql server db. at present i will type hundreds of number in excel sheet then i will import that to sql server as a table then executing that table and the primary table using some sql statement i used to fetch the required information. now the problem is when we are doing it for multiple records its too difficult to repeat the process repeatedly.so i want to automate this process.
for example:
primary table:
slno eno,ename, eaddress, ecity
exporting data through excel is eno
comparing this eno in excel with the primary table i can fetch the remining details to the specified set of eno.
how to automate if anyone have idea please share it. so that i can begin my process as soon as possible.
Tech_spidy
|
|
|
|
|
I would used DTS. It comes with SQL Server.
If you have sql server 2000 go to where you start enterprise manager. There is an icon that says import export. If you are using sql 2005 you need to go to the database you want to export the table. Right click the database go to tasks then export.
Pick your sql server name and database to export from.
Pick Excel from the drop down and set the output file name.
Then pick the table / table names or do a query.
I think that could work pretty nice for you process.
I hope that helps.
Ben
|
|
|
|
|
This is what i am already doing. I need a solution like by clicking a single button it has to export the data by executing the query in db.
Tech_spidy
|
|
|
|
|
i want copy of sql table on lan computre can i copy paste
how???
|
|
|
|
|
You can do this job by this solution
Generate the script code for the table by right click on the table and select script table as and
select Create To File and then run this file on the another computer
|
|
|
|
|
You can do this with "Copy" option of right clicking that particular table and paste in Query Analyzer - simple!!
|
|
|
|
|
Is this way a good solution in SQL Server 2005
|
|
|
|
|
hi all
can any body guide me please the exzact difference between a stored procedure,view and a simple aql query what is the major difference based on functionality between these three ,,,
thanks in advance
hello
|
|
|
|
|
A stored procedure is a cached pre compiled sql statement that exists on the database. It can have parameters or not, it can return result sets or not.
A Sql Query is a sql statement that you pass to the database.
A view is a subset or whole table or joined tables that you want to expose. Often if you don't want to do the same join over and over again you can create a view that does the join and only has the columns you are interested in. Some views are updateable, normally when they are only of a single table. Some people use views to control what other users have access to. So the user does not have access to the table, but the do have access to the view.
You can always do some searching on the net to get more info:
http://msdn2.microsoft.com/en-us/library/ms189826.aspx[^]
Hope that helps.
Ben
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
