Topics
Started by
Posts
Last post
We have a third party SQL 2000 Database which is suddenly giving strange results in that a simple e…
8 replies
How do I do this? I have a XML data type with XML text in it. How do I view the XML as a table? I…
13 replies
Table Data --------------------------- ID Dept-ID Version 10 30 0 20 30 0 20 30 …
4 replies
I have the following SP that runs daily. ALTER PROCEDURE [dbo].[usp_token_disable] AS BEGIN set noc…
2 replies
Hi, I need to identify what logins exist and what access they have to each database on the server. …
4 replies
Hi folks, I need to add code to an existing dos batch file that will return one single row of data…
5 replies
An existing trigger prevents bulk data insert into a database. In a stored procedure that pushes da…
9 replies
This is my main (and simplified) table: if object_id('tempdb.dbo.#Scan') is not null drop table #sc…
7 replies
Hello, I have a problem designing a table from a matrix in excel. Is it even possible in SQL Server…
5 replies
I have a column value like this 'Merged Facility Id:0286- Patient Id:999000 PHPatId:28488 with Faci…
6 replies
I have written a stored procedure where I am using a TRY .. CATCH block, but that CATCH wasn't bein…
8 replies
Hi All, I have a table with below data create table t1 ( name varchar(50) ) insert into t1 select '…
10 replies
I'm trying to insert records to a table with identity column. I first set it to on and try to inser…
7 replies
Given a table like this declare @Tab1 table ( id int identity(1,1), v1 int, v2 int, v3 int, v4 int,…
25 replies
Hi all, I used sqlcmd -U dbName -P password -S hostName -y 0 -u -d dbSchema -i C:\MyLargeScriptFile…
2 replies
Viewing 15 topics - 1,606 through 1,620 (of 12,234 total)
You must be logged in to create new topics.