sqlteam.com

Please wait for loading...




      (2340):

    /
     1  ~ 2014 sep 23sql server alternativa not inSQL Server Forums - better alternative for NOT IN - SQL TeamIf the columns are nullable not in is going to crawl. w SQL Server ...
     1  ~ 2014 sep 14db2oledb sqlexpressUse Microsoft DB2 OLEDB Provider On Non-Enterprise SQL Server Install the DB2 OLEDB Provider. Uninstall the side-by-side instance. Or keep it if you like it and have a valid license. Notes: I've only tested this ...
     1  ~ 2014 aug 28server news letterSQL Server Newsletter at SQLTeam.comThe SQLTeam.com newsletter goes out weekly with SQL Server related articles, forum posts and blog entries.
     1  ~ 2014 aug 20declare in viewSQL Server Forums - create View error at ' Declare ' - SQL TeamYou can't have DECLARE in a view ...a view is a simple select only. If you need parameters to your query you can create a table valued function ...
     1  ~ 2014 aug 11sql replace updateUsing REPLACE in an UPDATE statement - SQLTeam .comThis article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use ...
     1  ~ 2014 aug 10distinct group byHow to Use GROUP BY with Distinct Aggregates and Derived tables In How to Use GROUP BY , we worked on a simple report request and covered the basics of GROUP BY and the issue of duplicate rows caused ...
     1  ~ 2014 aug 08mssql update replaceUsing REPLACE in an UPDATE statement - SQLTeam.comThis article covers using the REPLACE function to selectively replace text inside a string in SQL Server . The REPLACE function is easy to use ...
     1  ~ 2014 jul 29sql datenbank in recorverySQL Server Forums - Database (In Recovery ) - SQL TeamIn management studio ( SQL 2005) the database appeared as databasename(in recovery ). I have subsequently gone back in to check and the ...
     2  ~ 2014 sep 03ms sql replaceThis article covers using the REPLACE function to selectively replace text inside a string in ... How to get Microsoft SQL Server 2012 started?
     2  ~ 2014 aug 25sql replace text
     2  ~ 2014 aug 24sql server forumsSQL Server Forums - SQL TeamThis forum is specifically for people that are working with SQL Server Programming for the first time. Anything T-SQL or SQL Server client related is welcome. ‎SQL Server Forums - ‎Transact-SQL - ‎Forum FAQ - ‎Active Topics
     2  +1 2014 aug 21sql server replace
     2  +1 2014 aug 17group by monthGroup by Month (and other time periods) - SQLTeam.comIf you add a Year into your GROUP BY clause, now you can safely group on a month number as well, and you are guaranteed that your results ...
     2  +1 2014 aug 12sql server in recoveryIf you clear space and restart SQL, the recovery might restart.
     2  ~ 2014 aug 09sql server forumThis forum is specifically for people that are working with SQL Server Programming for the first time. Anything T-SQL or SQL Server client related is welcome. ‎New to SQL Server - ‎Transact-SQL - ‎Forum FAQ - ‎Active Topics
     3  -1 2014 oct 01compare time in sqlSQL Server Forums - Comparing TIME - SQL TeamIs there an easy way to compare TIME SQL2K? We can use CONVERT function but that will be bit complicated. Any suggestion?
     3  +2 2014 oct 01sql server errorHandling SQL Server Errors - SQLTeam.comThis article covers the basics of TRY CATCH error handling in T-SQL introduced in SQL Server 2005. It includes the usage of common ...
     3  -1 2014 oct 01script auto histSQL Server Forums - Auto create History Tables and Triggers - SQL TeamFor my company, we have made it a standard to create history tables and triggers for the ... However, with this script it took a near 10 seconds.
     3  -1 2014 sep 30sql server group byHow to Use GROUP BY in SQL Server - SQLTeam.comSummarizing data in a SELECT statement using a GROUP BY clause is a very ... (This article has been updated through SQL Server 2005.)
     3  ~ 2014 sep 27triggers in sql serverAn Introduction to Triggers -- Part I - SQLTeam .comThis article, submitted by Garth , covers the basics of using triggers. ... Using DDL Triggers in SQL Server 2005 to Capture Schema Changes ...
     3  -2 2014 sep 16trigger update fielsSQL Server Forums - A Trigger on a specific column update - SQL Teambut I have another question, I'm now creating a FOR INSERT Trigger that checks on the coll_desc field and updates it's value as follows UPDATE trigger with specific column 21 posts15 Jun 2012don't fire trigger if only one column changed ... 13 posts10 Jan 2012 UPDATE Trigger when specific fields change ... 4 posts18 Feb 2010How to create After Update Trigger 11 posts26 Dec 2007
     3  ~ 2014 sep 14sqlserver triggerAn Introduction to Triggers -- Part I - SQLTeam.com"A trigger is a database object that is attached to a table. ... For those of you who have not worked with SQL Server 2000, you probably have not ...
     3  -1 2014 sep 12sql server trigger update columnIt's my first time to use triggers so Is there a way to create a trigger when a specific column gets updated (not the whole table)? Thanks 
     3  ~ 2014 sep 11sql server trigger updated column
     3  ~ 2014 sep 08sql find replaceThis article covers using the REPLACE function to selectively replace ... If it doesn't find anything to change it just returns the string unchanged.
     3  ~ 2014 aug 27trigger sql server"A trigger is a database object that is attached to a table. ... Internet Information Server (IIS) has logging capabilities that tracks a number of ...
     3  -1 2014 aug 21order by newidUsing NEWID to Randomly Sort Records - SQLTeam.comWe've got a quite a few articles on randomly selecting and ordering rows. I'm still amazed how popular that topic is. I recently stumbled across a ...
     3  ~ 2014 aug 17triggers sql serverThis article, submitted by Garth , covers the basics of using triggers . ... Internet Information Server (IIS) has logging capabilities that tracks a ...
     3  -1 2014 aug 16sql server trigger
     3  ~ 2014 aug 14sql server identityUnderstanding Identity Columns - SQLTeam .comKarla writes "How can I reset an Identity column and not start where it left?" I've been ... (This article has been updated through SQL Server 2005.)
     3  +2 2014 aug 09composite primary keyComposite Primary Keys - SQLTeam.comWhen you define more than one column as your primary key on a table, it is called a composite primary key . And many experienced and ...
     3  ~ 2014 aug 05sql server triggers
     3  +3 2014 aug 05check two tables sqlThe shortest, fastest, and easiest way to compare two tables in SQL The shortest, fastest, and easiest way to compare two tables in SQL ... When you have two tables (or resultsets from SELECT statements) that ...
     3  ~ 2014 aug 03replace in sqlserver
     3  -1 2014 aug 03ms sql functionUser Defined Functions - SQLTeam .comWith SQL Server 2000, Microsoft has introduced the concept of User-Defined Functions that allow you to define your own T- SQL functions that ...
     3  ~ 2014 aug 01sql server version numberSQL Server Version - SQLTeam.comSo here's an article with all the SQL Server version information I can track ... The main version number is 8.00.384 which corresponds to SQL ...
     3  +14 2014 jul 26transfer antar sqlSQL Server Forums - COPY TABLE - SQL TeamCan i copy a table (or its structure) like in Access? Thanks ... and if you also want to copy the data then remove the where clause.. Sucess ...
     3  ~ 2014 jul 26sql create triggerThe following shows how to create a trigger that displays the current system time when a row is inserted into the table to which it is attached.
     3  ~ 2014 jul 25alter table collationSQL Server Forums - change collation of table - SQL TeamHow can I change these tables to have the saem collation ? I did not
     3  -1 2014 jul 20sql server create functionIt discusses how (and why) to create them and when to use them. ... There are three types of User-Defined functions in SQL Server 2000 and ...
     4  +5 2014 oct 01sku database designSQL Server Forums - Database Design - Apparel Color/Size/ SKU - SQL Could anybody recommend an apparel SKU database design or a resource for an apparel SKU database design ? I have a good idea what I ...
     4  -2 2014 sep 28create unique textSQL Server Forums - UNIQUE text column? - SQL TeamI tried UNIQUE , msdn doesn't state that it can't be used on text columns, but the error is that an index can't be created ( UNIQUE creates one ...
     4  -2 2014 sep 28sql table unused spaceSQL Server Forums - unused space in sql table - SQL TeamI got a scripts which determines unused space in a table .
     4  +3 2014 sep 25sqlserver update innerSQL Server Forums - update with inner join - SQL TeamUpdate T set col=S.col from TargetTable T inner join SourceTable S on T.keycol= S.keycol. Otherwise post some sample data and the result you ... UPDATE with Inner Join and SUM8 postsFeb 26, 2013 Update using count and inner join5 postsMar 22, 2011 Update statement using INNER JOIN6 postsMar 9, 2011 update inner join3 postsJun 14, 2007
     4  -1 2014 sep 22connect sql server with stunnelSQL Server Forums - Connect to a remote SQL Server using stunnel I am trying to connect to a remote SQL Server using stunnel . I have already configure the stunnel .conf file on both side. When I am connect to ...
     4  +1 2014 sep 19sql express 2005 portableSQL Server Forums - How make VB+MS SQL Expr 2005 project Portable I have created one project in VB.net and MS- SQL EXPRESS 2005 , It is ... By searching on various forums, I tried creating portable project by ...
     4  -1 2014 sep 16trigger on column update
     4  ~ 2014 sep 12on primary sql serverSQL Server Forums - Create table on PRIMARY , question - SQL TeamIf I add [] around PRIMARY the error goes away. ... PRIMARY near ON specifies file group to which table is to be created. ... SQL Server MVP Automatic ID in a Primary Key?9 posts11 Feb 2008How to fix ' PRIMARY ' filegroup is full error ... 10 posts9 Feb 2008Scripting Primary & Foreign Keys Only6 posts28 Oct 2004
     4  +2 2014 aug 30finding sql server versionI can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down.
     4  +4 2014 aug 28sql restore database scriptSQL Server Forums - How to Restore Database Syntax - SQL TeamTo restore a database you need to do three things:
     4  +2 2014 aug 28get sql server version
     4  +3 2014 aug 26backup database to diskBACKUP and RESTORE in SQL Server -- Full Backups - SQL TeamThis is a very basic article covering full database backups , database restores and the ... BACKUP DATABASE [AdventureWorks] TO DISK  ...
     4  -1 2014 aug 25sql server versionsSo here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any ...
     4  +1 2014 aug 20insert into nullSQL Server Forums - Manually Insert NULL into field - SQL TeamIs there a keyboard shortcut to insert a < NULL > into a given SQL field? I th ought I read somewhere it was ALT-F4 but that doesn't seem to work 
     4  +11 2014 aug 15msdtc on serverSQL Server Forums - MSDTC on server '' is unavailable. only in I have this weird problem ... i have to db servers on different computers, ... message MSDTC on server '' (NOTE there is no servername in the ...
     4  -2 2014 aug 13locking in sql serverIntroduction to Locking in SQL Server - SQLTeam.comLocking is a major part of every RDBMS and is important to know about. It is a database functionality which without a multi-user environment ...
     4  ~ 2014 aug 11csv import sqlFast CSV Import in PowerShell to SQL Server - SQLTeam .comThese scripts use PowerShell to import and export CSV files from SQL Server. The scripts were simple to write and maintain but were slow.
     4  +1 2014 aug 08sql find and replace
     4  +1 2014 aug 05database buck up zipSQL Server Forums - Database backup ZIP and cleanup - SQL TeamEach server ised for a specific app's database and daily backup jobs are ... I would like all backups to be zipped upon creation using an ...
     4  ~ 2014 aug 01functions in sql serverThere are three types of User-Defined functions in SQL Server 2000 and they are Scalar, Inline Table-Valued and Multi-statement Table-valued ...
     4  ~ 2014 aug 01opmanager sql querySQL Server Forums - formatting unix timestamp to date in report I dont want to affect the working of the OpManager DB. ... Finally, I've written a select query to extract the data from that table and produce the ...
     4  -2 2014 aug 01sql trigger tutorialThis article, submitted by Garth , covers the basics of using triggers . "A trigger is a database object that is attached to a table. In many aspects it ...
     4  +3 2014 jul 31mssql money fieldSQL Server Forums - Money Field Decimal Places - SQL TeamI have a field in a database which is a datatype Money . When I run a select query the data is coming back with 4 decimal places like 100.0000 ... Money datatype4 postsFeb 3, 2012How to Format Currency 7 postsAug 12, 2008 Money and decimal places...10 postsMar 21, 2007 Money Precision7 postsApr 5, 2004
     4  +1 2014 jul 31select into existing tableSQL Server Forums - select into an existing table - SQL TeamI have an existing table called tblleadmanagement.
     4  ~ 2014 jul 24ms sql server versions
     4  +1 2014 jul 21sql unix timeSQL Server Forums - UNIX Time Conversion Functions - SQL TeamA common problem in moving data between SQL Server and UNIX ... The conversion of UNIX Time to SQL Server datetime is fairly trivial using ...
     4  +6 2014 jul 18sql server dos commandsHow do I use the DOS Command dir in T- SQL - SQLTeam .comOne additional caveat is that this is Windows 2000 Server and up. Windows NT produced different ouput results from the dir dos command .
     4  +27 2014 jul 17dbmail server smtpDatabase Mail Configuration - SQLTeam.comI recently had to setup Database Mail on dozens of SQL Server ... be required depending on your SMTP server authentication and you will of ...
     5  -1 2014 oct 03retecfing server infoSQL Server Information at SQLTeam.comNews, technical articles, and your SQL Server questions answered free by experts.
     5  -1 2014 oct 02sqlexpress allow reserved wordsSQL Server Forums - Dynamic Crosstab in SQLExpress - SQL TeamI am using SQLExpress and when i try to save the stored procedure it did not allow me to. I used it ... Pivot is a reserved word in SQL 2005; try replacing the name used in the article with something else, such as "Pivot2". - Jeff
     5  -3 2014 sep 30sqlserver 19456SQL Server Forums - Error 19456 . - SQL TeamGeneral SQL Server Forums · New to SQL Server Programming Error 19456 . ... login failed" (Error 18456) error messages in SQL Server 2005 ... File deletion script.4 posts22 Aug 2006 SQL Server Parent Child Relationship2 posts4 Sep 2002
     5  +5 2014 sep 28char 10 char 13SQL Server Forums - replace char ( 10 ) & char ( 13 ) in a text field replace char ( 10 ) & char ( 13 ) in a text field. I have a text field that has multpile char ( 10 ) & char ( 13 ) i want to select replace with '*' any help ...
     5  +1 2014 sep 28programmers heavenProgrammers Heaven - Where programmers go! - SQLTeam.comNET , Java, and other tools for programmers and developers. Here you will ... Follow the link to Programmers Heaven - Where programmers go!
     5  ~ 2014 sep 22trigger on one columnSQL Server Forums - don't fire trigger if only one column changed There is a trigger on this table that I want to fire if any field other than " lastloggedin" changes. ... Men shout to avoid listening to one another.
     5  +4 2014 sep 16formatting im mssqlHow to format a Date or DateTime in SQL Server - SQLTeam.comIf you use CONVERT() in an attempt format your DateTime data, remember that it physically converts that data from DateTime to another data ...
     5  +5 2014 sep 14set trigger on particular columntriggers so Is there a way to create a trigger when a specific column
     5  -3 2014 sep 12sp executesql new lineSQL Server Forums - how to use use sp_executesql - SQL Teamhow to use use sp_executesql , New Topic · Reply to Topic
     5  +8 2014 sep 11data source shared hosting windowsSQL Server Connection Strings - SQLTeam.comAll connection strings share the same basic format, name/value pairs
     5  +26 2014 sep 10set global sql" Global variables" in SQL Server - SQLTeam .comThere's no such thing as a global variable in SQL Server. ... FROM sp_globalVariables WHERE varName = @varName SET NOCOUNT OFF ...
     5  ~ 2014 sep 09create table identityUnderstanding Identity Columns - SQLTeam.comIn it's simplest form an identity column creates a numeric sequence for you. You can specify a column as an identity in the CREATE TABLE  ...
     5  ~ 2014 sep 08kathi kellenbergerKathi Kellenberger - SQL Server Articles at SQLTeam.comKathi Kellenberger is a DBA for Bryan Cave LLP, an international law firm headquartered in St. Louis. She is a SQL Server MVP, co-author of "Professional SQL ...
     5  -1 2014 sep 02sql server import csvFast CSV Import in PowerShell to SQL Server - SQLTeam.comI recently had to write some simple scripts for a proof of concept. These scripts use PowerShell to import and export CSV files from SQL Server .
     5  +25 2014 aug 30sql tree-based retrievalMore Trees & Hierarchies in SQL - SQLTeam .comHierarchies are sometimes difficult to store in SQL tables
     5  +31 2014 aug 27insert if exist updateSQL Server: Best way to Update row if exists , Insert if notUpdate ... if rowcount = 0 insert . 2. If row exists update else insert . First let's create our test table: USE tempdb IF OBJECT_ID('t1') IS NOT NULL ...
     5  -2 2014 aug 24sql bulk insertUsing BULK INSERT to Load a Text File - SQLTeam .comThis example combines dynamic SQL , BULK INSERT and the proper handling of double-quotes to solve a client's problem with loading various ...
     5  +2 2014 aug 24csv to sql server
     5  +3 2014 aug 23mssql mdf ldf backupSQL Server Forums - Difference between .bak & . mdf , . ldf - SQL TeamMicrosoft MVP for Windows Server System - SQL Server
     5  +22 2014 aug 22ms sql indexSQL Server Indexes : The Basics - SQLTeam .comIndexes directly affect the performance of database applications. ... Microsoft SQL Server 2000 Index Defragmentation Best Practices (2 May ...
     5  +3 2014 aug 18dynamic sql functionSQL Server Forums - Dynamic sql inside function and return value Is it possible to write dynamic sql on scalar function and assign the value to return value? I like some thing like below but it is not working.
     5  -1 2014 aug 16sql search and replaceSearch and Replace in a TEXT column - SQLTeam .comTo make things a little bit more complicated (and so more close to real world problems), we also need to find and replace a text value in the ...
     5  ~ 2014 aug 12insert from selectUsing SELECT to INSERT records - SQLTeam.comQuestion: Is there a way I can use just ONE insert statement to do all this? Sort of like incorporating the select statement into the insert statement ...
     5  +6 2014 aug 05sql server database schemaUnderstanding the Difference between Owners and Schemas in SQL Server 2005 introduces the concept of schemas as opposed to ... Most of the time, the owner is “dbo”, also known as the database owner.
     5  +10 2014 aug 05sql tree queryHierarchies are sometimes difficult to store in SQL tables...things like trees , ... and you can find their coworkers by querying the BossID column.
     5  +5 2014 aug 05small database scriptSQL Server Forums - Shrink DB File by Increment to Target Free This script can be used to shrink a database file in small increments until it reaches a target free space size. It will loop to execute the DBCC ...
     5  -2 2014 aug 02create function sql server
     5  ~ 2014 jul 31sql server service packI'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on ...
     5  +1 2014 jul 31sql database restore scriptScript Library How to ... To restore a database you need to do three things: ... You can also interrogate the SQL Server to see dates/times, and ... Backup/ Restore script for all Databases in ... 2 posts16 Nov 2010 Database Restore on Existing one with same ... 7 posts25 Aug 2005 Restore WITH MOVE8 posts14 Apr 2005 Restoring .BAK file to a different server ... 15 posts4 Oct 2004
     5  +21 2014 jul 31sql data recoveryIn management studio ( SQL 2005) the database appeared as databasename(in recovery ). I have subsequently gone back in to check and the ... SQL Server Forums - Solution for SQL Database ...7 postsApr 10, 2013 SQL Server Forums - Data Recovery In SQL Server9 postsAug 18, 2011 SQL Server Forums - Database in recovery mode5 postsApr 30, 2009
     5  -1 2014 jul 29transaction sql serverIntroduction to Transactions - SQLTeam .comis a transaction even though it doesn't do much. It's called an Autocommit transaction . SQL Server first writes to the log file what it's going to do.
    1 2 of 24 pages