Home : Bytes IT Community / View Full Version : Microsoft SQL Server
- How We create a password protected database in sql
- replicating data between master and slaves
- Mssql Page Number Query help TOP , NOT IN ??
- Problem placing results of generated select statement into dynamic temp table
- Multiple Sum and Join
- How to find login name and password for sqlserver 2005
- Working out a percentage using sql
- How do i SUM up values returned by TOP 5 and COUNT statement?
- Strore large texts in mssql and dispaying them in php
- How to find the frequent access table's (hit)
- SQL query/unique entries only
- SQL newbie, need help cleaning up my SQL (works, but ugly)
- Foxpro: Connection limit?
- Sum up a column and then update a temp table with results
- SQL Using a single variable to store multiple results
- SELECT In order by specific Ids
- SQL Server 2008 - What Else Am I Missing?
- Help with SQL Server
- Reg sql query
- formatting numbers keeping the lead zero
- MSSQL Equivalent to MySQL ENCRYPT/DECRYPT
- DB2 linked server from sql server 2005
- Unable to attach DB (MSSQL 2005)
- Cumulating data
- problem with the query
- maximum query
- Custom Report
- Query For Excel Macro
- Querry optimization to have better performance
- help me in understanding this update statement
- account
- path of unsuceesful installation of sql 2000
- how can i fix this!
- Need help with MIN function
- Named Pipes Provider, error 40 - Sql Exception (0x80131904)
- Need help with error on JOIN statement
- Database Objects
- A set of tables for each user vs one set of large tables
- how to set and get value of Variable in sql server 2005 Integration Tasks
- Double Insert Statement Probs
- SA Upload SQL Database variable types (image upload and storage)
- SQL LIKE help
- Insert a row into a table with 2 foreign keys
- SQL OLE DB Problems
- Trigger Problem
- Sub Query for fetching records - Urgent Please
- Query to display Count as zero if no records exists - Urgent please
- cyclic cascade paths
- Select query to know the Count of two columns in different tables
- SQL Joins or Multiple SELECTS in Procedures
- SQL2K +SP3 Replication error
- Ssis/ssrs
- Not In
- Spool to a file from MSSQL
- css in rdlc
- field length problem of varchar
- Global Temp Table (with .NET)
- Update Query..
- Please Assist...SQL Server 2005 New Line in Text
- sql server procedure
- Get Row(s) in error MSSQL2005
- dividing agregate functions in a grouped query
- SQL tuneing
- Loop on results, call sproc
- Formatting phone numbers
- SQL DTS SQL Task for .PGP Encryption
- Fire an SQL Server Trigger on a Bulk Upload
- SQL Query to display count of two columns from different tables
- How do I use bcp to insert into sybase
- The inserted and deleted tables are empty ? (trigger operation)
- SQL Select Query to fetch Count of two columns from two different tables
- Select query for fetching records from two tables
- Procedure for deleting records
- SQL2000-How to reclaim the Unallocate Space for Database(low hdd space - Urgent!!!)
- error while executing stored procedure
- Find hidden triggers in database
- Raising events from sql server 2005
- Programatically add columns to .rdlc
- How to convert a Varchar into a Int with sql 2000?
- LoadFromSQLServer failed
- How to display a date stored in a table with the desired way?
- Sql Query
- It's Me again!
- Call DB2 database from sql stored procedure
- About where clause
- Inline table function
- SQL Server
- Copying data in SQL Management Studio
- update
- sequence
- how to make server
- Table/ ERD design for university students enrollement system HELP HELP HELP
- central backup
- Count and group of a date column
- I need 'order' in a select w/ Union statement
- SQL2000- How to use DateDiff Function together with (If then..else)
- How to isolate a DBTYPE_DBTIMESTAMP to datetime error?
- SQL Query Help - Convert string to byte array or copy string data to another table?
- How to Change Font size
- Distributed view joining int and bigint
- Hello there
- Combine two column with sql statement
- What SQL version am i running? Free or not
- MSSQL Query
- Union query in sql issue
- How to Pass Parameters from SQL Server Stored Procedure to Excel
- sql query out of range datetime value
- selecting a date range using query
- jsp to sql
- hierarchical results in sql server 2000
- Value Truncates When Using Float Datatype
- time out expired
- BULK INSERT Question
- SSMS Keyboard shortcut for CTRL+B
- Temporary tables
- Is DTS possible to schedule like a job process?
- Ration calculation
- Increment an order number which is not pure numbers
- Login in SQL*plus
- error while executing job on Sql Server Enterprise Manager
- Sorting four columns using sql query in query analyzer
- SQL 2005 Express Security
- How to attach MS SQL 2005 Express database to MSDE (2000)
- how to display display available or unavailable time slots in SQL Server
- unique values combined with COUNT()
- problem in identity
- how to AUTOCOMMIT ON in SQL server 2005
- Help on the following SQL server Select query
- Change Collation Name in a database (SQL SERVER 2000)
- table values function in SSIS
- SQL Update Trigger Question
- install script
- finding PIVOT table data source
- How to use Cast
- truncate decimal place
- query is slow after inserting lots of records in some tables
- Recursive Update Query for SQL server
- Tablediff Utility SQL server 2000
- generate SQL script from DTS
- how to get todays Inserted and updated records in sql server 2005
- searching fields and displaying feilds with data
- MsSQL - Not storing and returning milliseconds
- Best method for storing a time in a MsSQL database?
- UPDATE Record's
- Deadlock Issue
- T-SQL: Recursion and circular references
- DTS: Copy new + modified records from table1 to table2 from two different servers
- MySQL to MSSQL Conversion
- Encrypt and decrypt a full database in sql server 2005
- SQL Serial Data to Parallel
- SQL Installation
- get the jobs run in a particular time interval from sysjobhistory
- How to create a distinct table combining records with Null values
- Columns
- How to store the result set in temp table
- Is there a limit in retrieving foxpro file using VFPOLEDB ??
- Validation Constraint on Data Entry
- Creating Reindex
- query on multiple database
- pivot? rows to columns
- SQL 2005 Express
- Comparing data in two different tables to find missing records
- scheduled data clearout
- IDENT_CURRENT help
- get latest date record
- MS SQL 2005 Replication, unable to create publication
- Calling external apps from SQL Agent
- Update date In MS SQL
- Update table name and all objects that reference it
- Convert Access quey to SQL statement
- How to validate a column using stored procedure
- undeclared variable in stored procedure
- mapping path of a file
- SQL Server 2005 - Developer Edition Installation Error
- Moving SQL server to another
- SQL server 2005 enterprise manager
- SQL Problem
- I want to connect DB in SQL with data in Active Directory(Urgent)
- Open record sets
- MS SQL Problem
- Problem With MS SQL
- Create Trigger
- Complex Query
- SQL 2000 server replication and a MSmerge_tombstone problem
- Significant Figures/Digits.
- Database size shows huge
- Query for displaying a particular set of data
- Update auto increment feild to replace nulls
- Calculate Number of working Days in a Given Period
- Update/Insert with constraint
- SS2000 500xSELECT on one table; how to speed it up??
- Generating Script for a DataBase
- How to do incremental update?
- 'FROM reallyReallyLongTableName AS a' syntax?
- package configaration SSIS
- Determine which fields to select based on date
- Use output of Stored Procedure as where condition
- Exception handling in stored procedures
- please solve this problem
- Sql Connection
- spli two rows
- Database login failed
- Incrementing Filename when saved
- problems with case statement in where clause
- Does SQL Server support a row count function?
- Sql Server Install
- Store DWG file in SQL server?
- Import table from notepad to SQL server 2005
- Insert from SQL2005 to DB2
- Cannot Create DSN connect to SQL Database
- Update Status column after specific date.
- MSSQL bcp command help
- Using charindex AND substr to pull out data
- restore .dat
- Looping through recordset creating calculated Rank Column
- compare lock setting in sql srv 2000 and 2005
- Automation error
- Create Index on View
- Uncommon records from two table
- Determine the byte size of a particular row?
- BCP with special chars
- joining multiple tables based on 1 criteria
- Stored procedure incorrect?
- need a query (columns to rows and rows to columns)
- Round to 2 decimal
- Creating Database
- Replication of MSSQl database from one server to another
- compare ntext to datetime
- Computerised Date
- How do i use LIKE for a search query?
- automatic id generation
- Slow Query causing application problems
- Query problem
- create database
- Trigger and procedure
- query
- Insert in two tables
- Please can someone help
- How to insert dates using datetime functions.
- import data from excel into sql server 2000 by C# in .net
- count the rows
- Cursor does duplicate records
- ODBC--call failed.
- BCP error on a database with name in two words
- Query Across Multiple Tables
- Delete a BackupDevice in Code
- Date conversion problem
- SQL DB Backup
- Select Query with = not returning any rows
- Stored Procedure to reliably update two tables.
- Dynamic field names
- SQLServer2005 procedures
- sql update trigger that updates table 2 when table 1 is changed
- Restoring a SQL Server 2005 database without the log - revisited
- SQL Server Agent confuse?
- Capturing the date and time based on clients timezone in SQL Server 2005
- Import data from comma delimited text file into an SQL Server table
- Help to query a date range
- Why is SQL Server procedure not executing properly?
- Handling multiple database with stored procedure
- Connection is busy with results to another hstmt
- DB BAckup
- Distributed query [drawn out problem]?
- Login failed user error in running web application
- Error updating the employee details!", help
- Problem in using LINQ to SQL
- any sql code to search database tables ?
- Getting check constraint error from sproc?
- Recursive Stored Procedure
- how to write trigger in sql server 2005
- how to sum some field in a row
- Strange issue in execution of sql
- how to Backup only selected tables
- How 2 store values through Stored Procedure from ARRAYLISTwhich is from Database only
- UPS WorldShip SQL
- problem with MS sql server 2000 database table
- various errors connecting - possible permissions problem
- Group By and Having are driving me crazy!
- Problem with REPLACE with binary strings
- how to decrease the size of database
- Recursive update query
- Difference between check constraint and dafault constraint
- merge data from two sets into one
- select @@identity
- no text in object
- SQL Server / Access commands/recordsets
- How to create a new database with an unknown name?
- Passing querystring to a website through sql report
- How to Lock and Release Table?
- RESTORE DATABASE is terminating abnormally
- Orders Database Storing Orders
- Update record of two table
- Unable to view SQL7.0 Table Records through visual basic
- Right Justified with leading zeroes
- getting error in query..
- Update Record in two Table using trigger
- Building a datacube with Excel 2007 and SQL Server 2000
- DB Backup
- Execute store procedure
- How To Save File to varbinary(max) in SQL 2005
- SQL Query Analyzer
- trigger - Incorrect syntax near 'INSTEAD' error
- Strange join in query
- Displaying records in new line
- Sql Inner Join/Union
- if condition in stored procedure
- Common data
- Index on field length
- Selecting criteria from SQL DB
- How to convert a number to Hour:Minutes?
- Downloading database from server on client machine
- Escape [] characters in an sql query
- Edit/Rename attributes with many tables from excel file source
- SubQuery Question
- Match two tables.
- Alter Or Create Procedure?
- Mulpliplcation of all values in a column plus converting negative values
- Reporting Services close download interface without exporting
- Stored Procedure
- Faster way to check if a record needs updating
- SQL caclcualted field
- Dynamic ORDER BY
- SQL Permissions
- Sql query date problem
- mSQL + Perl = Phantom rows
- SQL Query Assistance
- Foreign key
- Variable database name in stored procedures
- Crystal reports
- Calculating Opentime between several records.Using SQL Server 2000.
- Calculating Opentime between several records
- How to compare date,month,year
- Counting days in date fields
- SQL Query Email
- How to get Last Thursday Date
- Xml Bulk Load in SQL 2000 relationship error
- Suffix in dates
- Order of Triggers in SQL Server
- How to list all servers of MS SQL server?
- How are parameters passed in Triggers?
- Number of Queries in Stored procedures...in SQL Server
- SQL Query to select top 10 records except for the top 10 records
- Getting specific dates in SQL
- Help in writing SQL query
- SQL 2005 to XML
- Securing Tables/Views
- Using two different database data in one application
- xp_cmdshell syntax commands
- Selecting Query
- Violation of PRIMARY KEY constraint..how to solve this error?
- Merge multiple row values to a single row
- Primary Key
- List all Databases
- cannot change the type
- Log file needs shrinking
- Space Available 0.00
- SQL Server Migrating from XP to Vista - How to copy databases over
- Accessing VIEW via SELECT statement from another server
- using exec
- bulk copy
- Replication - SQL Server 2000
- Update SQL table with Dataset
- Join table from sqlserver and sybase
- sql job schedule
- Insert a record that has been deleted
- Join Query
- microsoft sql server management studio
- Format Number in Sql Query
- How use the substring method with sql 2000?
- Problem with Query
- How to get the month back from sql server 2000?
- Select a Random Sample of Raws
- Is it possible to run SQL-Cursor through cmd??
- hi needed help in a query
- How to stop writing into log file when DTS is executing.
- Convert Character Sets On Export
- Issue with inserting record in db table.
- How to reset Identity column
- Identity Column
- Issue Select statement to read Oracle table from SQL Server
- Using LIKE Operator
- How to set certain value into field?
- Select query help
- data type for a field in sql server
- How to calculate duration in a query
- Required Data between two dates
- Sql server 2000 Hanging problem
- How to display pop-up message in bold
- front end details
- Plannig indexing
- how to configure sql server 2005...
- How to fetch data using OPENDATASOURCE and Linked Server
- Date Between Problem
- DISTINCT UNION ALL query help (employees and dependents)
- Sql Stored Procedure
- Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
- Check null values for more than one column
- Index On A Columns
- Cannot schedule a maintenance plan
- SQL Server Isolation Level - Table Locks
- Find hard coded strings in SQL: can it be done programatically?
- how to get the row count value
- Is it possible to insert records through view....
- If conditions for stored procedure
- Insert more than 40,000 records
- MS Project 2007 SQL Server Enterprise
- Updating multiple columns with several conditions
- Round Function
- Specific Reasons To Denormalize
- Differnece between SelectStatement in View and StoredProcedure
- Exporting data from SSPS 15.0 to SQL Server 2000
- Alter Column datatype
- store procedure
- Access Runs SQL Server Slower
- Progress Bar
- Date calculation in SQL 2005
- Stuck with Truncate
- Stored Procedure for Searching
- auto generate ID'S in sqlserver
- Migrating Access to SQL "IIF Statement" Issue
- db open
- changing the position of column by writing a query
- How to activate distributer agent in subscriber or publisher?(REPLICATION)
- date problem
- Problem with Query
- Flag in SQL
- To change Date Format in Sql
- Any SQL statements to return no records found?
- plssssssssss help
- shorting problem in query
- Get number of days in a month
- Creation of DALC using stored procedures
- Regarding DALC Creation using stored procedures
- which datatype takes actuall value
- Converting Oracle SQL syntax to MS SQL 2005 syntax looking for a tool
- IF Statements in Stored Procedures
- Crystal Reports
- insert actuall value in sqlserver
- add float value
- copying from one table to another
- dataset transfer from client to server
- SQL Trace
- Using Round in a sql query
- Concatenating Certain Rows in Table
- sp
- Rows
- Parameter
- converting char to int question
- Showing a negative # as a positive?
- Update query not working in SQL Server
- SELECT data from two tables using same field labeled differently
- Table
- Permissions
- Differences
- Date
- select maximum in a table
- How to return a Pk value from one stored procedure to another stored procedure
- execute SSIS package from windows app
- Backup to a remote server
- how to use Regular Expressions
- Export
- User initializes variable through VB in a DTS package? Is it possible?
- Isolation levels??
- SUM of rows, when selection returns no rows
- Comparing the previous record
- Bcp
- Column Name
- Stored Procedure
- sql server stored procedure
- SQL Delete
- sql search query
- sql search query
- ERROR 1045 (28000): Access denied
- Storing a C# data of data type timestamp into sql server table and then perform SUM
- Calling A Crystal Report From Vb6 And Sql Server As Back End
- SqlCommand TimeOut
- downgrade dbase 7 to dbase 4 using command line
- Best match query and order by columns
- data type datetime ??
- Need Help in data Merging.
- Count child nodes in tree like data table, SQL Server 2005
- stored procedures question
- How to Eliminate NULL values from the SQL queries
- Limiting integers
- SQL SERVER Reports and multiple selects
- SQL Operation Performance Advice
- DATETIME - Time only needed
- Database Report Writer
- Regarding Date DataType
- Add A Constraint To An Existing Table
- Simple Query
- Regex in Stored Procedure Problem
- Dropdownlist
- Sql
- MSQL UPDATE table
- Nocheck Constraint
- SQL Server Stored Procedure
- Password format
- Cast an entire field from VARCHAR to FLOAT
- how to release table variables
- SSIS and HEX conversion.
- Constraint Triggers
- Creating multiple stored procedures at once
- SELECT and compare last two cost entries
- ssrs
- Database
- Sql
- SQL query calculation
- COMMIT & ROLLBACK
- select column names from table
- grid
- Performance based on design
- Create triggers
- if then else in stored procedure
- date/time in page layout - SSRS layout
- split color values into multiple records in sql server 2005
- mod operator
- xml datatype in sql serevr??
- @@rowcount
- Variable initialized by user each time DTS runs?
- What is @@SPID??
- Restoring MSSQL 2005 bak file to another instance
- Change Recovery Mode from Full to Simple
- Export Excel to SQL 2005 table
- SQL Server Express 2005 9.0.1399 Installer?
- % WildCard
- CASE stmt with isnull()
- problems with cursors
- SCOPE_IDENTITY issue
- I have a Problem With Stored proc_ help needed
- Cases in Select, Where, and OrderBy Dynamic Clause
- Problem with Query
- SQL Database design :- varchar datatype doubt
- Mismatch Records field need display Null
- Please Help In designing the Reports USing SSRS
- Trigger problem
- How do I add a folder to a ssmssln solution in MS SQL Server 2005?
- Add a list stored in a text file to a SQL Server 2005 database
- How to use WHERE IN syntax conditionally
- Insert into a table only if count is less than 'n'
- How can i have a copy of entire databse with out data??
- DateFormat
- Connect DTS with VB6
- SQL Server 2005 with SQL Server 2000 support
- How to retrieve the database which is deleted??
- how to use top 1
- Conversion failed when converting from a character string to uniqueidentifier
- max count
- Find the 3th,4th ,5th........... largest salary
- How can i change the column name?