Exporting from Excel to SQL
In few business applications inputs to the system is in the form of an TXT / CSV / Excel file(s).This script will help how to upload an Excel file in to SQL Server.
2003-04-10
514 reads
Scripts
Get Relationship for your tables
Use this script to get relationship between ur tables (PK, FK), if defined. This script will give you base table and its columns (PK) with other related tables and columns (FK).So, no need to check in the diagram.Mohit NayyarMCP, MCAD (.Net), MCSD, MCDBA
2003-04-10
784 reads
List the current user list on given database
How to get a list of the users logged on to a specific database ? (instead of SP_WHO)
2003-04-09
336 reads
Running Total without using of Cursor
Script for computing Running Total on Table without using Cursors.
2003-04-09
412 reads
Script tables to emulate Copy in Enterprise Manage
This script will produce the same output as doing a Copy in enterprise manager and then pasting into Query Analyser.It can handle Clustered and Nonclustered Primary Keys, Multiple Foreign Keys, Defaults, Constraints, Identity Fields. If you are able to improve this script, or find any bugs, please let me know.
2003-04-09
183 reads
Clear all user objects
This procedure will drop (with care) all user-defined objects: constraints, procedures, functions, triggers, views and tables. Used for re-creating database schema without drop and create database.
2003-04-07
134 reads
Get File and Maximimum Size by Drive Letter
Utility Script to assist when you are thinking about expanding a database file. When Used in combination with srvinfo you can know just how far you can expand a file to keep the maximum file sizes from getting over the capacity of the drive.
2003-04-07
235 reads
Number of days for a given month
Use this function to get the number of days in a given month.Mohit NayyarMCP (.Net), MCSD, MCDBA
2003-04-06
425 reads
To retrieve Stored Procedure Parameters with Description
Use this procedure to get parameters for your stored procedure with data type,length, parameter position and also the mode of parameter (Input or Output). Can be used to populate the dynamic parameters for any procedure. Mohit NayyarMCP (.Net), MCSD, MCDBA
2003-04-06
941 reads
View Input Buffers for all SPIDS
This procedure, sp_AllInputBuffers, uses dynamic T-SQL to generate and execute the DBCC INPUTBUFFER statement for each server process (except yours). Perfect for performance troubleshooting situations, when you want to see what commands are being executed against your server. Also, a great example of the power of dynamic T-SQL.For the @exec parameter, pass 1 or leave […]
2003-04-04
667 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat BCA KCU MATRAMAN Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur, Daerah...
Alamat BCA KCU CIANJUR Tlp,Cs:0821-8154-393
WA:08218154393 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers