Programming SQL

sqlcmd output is UTF-8
If I create a simple sqlcmd script: :out c:\temp\temp2.sql SELECT 1 GO :out STDOUT and run it, the output appears to be UTF-8. This causes problems not least because SSMS saves code as ANSI. I can open the output files in Notepad and save them as ANSI, but obviously this is not practical for large ... 14 Jul 2008 10:36

sql injection gibberish
I'm finally winning against the script injection attacks. How can I convert the below gibberish into code I can understand? I'd like to know what they are throwin' at me. title=A&bt=1;DECLARE%20@S%20VARCHAR(4000);SET%20@S=CAST(0x4445434C415245204054205641524348415228323535292C40432056415 24348415228323535292044... 18 Jul 2008 14:26

Group Concat on Temp Table (SQL2000)
Hi, I'm having a problem with a group concatenation on a temporary table in a stored procedure. I've been looking at http://omnibuzz-sql.blogspot.com/2006/06/concatenate-values-in-column-in-sql.html which provides me with a perfect solution for SQL2005 where I can do the concat in 1 single statement. Howeve... 14 Jul 2008 09:34

DMV to see queries done by user
Hi, using a DMV (or by using cross joins / apply ) is it possible to see a list of the queries done by a single user or on a single connection. I have tried looking inthe plan cache and the query text. eg. see all queries done by connection 54 or see all queries done by user DOMAIN/USER I realize that s... 14 Jul 2008 08:32

SQL Server View on two Database Server question
Hi, In my SQL Server 2000, I would like to create a VIEW across two databases on two database servers. How do I do that? Thanks for help. Jason ... 14 Jul 2008 04:27

DatePart to display 'Month'
Is there a way to display the 'name' of the month rather than the 'number' using the Datepart function? ... 14 Jul 2008 01:22

Designer Louis Vuitton Monogram Spontini M47500 Handbags, Luxury, Best,Inspired
Designer Louis Vuitton Monogram Spontini M47500 Handbags, Luxury, Best,Inspired Designer Handbags : http://www.bagsbrand.com Louis Vuitton Monogram Spontini M47500 Link : http://www.bagsbrand.com/Louis-Vuitton-M47500.html Brand : Louis Vuitton ( http://www.bagsbrand.com/Louis-Vuitton-Handbags.html ) M... 13 Jul 2008 21:17

Designer LV Damier Geant Canvas Handbags - Best Luxury Damier Geant Canvas Bags
Designer LV Damier Geant Canvas Handbags - Best Luxury Damier Geant Canvas Bags Designer Handbags : http://www.bagsbrand.com/ Louis Vuitton Handbags : http://www.bagsbrand.com/Louis-Vuitton-Handbags.html Best Damier Geant Canvas Bags : http://www.bagsbrand.com/Damier-Geant-Canvas-Bags.html You may find the mos... 13 Jul 2008 21:17

Designer Louis Vuitton Pochette Accessoires Riveting M40141 Handbags, Luxury, Best,Inspired
Designer Louis Vuitton Pochette Accessoires Riveting M40141 Handbags, Luxury, Best,Inspired Designer Handbags : http://www.bagsbrand.com Louis Vuitton Pochette Accessoires Riveting M40141 Link : http://www.bagsbrand.com/Louis-Vuitton-M40141.html Brand : Louis Vuitton ( http://www.bagsbrand.com/Louis-Vuitt... 13 Jul 2008 21:17

Creating view from query between two databases
Hi! I'm creating a view that uses several tables in one SQL Server but needs also to query another database on another SQL Server. In access query works like this. SELECT ProdottiRicambi.*, Ricambi.Codice AS Expr1, Ricambi.Ricambio_I AS Expr2, Prezzi_Mondial.[Ending Date], Prezzi_Mondial.[Sales Code] FROM R... 13 Jul 2008 23:20