Echa un ojo a:<br /<a target="_blank"...
Use system_user (without @@). Please read this article: http://msdn2.microsoft.com/en-gb/library/ms191126.aspx
a) Cursor retrieve one record in each fetch and you have only one fetch. If you need all records, you must use a WHILE structure. Check on-line...
Try with convert(datetime, <data>, <format code><img src='/community/emoticons/emotion-5.gif' alt=';)' />.
<br /><font size="3">Hi all! I solved this !!!</font id="size3"><br /><br />SQL Server service started with same user, but each server has different...
Hemant: Thanks. I tried all solutions, but nothing solve my problem. I have two servers in merge replication. One table is not in merge...
You can compare it as string with convert(varchar(n), <field>, <date format> ). Search for convert command in SQL help to obtain date format codes....
Authentication mode is SQL Server & Windows. This is not problem because is my user.
(A) 1. Check if server permit client protocol (ex. TCP/IP) 2. Check if client permit server protocol (ex. TCP/IP) (B) If you have firewall,...
Hi! I execute a query without problem to insert data in another server: INSERT INTO [ip].mydb.dbo.clients SELECT * FROM clients WHERE IDClient NOT...
Steve: in many lenguajes means new line. If you have records like this, you can convert it to a new line indicator with replace ( <your field>, '...
Try this: declare @test varchar(8000) set @test = 'omg'+char(13)+char(10)+'Hi' select @test NOTE: You must have your SQL Query analizer in text...
Hi everybody! Thanks for your contribution.
Hi all! I can't use join with all tables, because not all products have records in each other table. This query is just for obtain products with...
I need a query just to check warehouse movements (products, initial inventory, purchase, sales, adjustments and actual inventory). Sample output:...
I have a query like this that is executed in 4 seconds: select field1 , ( select field2 from table2 where table2.state = 1 ) from mytable If I...
SQL Server 2000 SP 4, merge replication
Hi! After link issue, I have a lot of conflict records not important for me. I'd like delete them from system table conflict_%table%. Is this correct...
You should use alias for tables to avoid a large query and use this alias when you refer a field instead table or view name: ... sum(case when...
Both servers are identically (hardware and software).
Separate names with a comma.
