SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• How to transfer database of sqlserver 2000 to 2005

  Hi, I install sql2005, and transfer my database of 2000 to 2005 (attach my database to 2005 ) but s…

  mooveisi

  1 replies

  17 years ago

  By: DNA_DBA

• Populate a Status column

  I need to create a view to display employee id and time in/out status. My view should look like thi…

  doran_doran

  5 replies

  17 years ago

  By: Lowell

• sql procedure

  I want to make a procedure in which data from one table can be automatically stored in a text file …

  er.programmer1

  7 replies

  17 years ago

  By: er.programmer1

• Change in port number of SQL Server Browser Service(SQL 2005) and SSRP (SQL 2000)

  Hi, I have a query regarding SQL Server Browser Service(SQL 2005) and SSRP (SQL 2000). Ques: Can we…

  shivani.suri2999

  6 replies

  17 years ago

  By: Andrew Hatfield

• SQL Server with PHP

  Hello everyone! I want to know from you, if you have experience with SQL Server - PHP 5. Did you tr…

  Dugi

  1 replies

  17 years ago

  By: dforck

• User Defined Function - With a Table??

  Hi, I am trying to create a UDF that will open a specified XML file and return a table with the XM…

  bkmooney

  8 replies

  17 years ago

  By: FelixG

• Simple Update Statement in The trigger does not work

  Below is my sample script to update the following dblSubtotalDetail ,dblsubtotaldetailRate ,dbl…

  ..+ hunter +..

  5 replies

  17 years ago

  By: Florian Reischl

• An input/output parameter to a SP

  I'm working on a new stored procedure, which want to to return a couple of scalar values with. One…

  Rod at work

  3 replies

  17 years ago

  By: Rod at work

• How to handle concurrency

  Hi, our application is for taking online test (assessment). Here we have a requirement of around 1…

  ManoharV

  4 replies

  17 years ago

  By: Florian Reischl

• How to Create a table with Auto Update Column

  Hi, The Below query is used to create the table with auto update column in mysql CREATE TABLE Table…

  Barnaad

  3 replies

  17 years ago

  By: Florian Reischl

• Without installing MSSQLSERVER can view MSSQL database

  Dear friends, I have one doubt.I use phpmyadmin for viewing MYSQL Database from my PC without inst…

  ashok-831066

  5 replies

  17 years ago

  By: Vinay Thankur

• get drive info with sql

  Hi there, I have this sql to get the total free space on fixed drive's on my sql server EXECUTE mas…

  torpkev

  6 replies

  17 years ago

  By: torpkev

• Where clause on converted datatype

  I have a binary field that contains the following test data: 1, 2, 3 I am trying to set up a script…

  bpowers

  12 replies

  17 years ago

  By: bpowers

• Case Statement Within TSQL

  I am drawing a blank. I am trying to retrieve data with the following: SELECT ent.firstname + ' ' …

  rsteeves-683406

  12 replies

  17 years ago

  By: rsteeves-683406

• exporting null values in excel table

  Hi, I am having a database that has nearly 100 tables. Here some of the tables have no values at al…

  cmrhema

  2 replies

  17 years ago

  By: Atif-ullah Sheikh