Development

• Topics

  Started by

  Posts

  Last post

• sqlcmd code in stored procedure

  Hi My qusetion: i want export Table data to text file usind sqlsmd? but i have to run sqlcmd code …

  Vasu-709835

  1 replies

  16 years ago

  By: Old McDonald

• Cursor - Help where do I start with this T-sql script task from my Boss, is this a select into?

  Ok below is my newest task assigned to me by my boss, before you curse me about cusors, the SP in t…

  adam spencer

  6 replies

  16 years ago

  By: Paul White

• Connection to Active directory from SQL server

  Hi, I am new to SQL server 2005. I am trying to get some user data from Active directory using link…

  BKAN

  1 replies

  16 years ago

  By: GSquared

• Compare two tables ("AND")

  Hi, I have to tables: table1 (SomeID int) and table2(SomeID int). One column in each table. Please …

  am-883928

  1 replies

  16 years ago

  By: Lowell

• How To Save Unicode Data in SQL server

  how to implement Unicode ...In a Database i m having a field with nvarchar (max) datatype when inse…

  polo.csit

  2 replies

  16 years ago

  By: Gift Peddie

• Calling Stored Procedure (SP) inside another SP

  I have one SP 'A' and another SP 'B'. SP 'B' is returning three tables. I want to call SP 'B' insid…

  Narayan LS

  8 replies

  16 years ago

  By: vihi.koyott

• Using Select into #Temp vs. Create #Temp then Insert into #Temp

  We write a lot of stored procedures for reporting purposes and in those stored procedures we create…

  civicman4

  10 replies

  16 years ago

  By: Paul White

• Check file existence by command prompt in sql server

  hi my requirement is i need to check any txt file on drive --------------------------------------…

  Bhuvnesh

  5 replies

  16 years ago

  By: Bhuvnesh

• FOREIGN KEY constraint Error. What should be change in which table structure

  Hello experts, I’m trying to write a code to insert data in one of the table ‘TotalTable’. First I’…

  mr_adeelalisyed

  1 replies

  16 years ago

  By: Jack Corbett

• sql timeout exception

  hello there i am using sql server 2005 at windows xp sp2 with a windows application i developed. …

  gr8.jain

  9 replies

  16 years ago

  By: Jack Corbett

• Deterministic Function

  I'm having trouble creating a deterministic function. For a bit of background, I had to add to a ta…

  David McKinney

  2 replies

  16 years ago

  By: David McKinney

• Query String with spaces

  Hi Can anyone advise me if it is possible to run a SQL query when one of the string values contain …

  sshalloe

  5 replies

  16 years ago

  By: vihi.koyott

• Issue with Table script

  Hi this is the table script CREATE TABLE [dbo].[RequestSubTypes]( [RequestSubTypeID] [int] IDENTIT…

  Rookee DBA

  5 replies

  16 years ago

  By: Rookee DBA

• Primary key column and Index on the same.

  Hi, How to decide when to have Primary key as clustered or non-clustered on a column which as ident…

  Rookee DBA

  2 replies

  16 years ago

  By: Rookee DBA

• Automate Job Creation

  Hi all Can anyone help me to create a job that execute once a year.... In job creation wizard i fi…

  savee

  1 replies

  16 years ago

  By: Ian Scarlett