- how to determine the column is identity column?
- The results that fn_get_sql() returns.
- SQL Server 2000 Enryption and Decryption Capability
- Using DateDiff to get time duration
- Tricky order by problem
- Selecting 1 random row from each of n random groups
- SP with an multiple values as input
- what table alias to use on update with self join
- DELETED Table
- How to get a 0 for value field when no records exist for that datetime..
- DB Syncronization
- Automating SQL Script Generation
- transaction logs-too large?
- Can not shrink a Database!
- Embedded and direct SQL
- Problem with BULK INSERT on an empty file
- How to list all tables of a SQL database
- execute a string as a logical expression
- White Space Problem
- IDENTITY not working
- Is this Code Reliable enough ? pls give comments..thanks
- Need help with a Tricky Update statement
- SQL Forum Problem
- Should This Produce Syntax Error?
- Stored Procedure Syntax
- Group by query
- need help with string manipulation
- nextMember
- str function adds a space
- ISNULL(MyTextColumn, '') returns error in View editor
- table variable vs temptable
- stress testing
- Unique Index for two columns in a table
- WHERE clause error
- SQL query help
- Help with complex SQL statement?
- Need a Book about Database Design
- USE variablename
- How to determine temporary table existance
- query help with substring
- Insert data to crossib qurey
- I need the result set of SP-1 in SP-2, How to get it T-SQL?
- asp file upload
- CASE or IF/ELSE
- error in user defined function?
- Multiple Cascade Flaw in SQL Server 2K
- Large recordsets ...
- GROUP BY Problem
- tutorial sites
- Program that inserts values?
- do I have to have a PK/identity?
- Interesting Query- Need Help
- How should I connect from VB to SQL Server?
- Updating SELECTED rows
- SQL help needed
- Question about the behavior of DISTINCT
- Incremental Load
- Odd Datetime Query Error
- complex sql script?
- suser_name() inconsistencies across servers
- Baffling stored procedure problem
- Dynamic WHERE statement
- Complex and Dynamic SQL Query ----------Please help
- Huge Log Files
- Top N rows
- parsing bug?
- Backup tables
- stored procedure much slower then same query
- Correct placement of SET XACT_ABORT ON
- OPENQUERY(server, 'msdb..sp_help_job ')
- index on table variable
- Append Variable
- Newbie: calling a UDF from a stored procedure HELP
- Question on Ownership chaining:
- Views Collection
- changing the current database within a stored procedure
- TO CONNECT A DATABASE TO MSDE
- Simulated Function in SQL 7.0
- parameterized sql scripts
- Date Conversion!
- Check in a Stored Procedure What violations have been done
- How to concatenate strings across many to one relationships
- Help in formulating a Query.....
- Cascading Ref Integrity in 7.0
- Return Value from Stored Procedure
- Import from exel to sql server
- newbie - trigger - syntax
- What is a merge join?
- newbie - triggers - is this what they're for
- Primary key or constraints in temporary table
- Newbie: Update all records of 1 table
- Stored Procedure and Variables...
- Eqivalent of Varry in Oracle for SQL Server ?
- auto start sql service when OS starts
- tion of a database
- Building Adwords mechanisem
- Dynamic SQL with variables in user-defined Functions
- Update Question
- ??? Domain Error Occurred ???
- INSERT INTO ... EXEC sp_who
- Data Page Size
- Where/when to fill an empty field ?
- stored procs and temp tables
- Partial rollback of transaction
- arrays in tsql ?
- writing a row to a table on another database server + identity column
- Efficient solution
- Repeating records
- Copying a table definition and populating it
- To normalize or not
- Joining two tables where ID's from one table is selected using LIKE % (Index hints ?)
- Transaction logs...
- Something rare!
- Naming
- GMTime equivalent in SQL
- execute command to express rule
- query problem, #temptable
- connect problem
- Using Trigger to populate another table
- result of that procedure will be different from 1?
- How to use a variable in my SQL code?
- Possible to access SQL data via NON SQL methods
- how to get the number of users signed up on each day for the current month?
- Many values from a single field returned into one single string
- Server: Msg 8525, ...Distributed transaction...
- parsing data
- Violation of PRIMARY KEY constraint
- Heterogenous queries ERROR 7405
- Does the Query yzer have a visual query builder
- Big HAIRY emergency
- Execute UPDATE from CURSOR and better way???
- Creating Random Numbers or Characters
- Getting Rows from Stored Procedures
- Final request for help!
- writing an upgrade script using conditional information
- using a sql statement to do a string replace
- Adding variables to SQL statements from URL parameters
- Rating System / AVG (Easy Question)
- how can i change jobs on a MSX server
- i need to get a field from a record
- SQL Question: Update using correlated subquery?
- When to use VIEWS instead of Stored Procedures
- SQL Output to a file
- Limiting the currency field
- huge deletion
- Guru Advice Needed for Query on Interesting Data Scenario
- Use of GETDATE() in Stored procedure logic
- how to get the error message in a stored proc
- Capturing the plain-text output of a stored procedure
- table data type in Stored Proc
- bulk insert error: 'Operating system error code 5(Access is denied.)'
- Junction Table Question
- rank w/ reset on group by
- INSERT programming question
- Stored procedures recompiling
- anyone help me with sp_setapprole
- Using GETDATE() within a user defined function
- Openquery Select Statement Returning Only 1 Record
- unicode to dbcs
- Updating millions of records
- Transaction have not rolled back.
- guru advice needed on temporary table problem
- Finding trigger in Enterprise manager
- How to get the data from Two servers
- More than one update in a statement?
- READ ONLY StoredProcedure
- using DTS transforming those records in decimal
- Excel to SQL Server
- Sony laptop with AMD processor - Cannot install SQL
- Changing field to IDENTITY in TSQL
- add 2 fields
- Dynamic time zone per instance or database
- variable question
- SQL 2K - FileGroups
- Alter Table
- Scripting DROP Table *and* DROP (related) Foreign Keys...
- select statement help
- bouncing between servers, table entries
- constraint in SQL Server2000
- performance in query...
- Complex parameters in Transact SQL
- Newbie - Calling a user-defined function
- Multiple table compare and update
- Oracle equivlent to Access 'select top 1...' ???
- Math Greater/Max function ??
- Is THIS Trigger Correct under CASCADE DELETE ?
- Date
- Column names
- Update more than one record (Subquery returned more than 1 value)
- DB Design
- how can I roll back an insert??
- Querying....how can I write this?
- Fitler by yesterday?
- Start Indexing Service
- I really need your help!
- Retrieve last identity from a table
- Variable table select in function
- Getting a SUM
- Help with select query
- how to get a value from an EXEC (SQL) statement
- may cause cycles or multiple cascade paths
- Sql Server Paging/Limit of Resultsets
- construct a date string in TSQL
- DMO and SQL Jobs
- Special Rounding
- Help in writing a query
- Selecting column names
- How to add leading zeroes to a numeric field?
- ADO & SQL Server
- Archiving
- how to suppress "warning null value..."
- MS Access Report Can't Find Stored Procedure
- Solid Schema or NOT?!?
- get data from previous row
- the quote are killing me. Can anyone see the problem???
- New login does not have access to any objects
- previous row question
- Server Name. Database Name
- Best CAST resolution for converting ...
- DTS samples in C++
- Cache and Stored Procs vs Prepared plans
- search for records between dates
- prevent updates/deletes on certain rows
- date question
- Ranks
- Function to P Date from String
- Very Slow INNER JOIN
- BUG: QA results in grid
- DDT?
- Resultset of a stored procedure
- auto increment without using a identity column
- update problem
- SELECT "newest Version". Please help :)
- number columns
- Newbie Question(need help)
- no more lock classes available from transaction
- trying to join on a computed value
- QA
- newb question on data model
- Help with SQLServer trigger
- How many indexes can I use in this table?
- newbie insert question
- An easier way to Transpose?
- Calculation across date periods
- Drop temp tables in tempdb
- Default Stored Procs Parameters value
- Need a workaround: error when saving stored proceduce
- UCASE(ing) the first letters
- creating a view with a decimal format
- SQL Question