Using MS SQL Server
in [Microsoft SQL Server]
|
Linking Windows SQL Login to user database Hi, I am migrating SQL 2000 database from one machine to another using the detach/attach method. I used the TSQL script sp_help_revlogin procedure provided by microsoft to copy the logins, this work for SQL Logins but not Window Login. I am able to logon to the SQL Server with the Window Login but have no ac... 1 Aug 2008 18:10
Calling Commonly Used SQL (reusable code) Is there a way in SQL Server T-SQL to store commonly used SQL statements in a function, stored proc, or system variable? That way if that code ever changes I can change it in one place. If I use the code below in 100 different SQL statements... can I stored it somewhere and just call it from another SQL statemen... 31 Jul 2008 18:34
Export to Excel, exclude header Does anyone know how to export from SQL 2000 to Excel but exclude the header row containing column names? Thanks. ... 31 Jul 2008 12:22
Can a dropped table be recovered? I'm guessing the answer is 'no', but I thought I'd ask. Basically we have a client where it looks like someone has issued a DROP TABLE command - or at least so far as we can tell. The table certainly isn't there. No backups, of course. That would be _too_ easy. MSSQL2000 (actually MSDE). Any thoughts appreci... 1 Aug 2008 02:45
How to show field that not being group Hi all. I have this data: id GroupId DDate Value 1 1 7/31/2008 5 2 1 7/31/2008 6 3 1 7/31/2008 2 4 ... 31 Jul 2008 00:04
Softclarity Builder Construyelo fácil y rápido. http://www.softclarity.com.ar/Builder ... 30 Jul 2008 11:16
Distinct Row based on description count Hello everyone. Hope someone can help. I have a table with two columns Material Number and Material Description. Sample data below: Material# Description 10000 This is item 10000 10000 ... 2 Aug 2008 05:23
Accepting wildcards like % in input parameters of stored procedures From a security point of view, is accepting wildcards like "%" in input parameters of stored procedures against any best practices? As an example, if a user defined function uses "Productname LIKE @ProductName" in WHERE clause of a select statement, and a stored procedure uses the user defined function while pass... 31 Jul 2008 04:10
problem with column alias Hello, i have a problem using aliased column. I have the following query: With masids AS ( select masID, dbo.concat_friendly(masIDFrom) as 'From' ... ,ROW_NUMBER() OVER (ORDER BY From ) as RowNumber from ... ) (truncated) I just need to get a c... 29 Jul 2008 12:38 |