CS-SQLServer

0) sample sql code (25-May-20)

1) SQL Examples XRef (25-May-20)

2) sql quick journal (24-Mar-20)

3) SSMS: Sql Server Management Studio notes (22-Mar-20)

4) Guidelines for data modelling (28-Feb-20)

5) SampleStoredProc1 (6-Feb-20)

6) SQL Server 2019 installation (11-Jan-20)

7) Database questions (5-Jan-20)

8) Sample code: A few sample stored procs (3-Jan-20)

9) composite keys (3-Jan-20)

10) SQLServer user permissions to execute Stored procedures (19-Jun-17)

11) Please declare all your strings as nvarchar in SQL Server, including stored procedure params (30-May-17)

12) What are key SQL Server Resources? (30-May-17)

13) SQL Server and SSDs: The nasty dependency (27-Apr-17)

14) Preparing SQLServer for UTF-16 (27-Apr-17)

15) Open sourced web based database client software (31-Aug-16)

16) Basic DB2 syntax and a few other things (27-Aug-16)

17) How do I pass an exit code from sqlcmd? (15-Aug-16)

18) How do I schedule a backup database program on windows servers? (13-Aug-16)

19) How do I define a column to be a primary key in tsql? (28-May-14)

20) Sample code snippet for a SqlServer View (21-May-14)

21) What does dbo stand for in sql server? (24-Apr-14)

22) A list of databases in the market place (6-Aug-13)

23) Speaking of No-SQL databases: A look (5-Apr-13)

24) sql server in clause and null set (16-Nov-12)

25) in clause in stored procedures (16-Nov-12)

26) How can i backup and restore a SQL server database? (12-May-12)

27) Can I create a unique index on a column that allows nulls? (9-May-12)

28) What is SQL Server Browser service? (1-May-12)

29) t-sql code for altering/creatign indexes (10-Jan-12)

30) Here is what sql manager does to alter the identify of a column (10-Jan-12)

31) How can I generate SQL script to regenerate/document tables in sql server? (9-Jan-12)

32) Understanding star schemas (5-May-10)

33) MYSQL Notes (18-Nov-06)

34) How to do subselects in a where clause (22-Apr-06)

35) Common table expressions (26-Nov-04)

36) How to limit rows from database queries (12-Aug-04)

37) Mastering Oracle SQL from OReilly (22-Mar-04)

38) Learning SQL from w3schools.com (22-Mar-04)

39) Notes of a java programmer on understanding and effective use of joins in select statements (20-Nov-03)

40) A sample sql server view (13-Oct-03)

41) Sample code for a function (26-Sep-03)

42) One quick way to document joins in SQL/Stored Procedures (13-Jun-03)

43) How can I use outerjoins in SQL Server? (11-Jun-03)

44) How to use sp_help? (11-Jun-03)

45) How can I execute a stored proc? (11-Jun-03)