Solutions: 1) To remove the row count (“(139 rows affected)”) you should use SET NOCOUNT ON statement. See ref. 2) To remove column headers you should use -h parameter with value -1. See ref (section Formatting Options). Examples: C:\Users\sqlservr.exe>sqlcmd -S(local)\SQL2012 -d Test -E -h -1 -s, -W -Q “set nocount on; select * from dbo.Account” … Read more
To the best of my knowledge, there is none. Writing one is pretty straightforward, though. The following gives you the constant alpha and slope beta for y = Alpha + Beta * x + epsilon: — test data (GroupIDs 1, 2 normal regressions, 3, 4 = no variance) WITH some_table(GroupID, x, y) AS ( SELECT … Read more
Example query below, here are some details on how I solved it. Using DATEDIFF(WK, …) will give us the number of weeks between the 2 dates. SQL Server evaluates this as a difference between week numbers rather than based on the number of days. This is perfect, since we can use this to determine how … Read more
I don’t see where you will have much success exporting html to csv – it’s really not what csv is meant for. You would be better off using an xml format, where the html code can be enclosed in a cdata element. That said, you could try using the Replace function to remove the line … Read more
SQL Server triggers have access to 2 “magic” tables that contain a row for each row that was inserted, updated, or deleted in the statement that caused the trigger to execute. To find all of the inserted rows on a INSERT statement: select * from inserted For all of the deleted rows on a DELETE … Read more
When you perform an insert in a row the DB, it will be inserted in order relative to the other PKs in the table. With a normal guid, this could be anywhere in the table. A newsequentialid() will always be added to the end of the table. So the performance of inserts is improved. This … Read more
You’re right: at the standard isolation level, read committed, you do not need to wrap select statements in transactions. Select statements will be protected from dirty reads whether you wrap them in a transaction or not. connection 1: connection 2: begin transaction update user set name=”Bill” where id = 1 select name from users where … Read more
Rather than grouping, go about it like this… select * from account a join ( select account_id, row_number() over (order by account_id, id) – rank() over (order by account_id) as row_num from user ) first on first.account_id = a.id and first.row_num = 0
SELECT * FROM sys.databases
I finally figured it out. It was buried in the comments to the article jfrobishow published. Thank you SO much. Here is the whole response that led me to the solution: quote:Originally posted by fredclown If you use SQL 2005 you can use replace with a text type. All you have to do is the … Read more