Topics
Started by
Posts
Last post
How can I move a text file within a stored Prcoedure?
10 replies
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Community') DROP DATABASE …
2 replies
Hi All, I have a stored procedure which works perfectly when the Table name in the Cursor query is …
5 replies
I need to number lines for which I can not use the identity column to populate. Example Doc No …
9 replies
I create a stored proc (Northwind): CREATE PROCEDURE spTest @EmployeeID INT, &nb…
13 replies
Is there a way to temporarily override a column that does not allow NULLs in a SQL procedure to all…
5 replies
I'm having problems creating a T-SQL stored procedure that creates a new SQL Server 2000 database o…
2 replies
Is there a limitation with SQL version 65 and using the TOP operator in a query? Lisa
2 replies
I'm trying to run a simple update query that replaces the values in "Table A" with the new val…
2 replies
Looking for T-SQL to accomplish 2 "COUNTS" in 1 pass (if possible). I need the: 1. COUNT of t…
4 replies
Hello, I am working on dropping unnecessary Non Clustered Indexes on tables in my database. As part…
12 replies
Hi, How to lock the table in SQL Server? Within my stored pro…
2 replies
We have a template database in which development is done. We back up that database to a BAK file, a…
4 replies
Is it possible to retrieve the results of a stored proc as a derived table inside the FROM clause? …
11 replies
Hello Experts!!! I need to colapse several rows into a single row and concatinate a text field acro…
1 replies
Viewing 15 topics - 10,051 through 10,065 (of 17,082 total)
You must be logged in to create new topics.