Links to SQL Articles
- by Baskar B.V
This post would be updated with links to nice articles which i would come across in SQL Server (database).
Default Trace in SQL 2005:
http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/
Search Results
Search found 28540 results on 1142 pages for 'sql triggers'.
Page 306/1142 | < Previous Page | 302 303 304 305 306 307 308 309 310 311 312 313 | Next Page >
-
-
SQL Server 2008 message box - Unable to edit the table property
SQL Server 2008 message box - Unable to edit the table propertyRead the article
-
Get month from the datatime column in SQL Server
Get month from the datatime column in SQL ServerRead the article
-
Why is Web SQL database deprecated?
- by user221287
I am making a hybrid Android app. At first I decided to use localStorage, after spending 2 days, I realized that it is very strange and so dropped it. Then, I picked up indexedDB, after spending today's whole day and actually getting the output in Google Chrome, it is not running inside a WebView of the android app. And I never used Web SQL database at all because it was deprecated. Anyhow, it has come to my notice that PhoneGap still uses Web SQL and android's browsers support it. Why was Web SQL deprecated in the first place? And will it be a good idea for me to go with Web SQL now?Read the article
-
Set Vs Select statement in SQL Server
Set Vs Select statement in SQL ServerRead the article
-
SQL Server Service Broker - An Introduction
SQL Server Service Broker (SSBS), introduced with SQL Server 2005 and enhanced in SQL Server 2008, allows you to write queuing/message based applications within the database itself. This article discusses SSBS' important features and how to use it in different scenarios.Read the article
-
SQL Server Technology Thirst
SQL Server Technology ThirstRead the article
-
Remove common substring from the strings in a column in SQL Server
Remove common substring from the strings in a column in SQL ServerRead the article
-
SQL SERVER Interview Questions
SQL SERVER Interview Questions contains 1 General Questions of SQL SERVER...…………………… 2 Common Questions Asked……………………………………… 3 Questions of SQL SERVER 2008……………………………Read the article
-
Inline variable assignments in SQL Server 2008
Inline variable assignments in SQL Server 2008Read the article
-
Find index associated with the table in SQL Server
Find index associated with the table in SQL ServerRead the article
-
Keyboard Shortcuts in SQL Server
Keyboard Shortcuts in SQL ServerRead the article
-
SQL Server Stored Procedures Comparer
Windows application that compares stored procedures between two SQL Server databaseRead the article
-
How To Check Duplicate data in sql
In Sql Hw to check duplicacyRead the article
-
Basics of SQL Server 2008 Locking
Relational databases are designed for multiple simultaneous users, and Microsoft SQL Server is no different. However, supporting multiple users requires some form of concurrency control, which in SQL Server's case means transaction isolation and locking. Read on to learn how SQL Server 2008 implements locking.Read the article
-
Basics of SQL Server 2008 Locking
Relational databases are designed for multiple simultaneous users, and Microsoft SQL Server is no different. However, supporting multiple users requires some form of concurrency control, which in SQL Server's case means transaction isolation and locking. Read on to learn how SQL Server 2008 implements locking.Read the article
-
LINQ to SQL Performance Considerations
Performance considerations when using LINQ to SQLRead the article
-
SQL server Interview queries
SQL server Interview queriesRead the article
-
SQL server Interview queries
SQL server Interview queriesRead the article
-
Importing data from spreadsheet (xls) to SQL database
CSV 2 SQL Script GeneratorRead the article
-
Error in inserting records in SQL Server
Error in inserting records in SQL ServerRead the article
-
Enable xp_cmdshell in SQL Server
Enable xp_cmdshell in SQL ServerRead the article
-
sp_who and sp_who2 in SQL Server
sp_who and sp_who2 in SQL ServerRead the article
-
????????PL/SQL ??????Tips
- by Yusuke.Yamamoto
????? ??:2005/05/02 ??:?????? PL/SQL ????????????????·??????·???????????? PL/SQL ?? ?????????/ DBMS_OUTPUT?UTL_FILE?DBMS_SQL?DBMS_PIPE?DBMS_ALERT?DBMS_JOB?DBMS_UTILITY?DBMS_LOCK.SLEEP?DBMS_RANDOM?DBMS_OBFUSCATION_TOOLKIT?DBMS_CRYPTO?UTL_SMTP?UTL_MAIL ?????/?????? ?????? PL/SQL ????? PL/SQL ??????? ????????? ????????????????? http://otndnld.oracle.co.jp/tech/pl_sql/pdf/plsql_tips10g.pdf(10.1.0 ???) http://otndnld.oracle.co.jp/tech/db_connect/pdf/PLSQL_TECH.pdf(8.0.5 ???)Read the article
-
How to build a setup package for a desktop application using SQL CE 3.5 and Entity Framework?
- by Emad
I am having a WPF desktop application that uses SQL CE (compact edition 3.5 ) and using the Entity Framework as a Datalayer. As It turned out in (http://support.microsoft.com/default.aspx?scid=kb;en-us;958478&sd=rss&spid=2855 ) and (http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/b6bac277-cf66-4c74-a0b3-e48abedbd161/ ) There Is some problem with the Entity Framework and SQL CE and I had to get the hotfix (basically a new build of the SQL CE called 3.5.1) My problem now is how to build a setup package in order to make it work in case some users already had the SQL CE 3.5 installed on their machines? I have included the DLLs directly in the application but when the sql ce is installed, its DLLs are in the GAC and have precedence over the local ones and the application crashes. I need the build a setup that would work "even if" the user already had the old buggy version.Read the article
